Open spreadsheet and copy certain information into another spreadsheet.

Hi all,

I am trying to write a macro that opens a spreadsheet and copies certain information to another spreadsheet. However its a little more complex in that I would like my macro to copy certain cells based on what I have in my second spreadsheet. For example, I would like to copy the value of the cell next to the cell labeled 'number of orders' & paste it into the cell next to the cell that says 'number of orders' in my second spreadsheet. I would like to do this for about 80 items.

Thanks in advance

Not only confusedaboutVBA but also lacking information!!!!
Could you attach a workbook with before and after explained?
It should be the same layout but without sensitive info.

Ok.

Please find attached working examples.

Basically I want to copy data from Book1 to Book2. So for example, I would like my macro to look up the 'number of cars' in Book1 & paste the value into Book2 in the cell next to the cell that contains 'number of cars'. So to illustrate that example, the macro will copy '12' from B2 in Book1 and paste it into B2 of Book2.Book1 Example.xlsxBook2.xlsx

try this code,

Please Login or Register  to view this content.

See if this works.
You have to have both workbooks open and run the macro from the example workbook.