Auto Populating a Cell with a Date 15 days away

Hi All,

I am new to the Excel VBA world and looking for some help with a simple macro that I would like to use on a Financial Document.

I have been looking through internet forums for awhile now and haven't quite come across what I'm looking for yet.

What I hope to accomplish is a macro, that when activated, will reference the next open cell in a column, then fill it with a date that is 14 days away from the date in the cell right above that new cell.

I have attached an image of what I hope the finish copy will look like by just manually entering in dates to a column but I would love some help to get this into a working macro form!

Thanks!

CK

For clarification, are you looking for a button to be placed on a sheet then you want to select a new field. once the new field is selected, are you then looking to push that button and a date will show up in that selected cell that is 14 days from the date above it? Is that what you are looking for?

.

Please Login or Register  to view this content.

Hi Maniacb,

Thank you for the macro! It was a good example to read through and implement, great for my learning. Your first assumption was very close. I was also interested in being able to just press a button at the top of the page and having it auto create a new line and add the next 14 day date after that (without me having to select that new line).

Thank you again for the help!

CK

@Cknutson575, i would like to help, but where do we know to create the new row in what column. Shall we assume that there is only one column on the page? Did you try @Logit's solution and did that one work? Thanks

Here is an update,

Please Login or Register  to view this content.

Maniacb,

I havent yet tried logit's solution yet but I will tonight. I have attached some screen shots to this post labeled stage 1, stage 2, stage 3 in an attempt to illustrate what I would like to have happen after each button press. I would like everything to be fully automated except the actual dollar amounts that are input into the different categories.

So things that I hope to automate are:
Auto inserting a new row after each button press
Auto filling a date on that new row in the date column
Auto increasing the range of the sum calculation at the end of each category

There may be some more nuances that I simply don't know because of my lack in knowledge but I hope to learn them from this small project.

I really appreciate all the help.

@Cknutson575, can you upload your working file so we can incorporate your requirements, as per the yellow banner above. Thanks

Try this file, see if it meets your requests.

Maniacb,
This works perfectly! Thank you so much for the help. If it isnt too much would it be possible for you to add comments to the VBA code so that I can learn what you are doing with each command? I am trying to recreate this by myself to learn and I think I am following what you are doing but I would appreciate the comments to confirm my learning.
Thank you!

Here is the code commented for you:

Please Login or Register  to view this content.

This code works with the spreadsheet sum() formula by always entering a new line/row in the existing summation.