Excel VBA

TO ANTHONY:

Hi Anthony,

I trust you are well.

I had an urgent enquiry relating to some data I have to populate on a daily basis - I am currently having some difficulty coding the process, even though I have attempted to use the course delegate file as a template.

It is not a complicated process, literally some data in excel which needs to be categorised by: a monthly date, agent and product, ie three separate spreadsheets.

Please advise on the simplest coding to format some data in excel and resave it under separate tabs.

Thanks,

Vijay