98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » How to copy autofilter data
How to copy autofilter data
Resolved · Low Priority · Version 2003
Mon 1 Mar 2010, 22:17Delegate Michael said...
Michael has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
How to copy autofilter data
Can someone please tell me how I tell excel 2003 to display the value selected from an autofilter list into another cell, be it on the same sheet or another sheet?
I have a dummy workbook. On sheet1, I would like cell A3, B3, C3, D3, E3, to display the value selected from their respective list. Any help would be greatly appreciated. Thanks Mikal. (It's only easy if you know how!)
A B C D E F G H
1
2
3
4 U S G Y E1 E M SC
5 1 AB M N B 1.32.07.777
Wed 3 Mar 2010, 14:35Trainer Stephen said...
RE: how to copy autofilter data
Hi Michael
Thanks for your question
I am a little unclear as to the structure of your workbook. It would be a great help if you could email me a copy of your dummy workbook, so that I might be able to come up with a solution.
My email is sw@stl-training.co.uk
Thanks
Stephen
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Screen Splitters in ExcelScreen splitter icons can be set from the ribbon bar, or dragged from the scroll bars. The icon just above the up arrow on the right scroll bar controls the horizontal splitter; the icon to the right of the right arrow on the bottom scroll bar controls the vertical splitter. |
