Hey guys, I just discovered the wonderful world of macros. I'm just going to jump into an example.
I have stock of equipment that was leased through a vendor. I have to return certain pieces of equipment to the vendor due to lease expiration. I am using 2 spreadsheets for this task. I have included samples of these to spreadsheets so I'll just refer to the names of the samples.
I would like to take all of the serial numbers in the "PHYSICAL STOCK" sheet of "Physical Stock.xls" and find each row corresponding to those serial numbers in "Leasing Information.xls". I would then like to copy all the matching rows (the entire row) from "Leasing Information.xls" into the "MASTER LIST" sheet of "Physical Stock.xls". If the serial number is not found in "Leasing Information.xls", the "STATUS" row of the "MASTER LIST" sheet in "Physical Stock.xls" should be given the value "NOT FOUND".
I feel like I'm in over my head at the moment so any help you can give would be greatly appreciated! Thank you so much in advance.
JMcClane <---(only the 1st 3)
Bookmarks