Excel Macro / Report

Completed Posted Oct 29, 2013 Paid on delivery
Completed Paid on delivery

Taking the attached excel workbook as an example. Write a script/macro that would look at every sheet within the workbook. Grab every value (5 or 6 digit number) from column C. And grab the corresponding date value found to the right (in the same row) in column D. Then return these results in a list form with the value in column A and the date in column B.

See attached example:

In the attached example the Value in column C row 2 is grabbed and so is the value in Column D row 2. These values are placed on the results sheet. (the coloring needs to be removed)

The actual sheet I'll be running this macro on has about 60 sheets in it. All the values need are contained in columns C and D on each sheet.

Excel Visual Basic

Project ID: #5074060

About the project

17 proposals Remote project Active Oct 29, 2013

Awarded to:

zExcel

I have the code ready. Waiting for your response... ----------------------------------------------------------------------------------------------

$20 USD in 1 day
(6 Reviews)
3.1

17 freelancers are bidding on average $20 for this job

Teloquence

Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.

$30 USD in 0 days
(149 Reviews)
6.4
vietitdotinfo

Hi. Very easy project for me. Will be a standalone exe to work with the excel file. I have done alot of similar project. I am ready to do for you. Thanks!

$20 USD in 0 days
(23 Reviews)
5.1
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at my feedback to know more about me and my work. Waiting for more details along with posi More

$30 USD in 3 days
(14 Reviews)
4.6
elMancha

Ainda não foi fornecida uma proposta

$13 USD in 1 day
(24 Reviews)
4.6
expertatwork

Hey atginc, If you are using WINDOWS, please reply :-) we can get this done in 30 minutes or so... .thank you !

$15 USD in 1 day
(48 Reviews)
4.5
rengrish

I can complete this very quickly within today. I have vast experience in VBA Macros. Please check my prior reviews and ratings. I have understood the requirement clearly. My Bid is 30$ .Kindly let me know. I assure More

$30 USD in 1 day
(35 Reviews)
4.4
jaylancer43

Hello - 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 n More

$25 USD in 3 days
(23 Reviews)
4.2
inoussakabore

there is now 4 years i work with VBA excel. I am ready to do this work for you. I will do this job rapidly for you

$14 USD in 3 days
(2 Reviews)
3.3
dviruki

A proposal has not yet been provided

$15 USD in 0 days
(5 Reviews)
2.6
zubairch

there are many methods for getting your required result, i am proposing you customize reports (including VB and Pivot table) and you will be able to see graphically results as per your requirements. PM please for mor More

$35 USD in 3 days
(3 Reviews)
2.1
kdhaam

Hi, I have made the code to complete the process in a single mouse click. The code will copy every value (5 or 6 digit number) from column C and the corresponding date value from column D in each worksheet (except ' More

$15 USD in 1 day
(0 Reviews)
0.0
mukesh1303

Hi, I understand your problem i can do this. I have 7 years of experience in VBA, I can do this task very easily and quickly. Thanks Mukesh

$25 USD in 0 days
(0 Reviews)
0.0
MaluBanu

A proposal has not yet been provided

$13 USD in 1 day
(0 Reviews)
0.0
derrickpogi

Hello, I can do it right now. Thanks! Very excited to work with you. Will finish this in an hour or less. Sincerely, Derrick

$10 USD in 3 days
(0 Reviews)
0.0
yogendrajain07

I have expertise to work with excel and VBA and can help you with you work. I will also guarantee accuracy for the work done by me. Please let me know if you would like to view my work sample. Regards, Yogendra

$25 USD in 1 day
(0 Reviews)
0.0