I thought my problem was solved ... but now I have another dilemma. I have added the names to the total column and the subsequent tabs don't change. I started doing it manually and thought there has got to be a better way. That is one issue.
The second issue is I can't seem to get the numbers to subtract from the total (See Diane Cantey for example). I place the time in and it does not show up in the total tab.
Please help again! Document attached.
Hello Welcome again ! It is working correctly checked right now
To change name in all sheets select sheet total sheet press shift and select december sheet while holding shift and change the name anywhere it will be updated across the sheets
Click " * " if it solves your query and mark thread as solved
I dont understand what isnt working for you?
I entered values in January C7:E7 and then again in C22:E23 and the formulas in TOTAl updated acdcordingly?
On a side note, yiou dont need to use =SUM() when you are just referncing 1 cell, you can just use =January!AH7
Also, if you name your sheets the same as you name the column headings (or the other way round), then you could use something like, copied down and across...
=INDIRECT(C$6&"!AH"&ROW())
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Maybe it is because I am using Excel 2010, because the options are not working for me!
you have Sheets tabs at the bottom like Total, January , february , March .........Till december
Select Total sheet Tab HOLD SHIFT AND SELECT DECEMBER sheet TAB. Then GO TO ANY TAB CHANGE NAME AND SEE EVERY SHEET NAMES WILL BE CHANGED
Click " * " if it solves your query and mark thread as solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks