Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Copying only selected items to another worksheet

I have an extensive price list w/ three columns: Part#, Description, and
Price. I would like to be able to place an 'x' before only items I need and
have them be copied to an 'Order' worksheet.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 65
Default Copying only selected items to another worksheet

If i understand correctly, put an x in column d for the ones you want.
Then filter (data, filter, auto filter).
In column D, use the drop down filter to show only those with X

Copy and paste from there.

Remember to put column headers on before you filter


--
Rob Gaffney


"firewaterjoe" wrote:

I have an extensive price list w/ three columns: Part#, Description, and
Price. I would like to be able to place an 'x' before only items I need and
have them be copied to an 'Order' worksheet.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Have 2 items in dropdown, want warning if one selected movermike Excel Worksheet Functions 1 November 24th 05 02:20 AM
Items, when selected doesn't appear!? Pivot Table Question? Items Excel Discussion (Misc queries) 1 October 28th 05 09:31 PM
named range, data validation: list non-selected items, and new added items KR Excel Discussion (Misc queries) 1 June 24th 05 05:21 AM
Is it possible to copy only selected items to another worksheet... HEATHERCOX Excel Worksheet Functions 2 March 1st 05 01:21 PM
selected items flash Johan Tufvander Excel Discussion (Misc queries) 2 February 17th 05 01:13 PM


All times are GMT +1. The time now is 12:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"