Completed

Excel Macro Worksheet find and copy

Excel Macro

## Deliverables

I need a macro or similar to allow me to pull data from worksheet 1 to Worksheet 2 based on criteria. I have part numbers on work sheet 1 in column D, Column E is empty, but I want prices in column E. The price information is in Worksheet 2. Work Sheet 2 contains part number in column F and prices in column G. There are 10,000 populated rows in worksheet 2. There are 2200 populated rows in worksheet 1.

So, it should work like this. look at Worksheet 1,row 1 column D, value is SU1232, search work sheet 2 for value SU1232, move over one column, copy value, $2.35, return to work sheet one, and paste into row 1 Column E, continue until there is no value in work sheet 1 column D -END

Skills: Engineering, Software Architecture, Software Testing

See more: macro e, architecture f, excel contains, excel row column, excel macro row, excel based software, move data excel, excel column row, column row excel, copy paste engineering, excel column copy, macro copy data excel software, macro find copy paste, find copy data excel macro, excel macro part, find part, search macro, excel macro sheet, excel search macro, worksheet excel

About the Employer:
( 13 reviews ) Courtenay, Canada

Project ID: #3515240

Awarded to:

franSystems

See private message.

$21.25 USD in 7 days
(82 Reviews)
4.7

25 freelancers are bidding on average $33 for this job

dominique1

See private message.

$15.3 USD in 7 days
(268 Reviews)
6.2
vnb400sl

See private message.

$34 USD in 7 days
(95 Reviews)
5.6
DenisSmolentsev

See private message.

$42.5 USD in 7 days
(77 Reviews)
5.1
Lotusdeveloper

See private message.

$22.1 USD in 7 days
(76 Reviews)
5.1
ultimatecode

See private message.

$34 USD in 7 days
(47 Reviews)
4.7
soft1serve

See private message.

$51 USD in 7 days
(44 Reviews)
4.5
desirablecoder

See private message.

$42.5 USD in 7 days
(12 Reviews)
4.4
nikitasvw

See private message.

$12.75 USD in 7 days
(63 Reviews)
4.3
emova

See private message.

$34 USD in 7 days
(26 Reviews)
4.2
Devoji

See private message.

$42.5 USD in 7 days
(6 Reviews)
3.9
sarepean

See private message.

$21.25 USD in 7 days
(29 Reviews)
3.3
SoopDesign

See private message.

$29.75 USD in 7 days
(14 Reviews)
3.3
prashant542

See private message.

$21.25 USD in 7 days
(19 Reviews)
3.1
prabby81

See private message.

$42.5 USD in 7 days
(6 Reviews)
2.4
jaison007g

See private message.

$25.5 USD in 7 days
(4 Reviews)
2.1
itfutureking

See private message.

$42.5 USD in 7 days
(1 Review)
0.0
herrkirk

See private message.

$30.6 USD in 7 days
(0 Reviews)
0.0
gayani1984

See private message.

$42.5 USD in 7 days
(1 Review)
0.0
infopediate

See private message.

$42.5 USD in 7 days
(2 Reviews)
0.0
wazam99

See private message.

$59.5 USD in 7 days
(0 Reviews)
0.0