Sachin Singh
asked on
Conditionally deleting data between two workbooks
I have two files 1)book1 2)book2
my both files located in C:\Users\user\Desktop
now what i want book2 has additional data so what i want see all the symbols of sheet1 of book1 and delete the additional symbols (entire row) of sheet1 book2 and keep all the data
plz see the sample file
I will place the code in Book2
we cant copy and paste the data bcoz except symbol rest data will be different
Book1.xlsb
Book2.xlsb
my both files located in C:\Users\user\Desktop
now what i want book2 has additional data so what i want see all the symbols of sheet1 of book1 and delete the additional symbols (entire row) of sheet1 book2 and keep all the data
plz see the sample file
I will place the code in Book2
we cant copy and paste the data bcoz except symbol rest data will be different
Book1.xlsb
Book2.xlsb
ASKER
Yes sumit sir
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thnx Neeraj Sir and sumit Sir for ur great support
You're welcome Sachin!
1. Search for the 'Symbol' of Book1 in Book2.
2. If not found in book2, delete entire row.
is it??