Add Weekdays, in column A and some format - required a vba

Hi,

we have a database where we are trying to add weekdays in column A and after that it will add blank row if its Thursday

Process is
1. Add a column A
2. Start adding weekdays
3. Add a blank row after every Thursday
4. We required only following weekdays

Friday
Monday
Tuesday
Wednesday
Thursday

if there is no data in weekday it will be blank row, you can check sheet2

we have also attached a demo data sheet with result sheet
Sheet1 is data sheet and Sheet2 is result sheet

advice pls

Without a macro, although if you wanted a macro I'd simply perform these steps with a macro

1. Add a new column A and in A2 enter

Formula:

Please Login or Register  to view this content.

and copy this down
2. Add the formula

Formula:

Please Login or Register  to view this content.

, i.e. the first Thursday to the next blank cell in column D
3. Add the formula

Formula:

Please Login or Register  to view this content.

, i.e. where D32 is the cell containing the formula above. Copy this down
4. Copy this down for n / 5 rows where n is the number of rows in the data
5. Now sort the data on column D ascending
6. Autofilter for blanks in column C, then select all the visible dates in column D that you've added and delete them and remove the autofilter

thanks Richard Buttrey for the help,

thank you very much Richard Buttrey

can we do it through vba, pls

vba added in subject.

Hi to all.
Ok, lets follow-up. This version of my macro may need some more testing but with the example file is working.

Please Login or Register  to view this content.

Hi,

Here's a macro that automates the process I described. Make sure you run it when the data sheet is the active sheet.

Please Login or Register  to view this content.

Ok, let's make the macro partially dynamic, all you have to do is set the new variable dsr as needed.
I have marked the consequent changes in the code.

Please Login or Register  to view this content.