Emoncada
08-20-2015, 03:06 PM
I have separate workbooks, WkBook1(Src) user enters data then clicks update.
Here is where i think there are 2 options.
WkBook2(Dest) has 2 sheets.
Option 1
I need Src.Range("B2").value to find same value in WkBook2(Dest)(A:A) and paste values in same adjacent columns if found otherwise alert no match found to user.
If match is found i would then need to cut that row and place in WkBook2(Dest) Sheet2 last available row.
Option 2
I need Src.Range("B2").value to be pasted directly into WkBook2(Dest) Sheet2 then run a seperate macro to find match in Sheet1 if found delete that row from sheet1 otherwise alert user no match found.
Any help would be appreciated.
Here is where i think there are 2 options.
WkBook2(Dest) has 2 sheets.
Option 1
I need Src.Range("B2").value to find same value in WkBook2(Dest)(A:A) and paste values in same adjacent columns if found otherwise alert no match found to user.
If match is found i would then need to cut that row and place in WkBook2(Dest) Sheet2 last available row.
Option 2
I need Src.Range("B2").value to be pasted directly into WkBook2(Dest) Sheet2 then run a seperate macro to find match in Sheet1 if found delete that row from sheet1 otherwise alert user no match found.
Any help would be appreciated.