PLEASE HELP!sorting data using auto filter & paste the results onto seperate sheets?
 

Hi,

I'm new to VBA and I've attempted to record a macro to sort my data b
"Currency" i.e. AUD, GBP, CAD etc... and copy the data onto seperat
sheets under the currency headings. So basically I would have 1 shee
with a variety of currencies and after the macro had run I would hav
several sheets, each with containd data in relation to a particula
currency.

i.e. 1 sheet for AUD
1 Sheet for CAD
1 Sheet for USD etc....

I don't know how to ensure that all the filtered data is taken an
copied to a new sheet without having to specify the cells to be copie
each time..

I know this is simple to someone who uses excel and VBA all the time
but unfortunately I'm new to it!

I would be grateful for any help with this! and if someone could tel
me the answer, you will make me very happy indeed!

Please Help
Cheers,
JP :

--
Jay
-----------------------------------------------------------------------
Jay3's Profile: http://www.excelforum.com/member.php...fo&userid=1634
View this thread: http://www.excelforum.com/showthread.php?threadid=27764

PLEASE HELP!sorting data using auto filter & paste the results ont
 

Hi
check out:
http://www.rondebruin.nl/copy5.htm

"Jay3" wrote:


Hi,

I'm new to VBA and I've attempted to record a macro to sort my data by
"Currency" i.e. AUD, GBP, CAD etc... and copy the data onto seperate
sheets under the currency headings. So basically I would have 1 sheet
with a variety of currencies and after the macro had run I would have
several sheets, each with containd data in relation to a particular
currency.

i.e. 1 sheet for AUD
1 Sheet for CAD
1 Sheet for USD etc....

I don't know how to ensure that all the filtered data is taken and
copied to a new sheet without having to specify the cells to be copied
each time..

I know this is simple to someone who uses excel and VBA all the time,
but unfortunately I'm new to it!

I would be grateful for any help with this! and if someone could tell
me the answer, you will make me very happy indeed!

Please Help
Cheers,
JP :)


--
Jay3
------------------------------------------------------------------------
Jay3's Profile: http://www.excelforum.com/member.php...o&userid=16349
View this thread: http://www.excelforum.com/showthread...hreadid=277645