I have a spreadsheet with 488 columns (sorry). I need each of those COLUMNS to become their own SHEET in that same file. So we'll have 489 sheets at the end of this... So:
1. Create a new sheet
2. Name the sheet based on the value in the top row of the column you're moving over.
3. "Cut and Paste" the column from Sheet1 into the new sheet.
... repeat 488 times
If you know how to write a macro to do this, go for it. I'll pay a bonus for the saved time.
This is super valuable and helpful! Thank you!
Hello there, I am an Excel expert and I can create macro to create sheet for you in 20 mins. Please contact me, I can start working right now. Thank you. Save your time.