Hi,
Any help would be appreciated.
I have a list of budgets on a summary page. They correspond to a tab name with the budget detail.
I want the formula to automatically pick up the tab name from the list.
How can I use the list from the summary to point to a cell within a budget tab. an example is attached.
I realise some of the formulas on the detail tab need to be sorted but I needed to remove some sensitive work info from it :o) (Dont want to be losing my job)
Any suggestions on how you think I could improve the sheet would also be greatly appreciated.
Last edited by deanJ; 10-12-2009 at 07:41 PM.
Which is your summary tab?
And which formulas need to be changed?
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Just realid the spread is missing a lot of info. I will sort it out and repost it so it is easier to understand and thus get the best results from and help you may give :o)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks