Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Mark Jackson
 
Posts: n/a
Default List incrementally?

Hello,

Is it possible to insert the Company Name, Unit Cost, and Extended Price
into a different spreadsheet incrementally based on one criteria "Won" or
"Lost"? I have a spread sheet that has 200 rows that keeps track of what we
have won and the companies we have lost to. I want to list all the companies
that we lost to but listed on another sheet by rows. Any help is appreciated.

Mark
  #2   Report Post  
Bernie Deitrick
 
Posts: n/a
Default

Mark,

Get out of the mind-set that you need separate worksheets. Simply insert
another column, labeled "Won/Lost" and enter either "Won" or "Lost" into
that column for each row. Then use Data Autofilter to show just those with
"Won" or those with "Lost". It's a lot easier.

HTH,
Bernie
MS Excel MVP

"Mark Jackson" wrote in message
...
Hello,

Is it possible to insert the Company Name, Unit Cost, and Extended Price
into a different spreadsheet incrementally based on one criteria "Won" or
"Lost"? I have a spread sheet that has 200 rows that keeps track of what

we
have won and the companies we have lost to. I want to list all the

companies
that we lost to but listed on another sheet by rows. Any help is

appreciated.

Mark



  #3   Report Post  
Mark Jackson
 
Posts: n/a
Default

Bernie,

I need a separate worksheet because that is the sheet I print out for my
report each month. All the information is in worksheet A which contains the
won / lost data. I would like to be able to print out the report without
manually inputting the company name, price which will change each month. (Ex:
Anytime the is a "Lost" in column J then the company name and price is
automatically placed in row 3 on worksheet B, if there is another "Lost" in
column J then it would be automatically placed on row 4 in worksheet B.) I
know I am not explaining it the right way. Thanks for your help.

Mark

"Bernie Deitrick" wrote:

Mark,

Get out of the mind-set that you need separate worksheets. Simply insert
another column, labeled "Won/Lost" and enter either "Won" or "Lost" into
that column for each row. Then use Data Autofilter to show just those with
"Won" or those with "Lost". It's a lot easier.

HTH,
Bernie
MS Excel MVP

"Mark Jackson" wrote in message
...
Hello,

Is it possible to insert the Company Name, Unit Cost, and Extended Price
into a different spreadsheet incrementally based on one criteria "Won" or
"Lost"? I have a spread sheet that has 200 rows that keeps track of what

we
have won and the companies we have lost to. I want to list all the

companies
that we lost to but listed on another sheet by rows. Any help is

appreciated.

Mark




  #4   Report Post  
Bernie Deitrick
 
Posts: n/a
Default

Mark,

If you simply apply the autofilter and choose to show only the "Lost" values
in column J, then you would get _exactly_ the same result.

If you absolutely need another worksheet, then simply apply the filter,
select all the cells, use Edit / Go To... Special Cells "Visible Cells
Only" then copy and paste the values onto a new sheet.

HTH,
Bernie
MS Excel MVP

"Mark Jackson" wrote in message
...
Bernie,

I need a separate worksheet because that is the sheet I print out for my
report each month. All the information is in worksheet A which contains

the
won / lost data. I would like to be able to print out the report without
manually inputting the company name, price which will change each month.

(Ex:
Anytime the is a "Lost" in column J then the company name and price is
automatically placed in row 3 on worksheet B, if there is another "Lost"

in
column J then it would be automatically placed on row 4 in worksheet B.)

I
know I am not explaining it the right way. Thanks for your help.

Mark

"Bernie Deitrick" wrote:

Mark,

Get out of the mind-set that you need separate worksheets. Simply

insert
another column, labeled "Won/Lost" and enter either "Won" or "Lost" into
that column for each row. Then use Data Autofilter to show just those

with
"Won" or those with "Lost". It's a lot easier.

HTH,
Bernie
MS Excel MVP

"Mark Jackson" wrote in message
...
Hello,

Is it possible to insert the Company Name, Unit Cost, and Extended

Price
into a different spreadsheet incrementally based on one criteria "Won"

or
"Lost"? I have a spread sheet that has 200 rows that keeps track of

what
we
have won and the companies we have lost to. I want to list all the

companies
that we lost to but listed on another sheet by rows. Any help is

appreciated.

Mark






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
Extracting Values on one list and not another B Schwarz Excel Discussion (Misc queries) 4 January 7th 05 02:48 PM
How do I find out what items are in one list but not in another l. Michelle Craig Excel Discussion (Misc queries) 2 December 22nd 04 09:32 PM
Drop List Referencing Boony Excel Worksheet Functions 2 November 11th 04 12:42 PM
Creating a dynamic list JarrodA Excel Worksheet Functions 3 October 30th 04 04:01 AM
Creating a list from an existing list. Jad Excel Worksheet Functions 1 October 29th 04 06:00 AM


All times are GMT +1. The time now is 10:41 PM.

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

About Us

"It's about Microsoft Excel"