Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-20-2012, 01:50 PM
bullyingcanada bullyingcanada is offline Help? Windows 7 64bit Help? Office 2013
Novice
Help?
 
Join Date: Dec 2012
Posts: 1
bullyingcanada is on a distinguished road
Default Help?

Hi everyone - I'm looking for some help... I have a large list in Excel but I have some select data that I want to get from it.... Problem is, I don't know how to just export the selected data I need.

Example - my full database is below but I only want to export A, D, E and Z... How can I do this?

A
B
C
D
E
F
G
H
I
J


K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
Reply With Quote
  #2  
Old 12-20-2012, 03:03 PM
Astacus Astacus is offline Help? Windows XP Help? Office XP
Novice
 
Join Date: Dec 2012
Posts: 9
Astacus is on a distinguished road
Default Filter

It's not clear where you want to export it to, but an easy way that works in many cases is this:
1. Use the filter feature to select all rows that meet your criterion (In your example, just check A, D, E and Z).
2. Select all
3. Copy the selection to clipboard
4. Paste it wherever you want to put it.
Reply With Quote
Reply



Other Forums: Access Forums

All times are GMT -7. The time now is 09:04 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft