Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cross referencing two worksheets
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
cross referencing two worksheets
On Nov 29, 10:59*am, Maria Machado wrote:
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? 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
cross referencing two worksheets
On Nov 29, 11:13*am, Don Guillett wrote:
On Nov 29, 10:59*am, Maria Machado wrote: 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? 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cross Referencing between worksheets | Excel Discussion (Misc queries) | |||
Cross Referencing two data worksheets and desciphering differences | Excel Worksheet Functions | |||
Cross-Referencing Across Worksheets | Excel Worksheet Functions | |||
Cross Referencing | Excel Discussion (Misc queries) | |||
cross referencing | Excel Worksheet Functions |