Excel VBA Code Help

[markster]

Afternoon 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 to 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 it.

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

Cheers
Mark

 

[Joe4]

Duplicate: VBA Code help

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).