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!
76 freelance font une offre moyenne de $81 pour ce travail
i can do that wok manually without any issues, cant be done via macro, please pm thanks..........................!
Hello, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I am Excel and Web Scrapping Expert on freelancer.com and have been featured by the freelancer community ([login to view URL] Plus
we are ready to get you the excel of 489 column as per your requirement. will get you the result Maximum of 2-3 hours. please share the file.
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Plus
I HAVE DONE SIMILAR WORK BEFORE CAN WE DISCUSS OR TRIAL FOR YOU? CHECK MY PROFILE AND REVIEWS https://www.freelancer.com/u/difan016.html THANKS SULTAN HOSSAIN
Hello Sr./Madam Hope you read my proposal and take a look into my Portfolio to see my reputation and capabilities. I am an experienced Windows Desktop Apps Developer (C#, C++), Web Data Extractor & Automator (using dif Plus
Hi, I'd be happy to help you with this task quickly which I will do in an automated manner using script, though the number of sheets that can be created in a single workbook could depend on your version of Excel and yo Plus
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel macro that will copy each of 488 columns on a separate sheet and rename Plus
Hello, I have a simple macro to allow create spreadsheets and copy columns as described. Please drop a PM if you’re interested. Best regards, Hoang
I have read through your project description. I have done several similar jobs. You can check my profile here for details at https://www.freelancer.com/u/Motiurlaw I am ready to do some free sample for you. Message m Plus
Hello, I’m an Excel expert and I can write a macro for creating the sheets. Please check my profile and contact me to discuss further details. Regards.
Hi, I will manipulate excel data by using Macro. Send me the excel file. Please send me a message to start it. Thanks!
Greetings! I can write a small macro to generate new sheets for each column of information. I can make this dynamic so that if you encounter a similar requirement in future with a different number of columns (as oppos Plus
Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the proje Plus
Hello, I would like to work on your project. I have a great experience using excel macros / vba, data formatting, and data manipulation in excel. I intend to do this task using a short custom vba code/macro. estimated Plus
Greetings sir, I have read your project details and i will do the excel data manipulation work for you to create 488 sheet for each individual column in main sheet. Sir, i can deliver this project sooner than you Plus
Hello Sir, Thanks for posting suitable project as per my skill. I am having 10 yrs similar experience and handled similar projects. I have reviewed your requirements of this excel project well and ready to start the Plus
I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]
Hi! I'm script developer that can retrieve data with automation.100% ACCURATE! I will write Python script, because Excel VBA can break because of large amount of sheets. ** The script will be in EXE and you can Re-Use Plus
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.