Automating data explosions

[Paul in the UK]

I am new to VBA, is there a way to copy selected data from one spreadsheet and copy it to a new spreadsheet please.
I have to run an EOM.csv file of 15000+ rows and split these into different accounts and would like to automate this by selecting set criteria and exploding the data to new tabs, some of which have the colums in a different order.
I have read a few excel books but have found nothing that points me in the right direction.
Any help would be gratefully apreciated.

 

[cjcobra]

The easiest way to get started with VBA is to record the steps you want, then look at the code it generates. You can then copy/paste and edit the code. I usually do one step, then use that as many times as needed for the base code.

 

[Paul in the UK]

Excellent advice thank you, I am starting to get to grips with what happens now I can see how the macro compiles it.
Thanks for your help.