Looping cells with offsets?

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

The sheets are separated by month, from September to June, with the dates in rows D, I, N, S, X; and columns 3,31, 59, 87, 115.

Columns have letters, rows have numbers.
It sounds like you are just wanting to fill in the dates.

Why can't you just put a formula in each date cell in a template and when you add the first date in the sheet the rest of the cells will automatically fill in with the date?

No VBA code needed.

In your example before sheet you would leave D3 empty since that will never need a formula.
In I3 the formula would be =D3+1
In N3 the formula would be =I3+1 etc.
When you then enter a date in D3 the other cells will update for each Monday you have to have the formula equal to the previous Friday + 3

Okay now I see what you want. You threw me off by putting 9/8 as your first date.

So with this macro you can start with your calendar blank or you can leave the previous dates in as long as you clear the dates that are before the one you want to start with.
For instance in the sample file I've uploaded there is an existing calendar for November with the 2nd being the date in the first Monday.
So if you wanted to do one for December with the 1st being in Tuesday then just clear out D3 and put December 1st in to cell I3 and you can leave the other dates beyond that cell in and you'll be fine, the code will change dates and empty all cells after the month ends.

I put a button in cell A1 to make it easy to run the macro.

Please Login or Register  to view this content.