Macro Win 10 Excel 2016 Reformat non static columns of data

Cerrado

WHAT WE HAVE

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.

WHAT WE WANT

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

ID de proyecto: #12749868

Adjudicado a:

MimiFL

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)
6.0

18 los freelancers están ofertando un promedio de $80 para este trabajo.

jaylancer43

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)
7.7
prameswara

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)
6.7
schoudhary1553

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)
5.9
paris2785

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)
6.1
zebracaro

i can do it for you quickly and exactly

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

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)
5.5
standarditech

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)
4.6
JITINGOYAL1992

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)
3.7
ksinghrajeev

Hello There, Below are few examples of my work. Project Report Automation - https://www.dropbox.com/s/tt0q9qhfq3s4izm/eBird%20FEP%20Plan%2012_Feb_15.xlsm?dl=0 Log Report Automation - https://www.dropbox.com/s/ Más

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

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)
1.7
RushService

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)
0.0
shaheen23

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)
0.0
Mourinrimmy

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)
0.0
prologix5

Dear Client, Thanks for providing us opportunity to place bid over the project and communicate with you.We 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)
0.0
agnisree85

A proposal has not yet been provided

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