VBA for prompt box to populate column

[highwyre237]

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!

[jaslake]

I'm not sure what you're trying to do but the attached will prompt the user to enter a date and then fill column A with that date. The procedure assumes the data ends at the last row in column B. If this is not the case, modify the macro accordingly.

Hope this helps. J