Inventory compare and copy Script
 

Situation: I need a script that will search through two worksheets and
find serial numbers that are the same. Than I need to copy the asset
ID from the first sheet into the correct one on the second sheet.
Example
Sheet1
AssetID Desc s/n
123 stuff 1
124 junk 2
125 tools 3

Sheet2

AssetID Desc s/n
thing 4
junk 2
tools 3
stuff 1

I need them both to have the asset ID numbers that are in Sheet1. I
was trying to do an IF statement but I don't know enough about
programming in excel (or in general) to set it up correctly. Can
anyone please help me?

Inventory compare and copy Script
 

Sounds like you could do this with a vlookup, check here or in Excel help for
details, kind of complex to explain from scratch
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


" wrote:

Situation: I need a script that will search through two worksheets and
find serial numbers that are the same. Than I need to copy the asset
ID from the first sheet into the correct one on the second sheet.
Example
Sheet1
AssetID Desc s/n
123 stuff 1
124 junk 2
125 tools 3

Sheet2

AssetID Desc s/n
thing 4
junk 2
tools 3
stuff 1

I need them both to have the asset ID numbers that are in Sheet1. I
was trying to do an IF statement but I don't know enough about
programming in excel (or in general) to set it up correctly. Can
anyone please help me?

Inventory compare and copy Script
 

On Jul 30, 9:46 am, John Bundy (remove) wrote:
Sounds like you could do this with a vlookup, check here or in Excel help for
details, kind of complex to explain from scratch
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

" wrote:
Situation: I need a script that will search through two worksheets and
find serial numbers that are the same. Than I need to copy the asset
ID from the first sheet into the correct one on the second sheet.
Example
Sheet1
AssetID Desc s/n
123 stuff 1
124 junk 2
125 tools 3

Sheet2

AssetID Desc s/n
thing 4
junk 2
tools 3
stuff 1

I need them both to have the asset ID numbers that are in Sheet1. I
was trying to do an IF statement but I don't know enough about
programming in excel (or in general) to set it up correctly. Can
anyone please help me?

I tried that, it would work on a small scale but not a large one. Here
is what my vlookup looked like.
=VLOOKUP(H4,AllAssets!$A$3:$K$753,1,FALSE)

But that doesn't work. I am not sure if it is because of the number of
cells is must search or because I am trying to return from column 1.