Consolidating Worksheet Data

**rj_yan** · 01-27-2014, 04:01 AM

Hi I need some help.

Anyone knows how to consolidate all data from all worksheets into a single worksheet(master sheet)?

Untitled.png

In the attachment, data for worksheet 1 will be added to the masterlist and worksheet 2 will follow.

**hemesh** · 01-27-2014, 04:03 AM

Yes That can be done can you please upload a sample book with your desired results !

**rj_yan** · 01-27-2014, 04:13 AM

sample.xls

Please se attachment.

**hemesh** · 01-27-2014, 04:24 AM

Hello Rj_yan copy paste below in B2 and drag down
=IF(A2="","",INDIRECT("'"&A2&"'!"&"B"&SUMPRODUCT(--(($A$2:A2)=A2))+1))

expecting your data starts from second row and in B column if it starts from somewhere else you need to manage red colour which is B to your desired column

if this is helpful Click "*" add rep icon in the bottom left corner of my post