Forum Discussion
Copying and updating data in different sheets
I have one sheet that is a master list of data with links to different sheets in one column. Each sheet has a section that is copied and linked to the master sheet. When I update data in the individu...
I would suggest to keep the "original" data in the master sheet and edit it there, rather than the other way around. Then you can use fucntions like INDEX and MATCH to pull the relevant information into the individual sheets from the master table. You should look at your individual sheets as "just another view" of your data. In fact, doing it this way may mean you only need one (flexible) individual sheet!