Hello
Look at attached file
I would need to be able to retrieve to one sheet all the data from multiple sheets so that one has new column that tells which sheet the data was retrieved from.
Can this be done?
Hello
Look at attached file
I would need to be able to retrieve to one sheet all the data from multiple sheets so that one has new column that tells which sheet the data was retrieved from.
Can this be done?
Sheet 1 and sheet 2 are input sheets?
What are the values in sheet 3 (%)?
Please add the desired (expected) result in your excel file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
I think this will help you .
Punnam
Punnam
Excellent. almost what I was looking for.
This will save my time once I get it working. There are many tens of sheets I need to make one table. and then this is only from one month.
was this a macro or a script?
/mika
No it is just a indirect function .
But the same requires some manual work.
Clarification Required
1) Kaikki (n=5334)Miehet (n=2627)Naiset (n=2707)9-14 v (n=412)15-34 (n=1388)35-54 (n=1482)55+ (n=2052) the present count is 7 will they grow in number per sheet
2) =INDIRECT("'"&$A$14&"'"&"!"&ADDRESS(ROW(B5)+2,COLUMN())) every time when u start new sheet make sure the very first is refereeing to B5 row
3) Need to change $A$14 with respect to new sheet.
Punnam
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks