Hi - I am just trying to figure out the tool that helps me to pick specific columns from multiple sheets from 1 excel file and give me 1 output file consolidating that specific column. ex: A file contains sheet A, B & C have many columns. Those few columns have customer ID and Customer name but in different positions. I have to find a way to select ID and name from all three sheets and consolidate and provide one output. It is difficult for me as the sheets are not in the same format. Any help is appreciated, thanks!
Added example file and output sheet to see the expected output.
Hello @VMR ,
Could you share with us an example file with some mock data? Just to have an idea about the whole problem.
Regards
Hi - added one example file. 3 sheet and one expected output sheet.
Hi @VMR,
Normally this would work well if you had the same schema for all the worksheets you use.
Since you dont, I would suggest you to take a look at the workflow I did. It gets you the output you desire, but it involves you selecting each worksheet one by one.
Hope that helps.
Thanks,
Raksha
Hi @ rakshabhat
Thank you! Yeah, I know this select and union step but the difficult part is I have nearly 20+ sheets in one excel file.
Is there a way to do in standard macro or Batch macro ??!!
Thanks, ACEAFV2688 -
This could help a lot. Can you give me a short video of creating this macro to help is my other works too. Thanks in advance!
Hello @VMR ,
Rather than a video I prefer to explain it here.
Hope this helps
Regards