add dates until finishing the month based on current month

**tubrak** · 03-04-2024, 12:19 AM

Hi
I search for macro to insert new column contains date(today) on the header after column C until finishing the month based on current month ,
should start after STOCK sheet from JAN sheet to DEC sheet. every sheet contains MONTH name depends on current month . so should add date(today) every day until finishing the month based on current month . with considering don't repeat inserting column if I added new column for day no need adding again for the same day.
I put the result for JAN,FEB,MAR after column C .
by the way the sheets names will already be existed .

**JohnTopley** · 03-04-2024, 11:41 AM

Why not create ALL month sheets in one go?

And avoid dark text on dark background : do dark/light or light/dark

**tubrak** · 03-05-2024, 12:17 AM

Why not create ALL month sheets in one go?

that's because when add each sheet based on current month .

And avoid dark text on dark background : do dark/light or light/dark

what's the problem with theses colors?!

**tubrak** · 03-06-2024, 11:18 PM

Else body could help me?

**tubrak** · 03-09-2024, 12:32 AM

cross posted
https://chandoo.org/forum/threads/ad...t-month.56362/

**tubrak** · 03-14-2024, 07:05 AM

bump

**AliGW** · 03-14-2024, 07:08 AM

Huge set of data - lots of empty columns - no expected results - 231 views - no help offered. What do you expect?

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

**tubrak** · 03-14-2024, 07:20 AM

lots of empty columns

yes and this is what I want, will insert empty column for date(today) based on current month until finshing of dates for current month and will move to next sheet to do the same thing based on current month.

**tubrak** · 03-17-2024, 04:54 AM

I'm not sure what is not exactly clear?!

**JohnTopley** · 03-17-2024, 06:52 AM

Why do not do as I suggested in post #2 and create the 12 monthly sheets in one go: I see no advantage or merit in doing it in the way you propose.

Sample VBA

Please Login or Register  to view this content.

**tubrak** · 03-17-2024, 10:26 PM

Thanks
I will see your code how works and comeback soon.

**tubrak** · 03-18-2024, 04:39 AM

Why do not do as I suggested in post #2 and create the 12 monthly sheets in one go: I see no advantage or merit in doing it in the way you propose.

becuase I got macro by jindon in earlier time to create sheets based on current month , not at once as you suggest.
the macro will add sheet(month) based on current month , copy the just A,B and last column from sheet to next sheet(current month) so I don't need macro to create sheets again as you did it that's why I ask for each sheet individually based on current month.
ok based on your comment that's not impossible or difficult for you.
but can adjust your code by just add dates for the active sheets after column C and if it's possible make borders and formatting without creat sheets because will existed by jindon's macro .

**jindon** · 03-18-2024, 05:46 AM

Please Login or Register  to view this content.

**tubrak** · 03-18-2024, 06:02 AM

it's perfect !

thanks so much ,jindon for modfying the original code instead of create new macro .

**tubrak** · 03-25-2024, 06:13 AM

Hi jindon !
sorry comeback .
I try to change refernce row by start from row4 instead of row1 as in OP but gives error
as bold reference cells I changed but I'm faild , may you help me again, please?

Please Login or Register  to view this content.

**jindon** · 03-26-2024, 05:00 AM

Please Login or Register  to view this content.

**tubrak** · 03-26-2024, 05:21 AM

it works !
again thank you so much for comeback for me.

add dates until finishing the month based on current month

LinkBack

Thread Tools

Rate This Thread

Display

add dates until finishing the month based on current month

Re: add dates until finishing the month based on current month

Re: add dates until finishing the month based on current month

Re: add dates until finishing the month based on current month

Re: add dates until finishing the month based on current month

Re: add dates until finishing the month based on current month

Re: add dates until finishing the month based on current month

Re: add dates until finishing the month based on current month

Re: add dates until finishing the month based on current month

Re: add dates until finishing the month based on current month

Re: add dates until finishing the month based on current month

Re: add dates until finishing the month based on current month

Re: add dates until finishing the month based on current month

Re: add dates until finishing the month based on current month

Re: add dates until finishing the month based on current month

Re: add dates until finishing the month based on current month

Re: add dates until finishing the month based on current month

Thread Information

Users Browsing this Thread

Similar Threads

total of days within current month with dates from before the current month and year

[SOLVED] Determine work days in current month or next month based on day of the month

[SOLVED] Pick a cell containing current month actulas based what the current month is.

VBA: Piviot table Month auto select based on current month?

VBA: Piviot table Month auto select based on current month?

[SOLVED] Help with a system to auto populate month names based on current month

[SOLVED] VBA to identify the current month and previous month based on system date

Bookmarks

Bookmarks

Posting Permissions