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
Bookmarks