Compare sheet1 with Sheet2
Hello and Thanks in advance
I hope I explain this good enough I have a workbook that Imports data from another excel workbook. 'number of rows changes on each import Sheet1 (ImportedData) Sheet2 (Database) 'There is data in columns (A:O) I would like it to be able look at Sheet1 Column (J3:' to the end of data) and Delete rows if record already on sheet2 Column (J3: 'to the of end data) after it deletes duplicates copy sheet1 remaining data to sheet2. If some could give me a lead i would greatly apreciate Thanks Mike |
Compare sheet1 with Sheet2
what i did was write a function that reads values till it reaches the last valid input the following row would return Nothing use a counter in a loop till you get Nothing return the counter value shhould do the job pdfr "Mike" wrote: Hello and Thanks in advance I hope I explain this good enough I have a workbook that Imports data from another excel workbook. 'number of rows changes on each import Sheet1 (ImportedData) Sheet2 (Database) 'There is data in columns (A:O) I would like it to be able look at Sheet1 Column (J3:' to the end of data) and Delete rows if record already on sheet2 Column (J3: 'to the of end data) after it deletes duplicates copy sheet1 remaining data to sheet2. If some could give me a lead i would greatly apreciate Thanks Mike |
All times are GMT +1. The time now is 10:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com