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 for each sheet name(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 .
also cross posted here
https://www.excelforum.com/excel-pr...month-based-on-current-month.html#post5928144
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 for each sheet name(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 .
also cross posted here
https://www.excelforum.com/excel-pr...month-based-on-current-month.html#post5928144