Hi,
I am trying to make up a spreadsheet for my mother to help save her some time as doing the following manually is just becoming too much.
I have made a Google Sheet here - https://docs.google.com/spreadsheets/d/1KQAvNCChTWusMw6Tlwcx9GfZfszXSX_eJUAhnaz_wO4/edit?usp=sharing
Essentially, each tab will be named after a person who is looking to order certain items for a catalogue. The information required has already been put into the spreadsheet in Row A of each sheet.
What I am struggling with is trying to then collate all orders into one page so that all the same items are added together i.e.
Tom wants 3 of item A and 5 of item B and 2 of item C
Jim wants 2 of item B, 3 of item A and 5 of item D
Bob wants 4 of item B, 3 of item C and 4 of item E
I am looking to have the "order" page collate them so that it will be like:
Item A - 5
Item B - 8
Item C - 5
Item D - 5
Item E - 4
But also pull through the order numbers and page numbers and costs per unti into the final "Order" sheet.
Unfortunately I dont have the full list of order or page numbers so I am trying to get it to fill in the list dynamically if that make sense i.e., it pulls the first item and then searches for the same item across all other sheets and pulls them altogether into a single row, it then finds the next unique item and pulls it across and then finds all similar items and pulls it across.
I am hoping this makes sense and someone can help??
Thanks
I am trying to make up a spreadsheet for my mother to help save her some time as doing the following manually is just becoming too much.
I have made a Google Sheet here - https://docs.google.com/spreadsheets/d/1KQAvNCChTWusMw6Tlwcx9GfZfszXSX_eJUAhnaz_wO4/edit?usp=sharing
Essentially, each tab will be named after a person who is looking to order certain items for a catalogue. The information required has already been put into the spreadsheet in Row A of each sheet.
What I am struggling with is trying to then collate all orders into one page so that all the same items are added together i.e.
Tom wants 3 of item A and 5 of item B and 2 of item C
Jim wants 2 of item B, 3 of item A and 5 of item D
Bob wants 4 of item B, 3 of item C and 4 of item E
I am looking to have the "order" page collate them so that it will be like:
Item A - 5
Item B - 8
Item C - 5
Item D - 5
Item E - 4
But also pull through the order numbers and page numbers and costs per unti into the final "Order" sheet.
Unfortunately I dont have the full list of order or page numbers so I am trying to get it to fill in the list dynamically if that make sense i.e., it pulls the first item and then searches for the same item across all other sheets and pulls them altogether into a single row, it then finds the next unique item and pulls it across and then finds all similar items and pulls it across.
I am hoping this makes sense and someone can help??
Thanks
