I have a bunch of messy sheets in an Excel file that we use daily. I would like to combine all of the messy sheets into one organized, nice neat spreadsheet without changing any of the information. It's also something I would need to do daily. Any ideas?
FYI this Excel file is a mess it's a sales order file from different regions. It's hard to filter because of skipped rows. It's not my file. It's just what I have to work with.
I really appreciate any help you can provide.
Roger
Last edited by AliGW; 02-07-2021 at 12:51 PM.
PowerQuery ... but I'd need to see a sample messy sheet and sample output sheet.
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.
It's a huge file with a lot of proprietary information, but thank you for putting me in the right direction.
Another question... The sheets have the normal headers, but then someone added a "subheader" with the salesman's name, which creates a filtering issue. Any ideas?
Also, the source data is refreshed daily with a new file created with the same file name, and the date changed. Can the queries be saved, so I just need to change the file?
Thank you again!
Roger
Absolutely no way I can comment without seeing the layout - sorry. We never ask for real data - a cut-down sample file that’s been desensitised is all that’s needed.
I'll see what I can do. Thanks again.
Attached,
Thank you
Thank you. I don’t see where you have mocked up your desired layout. I still have no idea what you want the tidied data to look like.
The mock-up would be the same. All of the sheets have the same header. I want it cleaned up and combined into one spreadsheet that's sortable user friendly.
Thanks!
OK, then sorry, I can’t help. Without any idea of what you expect ‘cleaned up’ to look like, it’s not possible to advise. Sorry.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks