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

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

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,141,015
Messages
5,703,743
Members
421,312
Latest member
Mooncake1

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