Brendan Wilson
asked on
How do I insert data from multiple tables into 1 table without the data duplicating?
I have an excel sheet with 6 different room types in a hotel. These room different items and quantities of those items in each room. One room may have 2 lamps, where as the other may have 1. I need to insert the aggregate data into 1 table in order to make an accurate budget of all the items that I will order.
Hotel-1.xlsx
Hotel-1.xlsx
ASKER
Yes, if there is a way to do the descriptions as well that would be useful, I placed all of the descriptions manually.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for the assitance. This is exactly what I needed.
You're Welcome Brendan! Pleased to help :)
Do you mean you need to update Quantity from all the sheets to Budget Sheet as per Sheet name?