+ Reply to Thread
Results 1 to 2 of 2

Add new row with user prompt and copy specific cells only

  1. #1
    Registered User
    Join Date
    08-13-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    5

    Add new row with user prompt and copy specific cells only

    Hello all

    I need some assistance in developing a macro for the following scenario:

    I have a worksheet named "Equipment 1". I have a header in row 1, a text description in row 2, and entered numerical data and text in Row 3, Columns A thru Z. Column A in row 3 has a date entered. I would like to develop a macro where when a user pushes a command box, it prompts the user for a date, and enters that date into the next row (so for in this example, Row 4) in a MM/DD/YYYY scheme. Then, I would like the macro to copy specific data from several select cells from the previous row (Columns B, C, E) into the active row of the same worksheet.

    I have included an example of a before and after to show what I'm looking for. I have showed in the "AFTER" tab 2 iterations of this because I need this to be continuous every time the user hits the command button.

    The only thing not shown in the example file is the command box and the subsequent prompt of the user for a new date.

    Any help would be greatly appreciated.

    Profile.xlsx

  2. #2
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Add new row with user prompt and copy specific cells only

    Hi Backroads23

    Try the attached. Double Left Click on any cell in Column A.

    The Calendar Control Code is from here http://excel-it.com/free_addins.htm

    Let me know of issues.
    Attached Files Attached Files
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

+ 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