Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

compare data between 2 sheets

  Asked By: Hayfa    Date: Aug 14    Category: MS Office    Views: 900
  

I was wondering if it is possible to sync data between 2 columns in 2
different sheets. I have 2 worksheets A and B. I need to check if data
from A is already in B. if it is in B - it must be deleted from A. I
hope I explained it well(ask me for more clarifications). is there a
code, VB or a formula that I can use? it is way too long to do it by
hand.

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Lurline Fischer     Answered On: Aug 14

If you visit
groups.google.com/advanced_group_search?q=group:*Excel*&num=100,
and use the search term: compare  data between two sheets, you will find
lots of information to get you started.

Now, once you have compared it, you can use an If statement to specify
deletion or to leave it alone.

 
Didn't find what you were looking for? Find more on compare data between 2 sheets Or get search suggestion and latest updates.




Tagged: