I know in the distant past I know I have done what I need to do, but I can't recall if it was in Access or Excel !

Basicaly I have a number of buildings, Building A, Building B etc etc. Each building has running cost associated with it ie gas, elec, maintenance etc.

So I want to put financials against the different running costs, and be able to show the result for each building. I think in the past I did this some how by creating a list of buildings on a pull down list, and then I could enter the required costs for each building.

Can this be done in excel, or am I going mad and its Access?

Ta

You could filter your columns and then filter on each building.

Alternatively a pivot table would also work.

Pivot table in Excel will do the job nicely.

pivot table to get results, but i would suggest using validation to restrict what you enter into certain cells. It can be a real pain if you have similar names in cells rather than exactly the same name.