VBA Code help

[markster]

Morning everyone

I was hoping someone might be able to help me with some VBA code.

Basically I have a 22000 line spreadsheet and need to

1. Look at the date in Column C (data starts at A2) and shade date cell in Red if date is before todays date (i.e. it is overdue), Shade in Amber if date is within 3 months of todays date.

2. Add a column Title to F1 entitled Admin Team Comments

3 Add a column title G1 entitled Client Manager comments

4. Create separate spreadsheets for each client manager name which is listed from E2 downwards i.e john smith has a separate workbook with all his date in and so on

5. Save separate spreadsheets by client manager name in my documents and add date so the spreadsheet i.e John Smith - 29-Jan-20

It's going to be a big task to do manually so if anyone can help I'd much appreciate.

Thanks in advance and please let me no if anything isn'

 

[offthelip]

there is very easy way( and a better way I think) to do this without using VBA. create two extra columns of data with a simple equatoin in one:
=C2<today()
In the other column put equation:
=c2 < DATE(YEAR(TODAY()),MONTH(TODAY())+3,DAY(TODAY()))
Then use conditional formatting to generate the colours in the column.
I am great believer in NOT using colours to signify logical conditions. two reason it is very slow to do even using vba, and secondly it doesn't work when printed in black and white