#1   Report Post  
Old February 18th 14, 07:15 PM
Junior Member
 
First recorded activity by ExcelBanter: Feb 2014
Posts: 2
Default Newbie Help

I am trying to create a worksheet for my salesguys.

They have a list of 897 items to choose from (plant cultivars, sizes etc.) I would like them to put how many plants they need in column E, then I would like Excel to copy and paste any number that is larger than 0 to another worksheet, that I could give to the supervisor and purchase the plant stock.

How do I do this?

Thanks in advance!

Chris

  #2   Report Post  
Old July 19th 14, 02:14 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2014
Posts: 4
Default Newbie Help

Chris, a couple of ways of doing this, albeit one of them doesn't use an
extra sheet.

Easiest and simplest way to do everything in one place is to simply add a
filter to Col E and filter out 0, leaving just the items selected. No need
for additional sheet.

If you really want an additional sheet, I would look at using a Pivot Table,
pulling fields A into the body of the report, and E into the Values
section in the middle. I would then also pull E into the Report Filter and
simply choose the option to select multiple items and deselect 0.

You would need to get rid of all the subtotals, and probably go into the
Pivot Table options (Right click on the Pivot table), go to the Display Tab
and choose the "Classic PivotTable Layout".

Any time they change their selections, just right click on the table and
choose the Refresh option.

Regards
Ken............................



"Chris P" wrote in message ...


I am trying to create a worksheet for my salesguys.

They have a list of 897 items to choose from (plant cultivars, sizes
etc.) I would like them to put how many plants they need in column E,
then I would like Excel to copy and paste any number that is larger than
0 to another worksheet, that I could give to the supervisor and purchase
the plant stock.

How do I do this?

Thanks in advance!

Chris




--
Chris P



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
NEWBIE Tom Snyder Excel Discussion (Misc queries) 1 June 8th 07 06:47 PM
Real Newbie newbie question Dave New Users to Excel 0 January 10th 07 07:55 PM
Newbie help... Don Bright Excel Programming 0 December 30th 05 04:21 PM
Newbie Pls help Sileesh Excel Programming 5 November 12th 04 05:47 AM
Newbie harmonicace Excel Programming 1 January 15th 04 06:32 PM


All times are GMT +1. The time now is 06:38 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017