Earlier, I posted a request for a macro that would automatically add on dates to the last existing date in an Excel table's C column when the sheet or workbook is opened. However, I failed to specify that all of the previous dated rows needed to stay and that new rows should be appended to the existing rows preceding the new dated rows. I have, as of now, the following two macros generously offered by Mumps1 and Fluff13, do a nice job of adding on the missing dates following 7/10/20 up to today's date of 7/19/20.
Please Login or Register to view this content.
However, the preceding dates of 7/1/20 through 7/9/20 also get wiped out and replaced with these dates, and interestingly, leaves the D and E column information in the same row number location... Not exactly what I wanted. It was an oversight on my part not to clarify that the preceding rows needed to be left in place and that new rows with the newer dates should be appended to them. So, to further clarify, the C column should have dates starting with 7/1/20 in row #2, 7/2/20 in row #3, 7/3/20 in row #4,... all the way to today's (or the most current) date of 7/19/20... not just having 7/10/20 in the worksheet row #2 and ending with 7/19/20 in row #11.Please Login or Register to view this content.
The goal is to allow the user of this form to not have to enter the date value and therefore ensure that dates are entered in consecutive order.
Please help. Attached is the workbook.
Bookmarks