+ Reply to Thread
Results 1 to 2 of 2

Move data to matched cell on dif worksheet

  1. #1
    Registered User
    Join Date
    11-02-2007
    Posts
    29

    Move data to matched cell on dif worksheet

    Hello, I have the below code which searches for a match between two sheets. If no match is found, it will copy data from one sheet (Base Report) to the other (Master Report). Currently if a match is found, it does nothing. Due to a user request, I need to modify the code so if a match is found, I need it to copy the information from the Base Report tab to the existing row on the Master Report. The reason for this is the information can change on the Base Report and it needs to be moved to the Master report. Thanks.

    Please Login or Register  to view this content.
    Last edited by bhodge10; 05-14-2009 at 02:23 PM. Reason: Updated subject

  2. #2
    Valued Forum Contributor
    Join Date
    08-26-2006
    Location
    -
    MS-Off Ver
    2010
    Posts
    388

    Re: Move data to matched cell on dif worksheet

    Hi

    Probably better to use the Range.Find method, that's what I use. Finding and copying data is quite a common requirement so you should find plenty of examples on this site.

    Also there is a code example in VBA help, (without variables declared , but c is a Range and firstAddress is a String). If you need any more help please post back and I will try to help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1