Hi,
I have some data in 8-10 worksheets in all 20 excel file. I want to list this data on separate sheet in same file or separate excel file. I tried with ‘consolidate’ command but it didn’t worked for me.
I want to list data appeared below 'Long Description (Size)' heading from all sheets in one sheet in same file or separate excel file.
Please suggest solution for this problem. Sample excel file is attached here. Sheet names are not fixed.
Reagrds,
Pradeep S. Walse
Administrative Note:
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.
(Note: this requirement is not optional. No help to be offered until the link is provided.)
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Hi,
Thanks for providing information about cross posting rules. I was not aware about his rule. Sorry for the inconvenience for the same.
I have posted it on mrexcel forum. I am trying to copy link here. But if I copy link here then not able to post the reply.
Please refer below link for post in other forum.
mrexcel.com/board/threads/consolidate-data-from-different-sheets-in-one-sheet.1169662
Hope now my post will be approved.
Please let me know.
Thanks,
Pradeep
As you are using the 2013 version of Excel, you are able to freely download Power Query from Microsoft.
You could then convert the ranges to Excel tables and use Power Query to make a single table as described in the video tutorial by an instructor at Highline College (linked below).
I would suggest that you start watching from the beginning of the video however the method of appending tables explained starting at the 3:56 mark may be of the most help with the file attached to post #1.
https://www.youtube.com/watch?v=sb0hmwiFM-E&t=6s
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks