Thanks for the response, but I think I do want to create a macro. I want the macro to auto-fill the end of month dates in rows. I would like to provide a start and end date and then have the macro automatically fill the number of rows needed based on a monthly end of month date. I started a spreadsheet and created an "Input" tab that would keep my variables and then for now I manually copied down my months to show how I would ultimately want it to look. Any help with the macro (including a button for someone to push) would be great! I've attached my spreadsheet I have started with.
|