MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
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.