cross referencing two worksheets

  • Thread starter Thread starter Maria Machado
  • Start date Start date
M

Maria Machado

Hi,

I have two worksheets, in one I have serial numbers of computers from
the vendor with the warranty end date, and in the other I have the
serial numbers matching the name of the person that is working with
that computer. I want to do a macro that will look at the serial
number in the first worsheets and copy the warranty end date of that
serial number in the other worksheet. Any ideas?
 
Hi,

I have two worksheets, in one I have serial numbers of computers from
the vendor with the warranty end date, and in the other I have the
serial numbers matching the name of the person that is working with
that computer. I want to do a macro that will look at the serial
number in the first worsheets and copy the warranty end date of that
serial number in the other worksheet. Any ideas?
Click to expand...

Several ways to do this. vlookup formulas to the other wb
=VLOOKUP(TODAY(),'C:\folder\[filename.xls]sheetname'!$B$18:$K$377,8)

or a macro
 
Hi,
Click to expand...
I have two worksheets, in one I have serial numbers of computers from
the vendor with the warranty end date, and in the other I have the
serial numbers matching the name of the person that is working with
that computer. I want to do a macro that will look at the serial
number in the first worsheets and copy the warranty end date of that
serial number in the other worksheet. Any ideas?
Click to expand...

Several ways to do this. vlookup formulas to the other wb=VLOOKUP(TODAY(),'C:\folder\[filename.xls]sheetname'!$B$18:$K$377,8)
Click to expand...
or a macro
 
Back
Top