CODEWITHSUNDEEP
excelexcel-formulaexcel-2010excel-2007
The Great
The Great

Reputation: 7723

How to filter and merge data from multiple sheets using excel

I have an excel file with 3 sheets. File can be downloaded from here

sample sheet looks like below

enter image description here

From all the 3 sheets, I would like to copy only rows with criteria Product = X and put it in one final sheet.

3 sheet names are sheet1,sheet2,sheet3. Is there any formula that you can help me with?

I am unable to attach a sample excel file in stack overflow.

Currently am doing this manually. Can you help?

Upvotes: 0

Views: 1123

Answers (1)

Troystav
Troystav

Reputation: 1

You could use a power query (connection only) to get the data from each of the 3 sheets, then do a union (append) power query of those 3 connection only sources into a new query and return the data to a table on another sheet. Get the combine/append query here Clarification: you might want to turn your source data into tables first, which could be helpful if the range changes

Upvotes: -1

Related Questions