| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy & Paste Only Those That Don't Exist
I think I've explained it all here, but I might have left something out:
In Wkbk1, Wksht1, look at every row that has something in it. If the contents of the range cells Ax:Bx of the row don’t appear in Wkbk2, Wksht1, Ax:Bx, copy the whole row and paste it into the next empty row of Wkbk2, Wksht1. Any help/hints appreciated. Thanks Rob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to paste blanks only without overwrite exist cells in excel | Excel Discussion (Misc queries) | |||
| how to copy cells which gaps exist between? | Excel Discussion (Misc queries) | |||
| Copy Worksheet to a new Workbook creating if it doesn't exist and add more Worksheets if it does exist | Excel Programming | |||
| Command Line. How to tell to XL : If the xls file exist : Open it, if it does not exist : Create it. | Excel Programming | |||
| search range, if exist, copy cell | Excel Programming | |||
Threaded Mode
