Hi,
I have been tasked with creating a database, which will run macros each month to export the data into Excel but applying a split to the data depending on the name of each company (a separate sheet per company). I have created a macro to export the data, which works fine all into one sheet but I cannot for the life of me work out how to apply the split.
I have read many posts that are similar but I have to admit that I am a complete beginner to this and the VBA coding that has been provided goes completely over my head.
Is there anyone that can take pity on me and give me a bit of a dummy's guide to how this can be done?
Any help or advice would be much appreciated.
Rhian
I have been tasked with creating a database, which will run macros each month to export the data into Excel but applying a split to the data depending on the name of each company (a separate sheet per company). I have created a macro to export the data, which works fine all into one sheet but I cannot for the life of me work out how to apply the split.
I have read many posts that are similar but I have to admit that I am a complete beginner to this and the VBA coding that has been provided goes completely over my head.
Is there anyone that can take pity on me and give me a bit of a dummy's guide to how this can be done?
Any help or advice would be much appreciated.
Rhian