Forum Discussion
How do I auto-populate information from one tab to another in sheets?
I have an excel sheet with several tabs. The first tab is the Master tab used to track all tabs. I would like all new tabs to auto-populate information into columns on the master tab. For example, I ...
Thank you for posting this solution, but I'm having difficulty getting it to work correctly. Using your example =INDIRECT($A5&"!"&C$8) where cell A5 on the current/active worksheet contains the tab/worksheet name on which the cell C8 contains the data I want to show up in this cell. I received an error. Then, I tried to put the cell name from the "back up" worksheets in a row across the top of the master worksheet and instead of referring in the indirect formula to the cell on the other worksheet, I referred to the one on this one that had the address, which I think is what you described. I still received an error. Is it a problem that my tab names are numbers like this "21-001"? It obviously works if I manually identify the worksheet in the formula (i.e., =21-001!$C$8). but then I'll have to change the formula for each cell across and down as I copy the formulas down the worksheet. Did I misunderstand the parameters in the formula? What am I doing incorrectly?
You're coming in to the middle of a conversation which already had TWO other people asking the question. It took me a while to realize you weren't just the prior person asking a follow-up question.
It's generally better to start a new thread. In this case, it would also be helpful if you posted a copy of the workbook you're working with.
It's generally better to start a new thread. In this case, it would also be helpful if you posted a copy of the workbook you're working with.
mathetes - my apologies for the confusion. I'll attach the document I'm working on - data listed is fictitious to see if it the functions in there so far are working. I'm trying to get the "high level" data from each project detail sheet to auto-populate into the summary log so that it can be reviewed "at a glance", but without having to edit the formula in each cell to change the worksheet name from which it is pulling. It seems like the "indirect" function should work, but I must have syntax incorrect or something. Thanks in advance for your assistance.
The tab names were the problem, not the formula. I changed them to text and they worked. I used the people's initials which is most likely not what you want, but you can change it and it'll work.
