Results 1 to 16 of 16

Copying Data without overwriting (edit macro)

Threaded View

  1. #3
    Registered User
    Join Date
    10-20-2010
    Location
    Berlin
    MS-Off Ver
    Excel 2003
    Posts
    39

    Re: Copying Data without overwriting (edit macro)

    Let me explain a bit detail how the macro works.
    - We compare every value in sheet1 column C with sheet2 coloumn A to find a match

    If there is a match then do this in that respective row of the matching value in sheet2:
    - copy the data from the respective columns in sheet1 (D,F,H) and paste it in the sheet2 columns F, D, I respectively.

    Now what I want is that when the value are to be pasted in the columns of sheet2 they should not overwrite the already entered values in the respective cell. it should just move on.

    I hope this clears your question.
    Last edited by jimmy_nora; 03-01-2011 at 06:11 AM.

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