emailing autofilter results

[Dianeg]

A client is using 2007 autofilter to produce a filtered list, she then emails
the results to a colleague still in filtered format. When the colleague
receives the data it is the complete and unfiltered. I have tried this
several times successfully on my own data, each time the data remains
filtered. She says that she saves the data in it's filtered format. I've
tried that also and it works fine. What can be going wrong?

Any ideas would be gratefully receieved

Diane

 

[Ron de Bruin]

If you e-mail a filter result it is better to copy only the visible data
to a new workbook and send that.

1) Select the whole data range or if you not have empty rows/columns in the range
you can use Ctrl * to select all data or use F5>Special>Current region>OK with
one cell selected in the data range.
If it copy all the data (there are a few reports of 2007 users) use also the shortcut
Alt ; or F5>Special>Visible cells only>OK to select only the Visible cells.

2) Ctrl c in all Excel versions or:
Excel 97-2003: Edit>Copy
Excel 2007: Home tab>Clipboard group>Copy

3) Shift F11 in all Excel versions to insert a worksheet or:
Excel 97-2003: Insert>Worksheet
Excel 2007: Home tab>Cells group>Insert...Sheet
Or use button next to the last tab

4) Ctrl v in all Excel versions or:
Excel 97-2003: Edit>Paste
Excel 2007: Home tab>Clipboard group>Paste

5) Select the worksheet with the filter

6) Press Esc


For a code example see
http://www.rondebruin.nl/copy5_1.htm

And

http://www.rondebruin.nl/mail/folder2/row2.htm

 

[Ron de Bruin]

Oops

The example will insert a new worksheet

To open a new workbook replace

3) Shift F11 in all Excel versions to insert a worksheet or:
Excel 97-2003: Insert>Worksheet
Excel 2007: Home tab>Cells group>Insert...Sheet
Or use button next to the last tab

With

Ctrl n

To open a new workbook to paste the data

 

[Dianeg]

Thanks very much

Oops

The example will insert a new worksheet

To open a new workbook replace


With

Ctrl n

To open a new workbook to paste the data

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm



.