+ Reply to Thread
Results 1 to 6 of 6

How to get a macro to change to another worksheet, move data and then add date and time.

  1. #1
    Registered User
    Join Date
    01-03-2015
    Location
    California
    MS-Off Ver
    2013
    Posts
    16

    How to get a macro to change to another worksheet, move data and then add date and time.

    Hello, I'm trying to get a macro that I've been using to also add date and time to columns A and B respectively after it copies a new entry. It currently will take data from Sheet 1, Cell C10 and place it in Sheet 2 Cell Q (First available), but alas I can not figure out how to get it to shift to the same row within column A and then place the Date and Time in Columns A(Date) and B(Time).

    Any help is appreciated, thanks!

    Please Login or Register  to view this content.
    Last edited by cykamourn; 01-06-2015 at 08:18 AM.

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: How to get a macro to change to another worksheet, move data and then add date and tim

    Maybe:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    01-03-2015
    Location
    California
    MS-Off Ver
    2013
    Posts
    16

    Re: How to get a macro to change to another worksheet, move data and then add date and tim

    Thanks for a quick response! However, that achieves the same result I've been having. It replaces the cells on the active worksheet rather than writing into "ItemSold".

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: How to get a macro to change to another worksheet, move data and then add date and tim

    Does this help?

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    01-03-2015
    Location
    California
    MS-Off Ver
    2013
    Posts
    16

    Re: How to get a macro to change to another worksheet, move data and then add date and tim

    That works! Thanks very much!

  6. #6
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: How to get a macro to change to another worksheet, move data and then add date and tim

    You're welcome. Glad to help out and thanks for the feedback.

+ 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. [SOLVED] Macro to move cursor to column containing current date at worksheet activation
    By Snoddas in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-03-2013, 05:40 AM
  2. [SOLVED] Macro in excel to move a row of data from one worksheet to another worksheet
    By wmdowty in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-26-2013, 11:06 AM
  3. Replies: 0
    Last Post: 01-24-2013, 02:35 AM
  4. Date & Time of last worksheet change
    By Nunzio in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-28-2009, 04:01 PM
  5. Worksheet change macro takes too much time when run with update list macro
    By hunsnowboarder in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-01-2009, 09:40 AM

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