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 ...
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.
