Copy\Find\Copy\Paste Multiple Workbooks

[JMcClane]

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)

[mohanvijay]

use this code

the two workbooks must be opened

i put the code Physical Stock.xls in PHYSICAL STOCK sheet

Please Login or Register  to view this content.

[JMcClane]

Thank you, I really appreciate your help. I am very new to this concept of VBA. How would I save this code and implement it onto my spreadsheets?

[mohanvijay]

set the code behind Button to get button goto

View-Toolbars- and click customize there will be three tabs
click Commands tab and select Forms on Categories list
and drug and drop the Button control to toolbars menu from Commands list
and click on the button and drag on the sheet
and click new the code pane will show
paste code and close VBA
click on the button code will run

a already attached previous files with code see that