Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter & copy results programmatically
I'm using an Autofilter to filter class results & marks, I need to copy the
results into separate (already existing) spreadsheets, the problem I have is that the range initially selected on the first path is an absolute reference and changing the references to relative doesn't help either, as the results are filtered with their original column and row postitions. How do select the rows returned in the filter? I have about 100 spreadsheets to fill in this way. Many thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter & copy results programmatically
Hi Wendy
Start with the examples on this page http://www.rondebruin.nl/copy5.htm If you want mail the marks to students see http://www.rondebruin.nl/mail/folder1/row2.htm There is also a body example on my site and one that also send a attachement with Outlook -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Wendy" wrote in message ... I'm using an Autofilter to filter class results & marks, I need to copy the results into separate (already existing) spreadsheets, the problem I have is that the range initially selected on the first path is an absolute reference and changing the references to relative doesn't help either, as the results are filtered with their original column and row postitions. How do select the rows returned in the filter? I have about 100 spreadsheets to fill in this way. Many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofilter results | Excel Discussion (Misc queries) | |||
Using autofilter results | Excel Programming | |||
Opening Built-In Custom AutoFilter Dialog Box Programmatically | Excel Programming | |||
Automate Autofilter Results - Copy to New Sheet | Excel Programming | |||
Copy Autofilter results macro | Excel Programming |