Please be patient with me....I am somewhat a "rookie".
I am working in a workbook with 8 sheets. One of the sheets is a "summary" page. What do I need to do to have the totals from other sheets automatically transfer to the proper cell on the "summary" page?
I know it can be done....I did it previously but have no clue as to what I did....lol.
I look forward to and will really appreciate any and all help.
Thanks
Hi, welcome to the forum
Probably a number of ways to do this, but almost impossible to suggest anything without seeing a sample of what you are working with?
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
Thank you for getting back to me so quickly!
What info do you need to help me? Should I attach the workbook? The sheets each deal with hours of different training for each of our fire fighters. The sheet I am having difficlties with is the summary page. Each fire fighters name is on all sheets and I would like to have the total of each of the training sheets transfer to the summary page. For example, on the "fire response" sheet the total for our fire chief is located in cell Z3. I would like to have that number transfer to the "summary" sheet into cell F3. Would something like the following work.....('Fire'!Z3) work? I have that scribbled in my notes from when I did this workbook a few years back. This workbook is used by our training coordinator and he has deleted this function and I have to correct it. Once finished this time, the workbook will be protected!
Thanks again for all your help! It is really appreciated.
Yes, please upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
Once again, thank you so much for getting back to me so quickly!
I am attaching the a couple of pages of workbook that I am working on. Under the "Fire" page I would like to have the totals in column Z transfer to column F on the "Summary" page. I hope this helps.
Thanks again for all your help...it is greatly appreciated.
I must apologize for not getting back to you sooner, something came up here, and I was afk.
Also, I should have read your post 3 more thoroughly, because you basically had what you wanted there...
=Fire!Z3
(note that you have "CAMPBELL, DAVID" on Summary, but "CAMPBELL,DAVID" (no space) on Fire sheet. You should correct this)
If you want to get a bot more involved, and if you have named your sheets the same as your headings, we could use this instead...
=IFERROR(INDEX(INDIRECT("'"&F$1&"'!Z:Z"),MATCH('Summary '!$A3,INDIRECT("'"&F$1&"'!A:A"),0)),"")
It will take the name in Summary A3 (for instance) and search for that name in Fire sheet, and bring back the corresponding name from column Z.
This means that you now dont have to have the names in the same order, nor do you need to hard-code the sheet name for each sheet you have (as long as teh sheet name matches the heading)
No need to apologize....I was without internet yesterday (snow storm) so the delay didn't matter....lol
The sample workbook I sent you did not have all the sheets in my actual workbook. My actual workbook has a total of 10 pages with one of them being the summary page. The name lists on all the sheets are the same. Does what you mentioned above work in that instance also? As for what I had =Fire!Z3 would work with just having to change the name of the sheet right? And is that the proper formula =Fire!Z3?
Once again, thanks for your patience and all your help! It is very much appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks