Hello,

I currently have a macro that is reformatting input data that comes in a particular form. What i need is for a prompt box to come up during the process, asking the user what date this data is from(entered in MMDDYY), then for that information to populate column A to the last row of data.

Thank you in advance for the help!