+ Reply to Thread
Results 1 to 2 of 2

copy from one sheet to another triggered by an entry and then pasted if similar log no

  1. #1
    Registered User
    Join Date
    09-22-2013
    Location
    Aurora, Colorado
    MS-Off Ver
    Excel 2007
    Posts
    30

    copy from one sheet to another triggered by an entry and then pasted if similar log no

    Hello:
    I need help on how to write a macro to do the following . Here are the details:
    In the workbook there are 2 sheets. I need to copy data from columns P and Q on Sh2 to Sheet 1 columns Y and Z . Data in column P is text but Q is a date (which needs to be automatic when data is entered into P).
    This copy-paste event is triggered when data is placed into Column P (Sh2), but only if cell C says, “Task Summary Line”. Also note that in that same row on Sh2 is a unique Log No. in Cell A.
    When the macro pastes info (data from P and the date from Q)from sh2 to columns Y and Z on Sh1 it does so only if the Log No from Sh2 matches the Log no on Sh1 Cell A.
    If the data is later removed from Sh2 column P the entry on Sh1 will disappear.
    The range needs to handle ( for example) P3 through P1000.
    Thank you.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: copy from one sheet to another triggered by an entry and then pasted if similar log no

    Sorry this is late, but maybe someone can benefit if the solution is shared.

    If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Vba to copy text only and keep formatting of sheet that its pasted on.
    By CarJon0767 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2013, 11:05 PM
  2. copy and retain information from a data entry sheet to trending sheet
    By thuddleston11 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-22-2012, 11:13 AM
  3. User Box entry Pasted into cells
    By humboldtguy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-21-2010, 04:33 PM
  4. Copy color cells from other sheet similar to Lookup
    By unley in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-29-2009, 08:52 PM
  5. [SOLVED] Event triggered by cell data change/entry
    By Fred Holmes in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-17-2005, 11:06 AM

Tags for this Thread

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