Macro Win 10 Excel 2016 Reformat non static columns of data


1. Folder full of spreadsheets formatted xlsx

2. Take number from one column and append to another column in same sheet, when the condition is met that a number exists on that row.

3. Find a column by it name (not absolute reference) and reformat it.

4. Column name in item 3 may be one of two names, will need to search for both.


1. Open all files in the folder, and perform for all files in the folder the following:

2. Copy data from one column to another

3. Reformat the contents of another column of data

4. Find another column of data and reverse the mathematical sign (e.g. Copy -1, select column of data, edit, paste special, multiply, being careful not to perform the function on empty cells after the end of the column).

5. Save the results with the same format (xlsx) and add a "_X" to the end to indicate completion, then close the spreadsheet.

Habilidades: Excel, Visual Basic

Ver más: excel macro google results, excel macro match data columns, read data table pdf file excel macro, find data internet explorer copy excel macro, excel vba macro copy columns data, reformat time excel macro, excel macro lotto results, excel macro read directory contents, excel macro move cell contents, excel macro copy paste data application, excel macro next chart data, excel macro data base entry, excel macro data online, data web excel macro, excel macro change cell contents, excel macro copy cell contents, excel macro enter data database, excel macro copy data column, excel macro move data existing cell, data net web application excel macro, excel macro data cell

Información del empleador:
( 37 comentarios ) Sultan, United States

Nº del proyecto: #12749868

Adjudicado a:


Hi, i m serious freelancer with 100% completion rate and i believe i can help you. I've done hundreds of excel projects (with both formulas and macros) and i've never had a single problem. If you are interested please Más

$45 USD en 3 días
(216 comentarios)

18 freelancers están ofertando el promedio de $80 para este trabajo


Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among Más

$150 USD en 1 día
(396 comentarios)

Hello Sir Im excel VBA macro and formula Expert :) i can make macro for reformat data from many file like u want Sir :) please give me a chance for doing your project and im able to start working right now :) Tha Más

$30 USD en 1 día
(279 comentarios)

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Más

$150 USD en 2 días
(85 comentarios)

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled (VBA) Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach y Más

$60 USD en 3 días
(101 comentarios)

i can do it for you quickly and exactly

$70 USD en 2 días
(79 comentarios)

Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. Más

$78 USD en 3 días
(41 comentarios)

Hi, I have taken a deep look on this project, and I am sure that we can work together. I have experienced in these kind of task. Please give me a chance to serve you and i will never let you down. I will complete this Más

$30 USD en 1 día
(54 comentarios)

Greetings I am a Chartered Accountancy student and I provide a range of services majorly focusing on excel, data entry, word, accountancy and other allied services. I have been working on this platform for two years n Más

$77 USD en 2 días
(15 comentarios)

Hello There, Below are few examples of my work. Project Report Automation - [login to view URL] Log Report Automation - [login to view URL] Más

$75 USD en 2 días
(7 comentarios)
$155 USD en 3 días
(1 comentario)

Hi, I can take 100% confidently your project. I can give high quality service from others. I am expert about it. You can see my full profile and feedback to check the experience. I available online any time. We will se Más

$45 USD en 3 días
(4 comentarios)

Hello, Greetings from Passionate Futurist Solution Pvt. Ltd As per your project description you want a macro win 10 excel 2016 reformat non static columns of data. The idea sounds good, we will provide you ful Más

$30 USD en 3 días
(0 comentarios)
$30 USD en 2 días
(0 comentarios)

A proposal has not yet been provided

$155 USD en 3 días
(0 comentarios)

Dear Client, Thanks for providing us opportunity to place bid over the project and communicate with [login to view URL] mainly deal in web development, SEO, Android App, software testing and graphic design. Our vision is to b Más

$200 USD en 6 días
(0 comentarios)

Dear Hiring Manager, Thank you for reviewing my proposal. I have gone through your job posting and I understood about your requirements. I think I am the perfect for your requirement and very much interested in Más

$30 USD en 3 días
(0 comentarios)

Lets discuss the further more details of .But i am not new in this field.I just want to know more details about this project to make it complete.I not only complete project but provide also fulls upport to understand Más

$30 USD en 3 días
(0 comentarios)