Results 1 to 9 of 9

Copy a row record to a sheet based on the date entered in to a cell

Threaded View

  1. #1
    Registered User
    Join Date
    09-14-2011
    Location
    Guernsey
    MS-Off Ver
    Excel 2007
    Posts
    5

    Copy a row record to a sheet based on the date entered in to a cell

    Hi All,
    I have scoured lots of forums and still cannot get the code for this to work.
    I have a workbook with 13 sheets, sheet 1 is "Main Data" the other twelve are the months of the year Jan to Dec
    On the Main Data sheet contains thousands of rows/records there are 3 columns where the users can enter dates, column C "Inception" column D "First response" and column E "Future Meeting".

    What I need is that if any user enters a date in to any of the 3 columns then that row/record is copied and the values pasted to the next empty row on the relative month sheet, the copy and paste should happen once the user presses the enter button on the keyboard after entering a date.

    Looking forward to any answers

    Gary
    Last edited by Gary Stunell; 05-27-2016 at 04:53 AM. Reason: add some more words

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Copy,Cut, Paste Row to different sheet when date entered becomes todays date - Please Help
    By Mykull in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-11-2016, 01:55 PM
  2. [SOLVED] Copy Paste a Range of Values from a Different Sheet Based on Value Entered in Cell
    By hamidxa in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-13-2015, 04:53 PM
  3. Replies: 0
    Last Post: 11-25-2014, 05:30 PM
  4. [SOLVED] Insert Row and Record in Another Sheet Once I entered date
    By atulexel79 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 08-22-2014, 10:04 AM
  5. VBA for copy record to sellected 2 sheet & clear entry sheet for new record
    By santosh226001 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-24-2012, 10:54 PM
  6. Cell formula to record many values and date entered
    By Stryda in forum Excel General
    Replies: 11
    Last Post: 11-13-2011, 04:28 PM
  7. [SOLVED] recording the date when record was entered in cell in Excel
    By mcgoo in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-10-2005, 07:06 PM

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