Forum Discussion
How do I auto-populate information from one tab to another in sheets?
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.
- Thank you so much!
I think I have the same question as others here, but I am not clear on how to make INDIRECT (if appropriate) apply to my situation.
I want to fill a column with the following references:
=Sheet2!$D$2
=Sheet3!$D$2
=Sheet4!$D$2
In other words, I want the value from a specific cell (D2) in each sheet to fill a column.
Does INDIRECT make sense here?
Debbie
I'm look at doing the opposite of what the spreadsheet is showing here. I would like to be able to take the data in the table and put it in a form. How would I do that?
Thanks,
Chris
- So I'd seriously suggest starting a new thread, with a bit more information. And, if possible, a copy of whatever you're working with.
