Now I'm aware of it, I've had a look at the other thread & see there's no answer as yet.
Try this attempt. I used the bottom used row of column A as a reference for the last cell in column E.
I notice you deleted the code for the bottom cell on column B, so I've left it that way. I presume you're going to be manually
entering data to the same row as the bottom of column A. If you don't & because you've used column B for your loop,
your loop won't do every used row in the other columns.
Added a bit of error checking to the Inputboxes. Formatted columns D&E as mm/dd/yyyy. Change to General if you want numbers
instead of dates.
Bookmarks