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.
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.
- THAT is the kind of advice/answer I was looking for! You are the best! Thank you so much, I will try that right now!
- You are very welcome and if you need help let me/us know. If you supply a sample sheet with sample data (no personal or confidential data) but set up in the way you want and say how you want to see it, we can usually help. But if you can figure it out yourself, you tend to learn even more and will be much more equipped to update, fix, or expand 🙂
- None of the information in the spreadsheet is confidential, how can I supply the sample? Can I post the full spreadsheet workbook on here?