Forum Discussion
How do I auto-populate information from one tab to another in sheets?
- Are you willing to manually enter the name of each new tab into a cell on the "Master" sheet?
- Is all the information on each individual sheet organized in exactly the same way? Are they all laid out identically?
- Finally, could you upload a sample of the actual master and backup sheets?
If the answers to #1 and #2 are both "Yes," then it should be fairly easy to write a formula or two that would retrieve the information from each new sheet and populate the master sheet with the data. But an actual example of your workbook (devoid of any confidential or personal information) would be most helpful.
I think I have a similar question. I have uploaded a spreadsheet that has 3 tabs. Some of the information on Project Info/Control sheet I would like to repeat on the Budget Sheet and Proposal Sheet to reduce duplication of effort. I can get it to 'behave' on the Budget Sheet (green circle in screen shot), but not on all cells of the Proposal Sheet (red circles). It just shows the formula referencing the original cell instead of the data. I have tried inserting new rows on Project sheet and re-referencing to see if something is corrupt but I get the same problem. I saw your INDIRECT solution but I don't think my need is that complicated. Any thoughts would be appreciated.
- Much more simple. You have those cells formatted as "Text"...change them to "General" and reenter the formula.