Forum Discussion
Solved
Duplicate data to other tabs
I have data in Tab A that I need to add only certain ROWS of into Tab B, Tab C, etc. Copy and paste does not copy the DATA, as information is updated in Tab A, it needs to automatically update in Tab...
- Sounds like a perfect job for a pivot table. I would also recommend instead of creating a new tab for every vendor just create 1 "report" tab and you can select which vendor using a filter or slicer. Just imagine you have 100 suppliers and need to create 100 tabs and even worse try to find a particular tab among those 100 not to mention potential file issues. Instead you have your main data, a tab for 'supplier' and you could have other tabs line 'month' for monthly summaries or 'delivery stats' or etc.... Much more efficient and readable.
Kage2023 OK so I changed you 'pivot table' tab to 'supplier summary' and 'Year Summary' tabs and added slicers to each. Basically instead of all those individual tabs and linked tables you have ONE for all Suppliers and you just select the filter for which company(ies) you want to view/print. You can then also do this idea for other ways to view/filter the data. For example the 'Year Summary' tab looks at the data based on the Date and you could group by year or month or week if you wanted. Instead of the slicer I used you can also use a 'Timeline' slicer to have even more control over the time range.
A lot of it depends on what info you need/want.
