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

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" <[email protected]> wrote in message
news:[email protected]...
> 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

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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
> >
> >
> >