Merging Mutiple Sheets column data when if conditions passes [Closed]


I have excel book with multiple sheets.

Rows count with data will differ in each sheets.

And column C with have two data "Come" & "Out"

What I want is, from each sheet, when cell value of column C is "Out" then the adjacent cell value in column B needs to copied to Column A of main sheet called "Main".

And to make identification in the main sheet, Column B needs to have a data of a particular cell (Say it as "A3" of the respective sheets)

For example, If you have copied data to the main from Sheet1 at A1, A2, A3, A4, A5 then I want B1, B2, B3, B4, B5 should be same value of Cell "A3" of Sheet1

There may few sheets where I don't have "Out" in Column C, For that I don't require any details in main sheet.

And Since we have made unique identification of copied cells, I don't required any empty rows to be given in between the data copied from multiple sheets.

Hope you have understand my query.


Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!