Hi there,

Looking for a bit of assistance in Excel with VB macro.
I have 2 spreadsheets. One has an order number and a few cells of data. The second has a column of order numbers and each row has data regarding that order. I am looking for code that will run when an on screen button is pressed that grabs the order number and data from the first spreadsheet and then in the new spreadsheet look for the row which has the same order number (In say column A) and paste the data in another column in that row (Say column M).

EG.
Spreadsheet 1
Order Number Data1 Data2 Data3
5468 #new# #new# #new#


Spreadsheet 2
Order Number DataA DataB Data1 Data2 Data3
2245
6315
5468 existing data #new# #new# #new#

Any help is much appreciated.

Regards

Phil



Submitted via EggHeadCafe - Software Developer Portal of Choice
Yet Another Service Wrapper: The Ultimate Service
http://www.eggheadcafe.com/tutorials...ice-wrapp.aspx