Copying 'sliced' data

ma0ffst08

Board Regular
Joined
Apr 22, 2008
Messages
114
Hi guys,


I have a sheet set up with slicers.
The sliced data sits in a sheet called Impact, row 17 and 18 to row n.
Row 17 and 18 are header rows. Then data sits in row 19 downwards.


I want a macro which copies the 'sliced' data into a new workbook called Newbook, onto a sheet called analogue.


Currently my macro doesn't work, it copies all rows, whether included within the sliced data or not.


Any ideas greatly appreciated.


Thanks!
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Watch MrExcel Video

Forum statistics

Threads
1,109,308
Messages
5,527,930
Members
409,793
Latest member
mavrik_stet

This Week's Hot Topics

Top