Summarizing data from multiple spreadsheets onto one

Topic

New Reply

Hi, I want summarize data from multiple spreadsheets onto 1. I’m working with dates and text not numbers.

How can I do that? Attached for review is a sample.
Thank you for your time. .

Reply | Quote

Replies

Dear ab2537:

Attached is a solution based on Hlookup formula. Right now it picks up rows 3 – 75 on both worksheets. But can be modified to include more rows if needed. I also put in a special ID formula to better track where the data is coming from.

This approach is flexible and would allow you to added more columns to the Master based on the Columns in the Data sheets.

Hope this helps

DuthieT

Reply | Quote