I have a problem copying 1 row from one workbook to another workbook..
In workbook1 i have a sheet called data, it contains one row of around 250 cells (A2:IM2ish) i need to copy
this to another workbook, perhaps names "database" and it only have 1 sheet named sheet1.. this part isn't really my
issue.. What I get stuck on .. IF the row I have in the workbook1's cell A2 is matched by a A cell on the worksheet2 I want to
update that row with the values from worksheet1 otherwise I want to add the row to worksheet2, as a new row.. The A row contains a
unique id so it will only be matched once..
Hope I made some sense as it starts to drive me nuts..
Regards
Bookmarks