Hi.
I am looking for VBA code what will do the follows.
I have 2 excel .xlsx workbooks.
First one is containing lets say 11 columns and second is 9 columns with all data.
These are all shipments with a shipment number. On first workbook there is 2 extra columns what I like to copy to workbook2 with VBA button click if the column B cell value is matching for that raw otherwise do nothing.
Example:
Workbook 1.
Location (C:\Users\.......)
Cell B1 value: 123456
Cell N1 value: Shipped on 01-06-2018
Workbook 2.
Location (C:\Users\......)
Any cell in Column value is: 123456
THEN
Copy corresponding raw N column value to this workbook.
If the number does not exists in workbook 1 then go to next raw until A raw is empty.
Thank you so much for the help.
Robert
I am looking for VBA code what will do the follows.
I have 2 excel .xlsx workbooks.
First one is containing lets say 11 columns and second is 9 columns with all data.
These are all shipments with a shipment number. On first workbook there is 2 extra columns what I like to copy to workbook2 with VBA button click if the column B cell value is matching for that raw otherwise do nothing.
Example:
Workbook 1.
Location (C:\Users\.......)
Cell B1 value: 123456
Cell N1 value: Shipped on 01-06-2018
Workbook 2.
Location (C:\Users\......)
Any cell in Column value is: 123456
THEN
Copy corresponding raw N column value to this workbook.
If the number does not exists in workbook 1 then go to next raw until A raw is empty.
Thank you so much for the help.
Robert
