The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » How to copy autofilter data

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

How to copy autofilter data

Resolved · Low Priority · Version 2003

ReplyMon 1 Mar 2010, 22:17Delegate Michael said...

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

For upcoming training course dates see: Pricing & availability

ReplyWed 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

Thanks

Stephen

Excel articles

· Customize Your Gridlines And Borders In Excel 2007
· How To Use Slicers In Excel 2010
· From novice to expert users - Microsoft Excel fits all
· You're Hired! Raising Your Chances Of Employment With Excel
· Excel: Save Time With AutoFill

Please browse our web site to find out more about
basic excel training and other Microsoft training courses.

Excel tip:

Use the Ctrl-key for quick navigation in Excel 2010

If you want to move quickly to the right, left, top or bottom of your spreadsheet, just press Ctrl and one of the arrow keys. If you want to then select all the data in that particular row or column, hold down the Shift key and press Ctrl and an arrow key.

View all Excel hints and tips

Helpful hints to practice?

» Forum post: Creating 3d formulas

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions

Mini sitemap. These are the main areas of our web site. Full sitemap.

Management training

Professional Skills courses
Project Management Course London
Project Management Courses London
Project Management Training London
Project Management Training
Project Seminar
Project Seminars
Time Management Course London
Time Management London
Time Management Courses London
Time Management Training London
Introduction to Finance course
Assertiveness Skills course
Effective Communications Skills training
Presentation Skills London