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 Tabs B, C, D, etc. Does anyone have any idea how to do that? I know it is a simple process, it's just been 15 years since I needed to do it so I cannot remember how.
- 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.
11 Replies
Kage2023 there are a few options and copy and paste actually is one in that you can copy and paste special and choose paste link, which will paste a link to the values so as the originals are updated so are the 'pasted' values. But more often this type of action is going to be done using pivot tables, power query or the new FILTER() functions. Depends on what you need. If the portion of data is a 'pivot' of the original, vs just a filter of the original or is it more of a 'random' selection from the original.
- Tab A has 10 different suppliers with # of deliveries, # on time deliveries, % of on time deliveries, etc. Tabs B-K are each suppliers stats only. So I need stats from Tab A for "Supplier 1" to be the only data on Tab B, "Supplier 2" to be the only data on Tab C, etc.
- 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.
