Fermé

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!

Compétences : Excel, Saisie de Données, Traitement de Données, Visual Basic

en voir plus : 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

Concernant l'employeur :
( 0 commentaires ) Los Angeles, United States

Nº du projet : #21200627

76 freelance font une offre moyenne de $81 pour ce travail

TypingxpertRehan

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1431 Commentaires)
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] Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(727 Commentaires)
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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(332 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(341 Commentaires)
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(762 Commentaires)
8.1
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(187 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(262 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(224 Commentaires)
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(160 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(277 Commentaires)
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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(312 Commentaires)
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!

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(133 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(188 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(233 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(121 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(133 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(231 Commentaires)
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]

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(120 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(70 Commentaires)
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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(128 Commentaires)
5.8