Selective Copy from other excel file, sort, then deleteon a condition

A

Adi M

Hi. I have two excel files, Excel-1 and Excel-2. I must copy from Excel-1 to Excel-2 only some columns (for example A,B,D and G). After this copy, in the Excel-2 file, i must search in a column (A) for duplicates. If i found one, a script must delete the entire row. (for example A34 and A45 are the same with A2 - then i should delete A34 and A45)
The A file is updated daily - that's why I need a macro to be run every day to check if new rows appeared, and if yes, to add them by the end of Excel-B.
Can you help me please in this problem?

Thank you very much!

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
Match Column and copy to cell Column D 1
Look Up Formula With Veried Search Range 2
Conditional Formatting 2
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Overtime Calculation 1
Trying to count based on multiple criteria & cell comparisons 4
Transpose 1

Top