Automating data explosions

Paul in the UK

New Member
Joined
Mar 2, 2011
Messages
6
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.
 
Last edited:

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

cjcobra

Board Regular
Joined
Apr 9, 2002
Messages
193
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

New Member
Joined
Mar 2, 2011
Messages
6
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.
 

Forum statistics

Threads
1,176,486
Messages
5,903,348
Members
435,020
Latest member
rustyesimpson

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top