HI
I want to combine all the sheets of a file into one in the same file. but my problem is column headers are not exactly same. I want to it be dynamic means If data changes or a new sheet is added It will reflect in the combined data.
If some one changes the header it should still work.
I have searched the internet but can not find answer to this. I am attaching the sample file here also
I want to only combine the tables that have "batch" in the name
is there a way I ca do it
thanks in advance
And what should the final result look like (show us)?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
apologies I think I replied to you privately
here is it should look like
Attachment 859764
if I can have cell colour formatting in the combined sheet that's Bonus
Option 1. A more complicated formula... taking about 5 seconds to add a new sheet manually.
Option 2. Insert columns until ALL shhets start on the same column.... taking about 2 seconds to add another sheet manually.
Take your pick.
Hi Glenn
thanks for this solution.
but I can only sort this using formula and this sheet will be used by others also who do not know excel.
is here any possibility I can do it using Power query
I don't know PQ. Others will help.
thanks a lot Glenn for the your help.
Can anyon with the knowledge with Power Query help me
I can't see the attachment to post #3, as it's invalid, so I don't really know what we're aiming for.
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.
Just seen this:
PowerQuery is a non-starter with this level of potential inconsitencies in your header data. YOu might have to go with VBA.If some one changes the header it should still work.
Actaully the attachment in Post 3 is only reply to Glenn question I am attaching it again here.
Attachment 859847
"If some one changes the header it should still work." this is extra if not possible/too difficult just ignore it
Actaully i Need the first line of column header
where column header starts "with Result unit......" i need only "Result Unit 501" "Result Unit 423" etc
can I sort data without formulas using VBA? if yes Can you tell me how to do it with VBA.
Thanks in Advance
Do you want me to move this to the VBA section?
If moving the post is more helpful than posting a new question in VBA forum, then please move it.
Thanks for al
What are the "header" changes? Can you provide an example?
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
What exactly does that mean? Will all the tables have the same header changes, or will the headers be different in some tables? If the latter, what do you expect to happen?Originally Posted by excelwala12
Rory
it could be one or two or changed a header of column 2 in every table,
but managing column header name change is difficult just ignore this. It is not a priority.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks