By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,799 Members | 1,403 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,799 IT Pros & Developers. It's quick & easy.

Compare 2 worksheets

P: 2
Hello experts,

I have a similar issue that is posted here but little bit different.. I need your help.

If SSN in previous year worksheet matches with the SSN in Current Year Worksheet, I want to remove that row in current year worksheet.

I didn't understand these two lines of code:
Set rngPrevious = .Range("a1:a" & wsPreviousYearLastRow)
Set rngDelete = .Range("q8:q" & wsPreviousYearLastRow)

I have 1 column (SSN) and 10 rows in previous year worksheet and 3 columns and 30 rows in current year worksheet that has 10 matching rows from previous year worksheet. When I execute the macro, I should get 20 rows in current year worksheet.

How do I modify the code for my requirement.

I have two worksheets in the same excel document.

I really need this working.. Please help me.

Thanks in Advance.
KK.
Mar 28 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.