Filling down a table to current month/date with VBA up to current month

Hi Everyone,
Brain struggling with this one and not sure if it's possible.

I want to detect the current month/year and just extend the table in spanning columns A-G downwards to this month.
Cells in column B, C, D, E, F & G have a formula that just copies down automatically then.

Screenshot 2019-02-11 at 19.20.31.png

I found this code online and adjusted it slightly but it goes beyond this month, into 2021 and I only want it to go to this month (not sure if it's a serial thing or?) (That's if I enter 1 as the month and the year as 2019 in the popup entry box, that is).

Please Login or Register  to view this content.

Is it possible to do this?

Any help greatly appreciated, brain throbbing.

All the best,
Paul

Does this have to be done with VBA?
Could this be done with conditional formatting?

Hi jrean042,
Ah, do you mean with a formula that only fills in the cells if they have a value across in columns B-G?

If yes, I guess that could be. One question then is will the graph that is drawing from that data not just show a drop off the end, or will it detect to not draw the empty cells?

Regards,
Paul

Hi Mumps,
That definitely extended the table, but beyond the date like this:

Screenshot 2019-02-11 at 20.17.48.png

Regards,
Paul

Hi Mumps,
I don't seem to have a link in the toolbar at the top (maybe greyed out?) so I've popped it on Google drive here (sorry about the dull topic of the spreadsheet ):

https://drive.google.com/open?id=1gF...e-G17nwj1ajBhH

(I'm going to do it for each country code tab which I have code to cycle through the tabs, but for now just trying to get it working on the FI tab as an example).

Regards,
Paul

Hi Mumps,
That's absolutely amazing, wow. Thankyou very much indeed, it worked like a charm.

Just going to go through it and try to learn from it.

Could I ask, in the original Macro I sent, it sort of worked, but some reason it was extending by many months and not up to the the current, why was it doing that (for my learning?) and why Excel was getting confused with that?

Best Regards,
Paul

Hi Mumps,
I think it does. Will play around with it and try and learn even more. Really grateful for your script, and appreciate the time you put into it for me as it would have taken me hours (days?)

Best Regards,
Paul