Hello,
I have data in different sheets, i want this data in one sheet in de same column. I think that i need to make a dynamic range but i don't know how to make this.
in the attachment is an example of the sheet, sheet 2 3 and 4 are the ranges, in sheet total i need all of the numbers in column A, but the amount of numbers in sheet 2-4 can change, so it has to be dynamic.
Can someone help me with a formula?
It can be done with PowerQuery. However, your first sheet is far from clear - what does "nr" represent? What are you expecting to see on that sheet based on the data in the workbook now?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
i want to transfer the numbers to the first sheet starting in A2, this is just an example, due to policy i can't send the sheet i need it in
Hi edwin,
try this one.
Using PQ as advised by Ali, load each of the tables/ranges to PQ. Then append each of them. Close and Load to your workbook.
Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Thanks people,
The VBA from Raj does the job!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks