Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy data from sheet2 to sheet1 when sheet2 has variable # of rows | Excel Discussion (Misc queries) | |||
Compare and Update elements from Sheet1 with Sheet2 | New Users to Excel | |||
how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2!A1+ | Excel Discussion (Misc queries) | |||
[=Sheet1!A1] - if i use Column A1 ('Sheet1') / A2 ('Sheet2') | Excel Worksheet Functions | |||
go to sheet1 to sheet2 | Excel Programming |