List Working Days of the month

**Suzette** · 07-01-2010, 10:55 AM

Good Day;

I recieve an extract from our Financial System monthly which list all the balances for each date of the month (both workings day and week-end(Sat. and Sun.)).

I would like to create a macro which will extract only working date (Mon.- Fri) and the balances in the columns.

I am very new to VBA.

Thanks.

**shg** · 07-01-2010, 10:58 AM

Don't think you need a macro for this. Post an example workbook.

**Suzette** · 07-07-2010, 02:02 PM

Thanks for the assistance.

Attached please find extract of dump from system.

**shg** · 07-07-2010, 02:42 PM

So what should it look like when it's done?

**Suzette** · 07-09-2010, 10:14 AM

Alright what I wanted, that instead of every month downloading the data and manually deleting the columns for the weekend. I wanted a formula that will check if A1 = B1 then delete Coloum B, then loop again to check if A1 = [new]B1 then delete elseIf A1 <>B1 then move to C1=D1 and compare again