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.
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.
Yes That can be done can you please upload a sample book with your desired results !
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
sample.xls
Please se attachment.
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
Last edited by hemesh; 01-27-2014 at 04:26 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks