Macro for quick cross reference / input

[sloan122]

Im looking to have a macro so i can copy a order (insert order worksheet) in to excel it will need to reference a part number to the order worksheet then copy the two columns of relevent information ( amount , job ) to where the match was found any help appreciated.

Ben

[AB33]

Your request is not clear, but try these formulas

In sheet order
E2 and drag it down

Please Login or Register  to view this content.

F2 and drag it down

Please Login or Register  to view this content.

[sloan122]

Any way to keep the data after its been cleared from the insert order sheet ?

[AB33]

What do you mean?
They are formulas, not a code.