Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
How do I find out what items are in one list but not in another l. | Excel Discussion (Misc queries) | |||
Drop List Referencing | Excel Worksheet Functions | |||
Creating a dynamic list | Excel Worksheet Functions | |||
Creating a list from an existing list. | Excel Worksheet Functions |