Open

Excel Data Manipulation

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!

Skills: Excel, Data Entry, Data Processing, Visual Basic

See more: excel cut paste data macro, script cut paste data website excel, excel data manipulation, write macro cut paste excel, excel macro select data cut paste, cut paste data excel vba, excel data manipulation outsource, cut paste data excel, excel data manipulation sigma, example macros excel data manipulation, macros excel data manipulation examples, excel data manipulation macros, write script cut paste data, excel data manipulation script, excel data manipulation web, excel data manipulation job description, mysql excel data manipulation, vbscript excel data manipulation

About the Employer:
( 0 reviews ) Los Angeles, United States

Project ID: #21200627

77 freelancers are bidding on average $80 for this job

TypingxpertRehan

i can do that wok manually without any issues, cant be done via macro, please pm thanks..........................!

$120 USD in 1 day
(1431 Reviews)
9.1
jaylancer43

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] More

$250 USD in 1 day
(724 Reviews)
8.5
FINGERRPRINT

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.

$30 USD in 1 day
(335 Reviews)
8.1
schoudhary1553

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 More

$160 USD in 3 days
(341 Reviews)
8.0
difan016

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

$100 USD in 1 day
(762 Reviews)
8.2
PigtailXL

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 More

$140 USD in 1 day
(187 Reviews)
7.3
zExcel

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 More

$90 USD in 1 day
(262 Reviews)
7.7
paris2785

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 More

$100 USD in 1 day
(224 Reviews)
7.4
hdlong66

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

$30 USD in 1 day
(159 Reviews)
6.9
Motiurlaw

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 More

$50 USD in 2 days
(274 Reviews)
7.1
P0L

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.

$50 USD in 1 day
(311 Reviews)
7.3
shosi

Hi, I will manipulate excel data by using Macro. Send me the excel file. Please send me a message to start it. Thanks!

$100 USD in 1 day
(130 Reviews)
7.2
ksriniravi

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 More

$35 USD in 1 day
(188 Reviews)
6.8
elqueabandona

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 More

$100 USD in 3 days
(232 Reviews)
6.9
nagyzoltan68

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 More

$30 USD in 1 day
(121 Reviews)
6.4
ineedWorkJob

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 More

$100 USD in 1 day
(133 Reviews)
6.4
kalidas365

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 More

$45 USD in 1 day
(231 Reviews)
6.4
aubrey03

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]

$50 USD in 1 day
(119 Reviews)
5.9
vincentong07

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 More

$50 USD in 1 day
(68 Reviews)
5.7
nvchien94

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.

$30 USD in 1 day
(127 Reviews)
5.8