close

I have a pivot table showing a top 10 from a list of 400 and i want to
be able to produce 10 seperate sheets 1 for each of the top 10, I know
i can do it by clicking on the totals but is there a way i can do it so
i can include it in a macro ?

I have tried using pages but this just runs off the whole 400 sites and
kills my machine

I admit i know nothing about VB so the simpler it is the better for me
it will be

Thnx in advance
--
chris.howes
------------------------------------------------------------------------
chris.howes's Profile: www.excelforum.com/member.php...foamp;userid=5660
View this thread: www.excelforum.com/showthread...hreadid=516240

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()