I have six (6) spreadsheets with Names and Room #'s and total charges on them. The charges on each sheet are for different items and the names might not appear on each sheet. I want to list the names and Room #'s from each sheet and the charges associated with each name. I only want the names to appear on the total sheet if that name had charges associated with it. My sheet names are "3rd Meal Report", Tray Charges Report", Guest Ticket Report", "Storage Report", "Laundry Report", and "Copies Report". Each sheet contains these columns: Resident, Room # and Total Charged. My total sheet has the columns as the name of the sheets.
I would like to see something like this: Resident Room 3rd Meal Trays Guest Tickets Storage Laundry Copies Kirk J | 114 | $25.00 | $10.00 | $55.00 | $25.00 | $15.00 | $2.50
Any help on this would be greatly appreciated.
Thanks,
Kirk J.
I would like to see something like this: Resident Room 3rd Meal Trays Guest Tickets Storage Laundry Copies Kirk J | 114 | $25.00 | $10.00 | $55.00 | $25.00 | $15.00 | $2.50
Any help on this would be greatly appreciated.
Thanks,
Kirk J.
