User Profile

Collapse

Profile Sidebar

Collapse
kkavitha
kkavitha
Last Activity: Mar 28 '07, 05:03 PM
Joined: Mar 28 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • kkavitha
    started a topic Compare 2 worksheets
    in Visual Basic

    Compare 2 worksheets

    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" & wsPreviousYearL astRow)
    Set rngDelete = .Range("q8:q"...
    See more | Go to post
    • kkavitha
      replied to Compare 2 worksheets in Excel and delete rows not contained in both.
      in Visual Basic
      Hello experts,

      I have a similar but a different issue.. 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" & wsPreviousYearL astRow)
      Set rngDelete = .Range("q8:q" & wsPreviousYearL astRow)...
      See more | Go to post

        Leave a comment:

      No activity results to display
      Show More
      Working...