Excel Q&A
Ask your geeky hard core Excel questions here!
Questions/Discussions
Sort by Date ▼ / Top Rated
Register for free or log in at the top right of this page to join the discussion
Creating a summary page for dozens of tabs
I have 200+ tabs of individual account data. I am working to have a summary tab pull in information from the same cell on every worksheet. Currently, my only solution is to copy/paste the formulas and ctrl+f and replace the tab titles. Is there a way to speed this process up? Or, is there a way to r...
I have 200+ tabs of individual account data. I am working to have a summary tab pull in information from the same cell on every worksheet. Currently, my only solution is to copy/paste the formulas and ctrl+f and replace the tab titles. Is there a way to speed this process up? Or, is there a way to reference a cell that contains the tab titles?
Read More
Show All 1 Replies
Login to Reply
1
by Christopher B.
added 9 years ago
