Thank you Bernie and Kassie. I'll look into filtering. If it were me
I'd use one sheet and filter it. Unfortunately I have to assume that
whoever uses it in the future is not used to Excel, so I'll probably
need to use multiple sheets.
Brian
"Kassie" wrote in message
...
The easiest way, as far as I can tell, would be to filter the list
in place,
for either live, silent or raffle. In this way, you can either see
the
entire list, or select what you want to see. Use Data|Filter and
Auto Filter.
If you have to have it in seperate sheets, then you can add a
formula to
cell A2 and B2of Sheets 2, 3 and 4: =Sheet1!A2 and =Sheet1!B2. Copy
these
down as far as you want to go, and then apply a filter to these
sheets, one
for silent, one for live and one for raffle. Although this will
result in a
lot of duplication, you will achieve what you want, and you will
only see the
relevant lines, while the rest will be hidden. Any other way will
be fraught
with danger
"bxb7668" wrote:
I've been tasked to create an auction spreadsheet for my PTA to
track
what has been donated; whether it's for the silent auction,
raffle, or
live auction; and who wins it for how much. It needs to be as user
friendly as possible, as I cannot guarantee that future Auction
Committee member will be good with Excel. (A database would
probably
be better, but we don't have one.) Since in the course of planning
the
auction an item may be moved back and forth between the silent
auction
and raffle and live auction many times, I want to be able to
automatically have another sheet that just lists Live Auction
items
and another that lists Raffle items and another for Silent Auction
items. With this background, let me explain what I'd like to do
and
ask if it is possible.
On the Inventory sheet I'd list the stuff that has been donated
and
have a column that would have the auction type, i.e. silent, live
or
raffle. Something like:
A B
1 Desc Auction
2 Boat Live
3 Candy Raffle
4 Dinner Silent
4 Cruise Live
There would then be three other sheets. One for each auction type.
The Live Auction sheet would use some function to just list the
items
on the Inventory sheet that had been categorized as "Live". It
should
end up looking like:
A B C D
1 Desc Item# Bidder Bid
2 Boat 101
3 Cruise 102
Is there a way to pull a subset of the rows from one sheet onto
another and not have blank lines for non-matching criterion? In
other
words, I do not want for the Live Auction sheet to look like:
A B C D
1 Desc Item# Bidder Bid
2 Boat 101
3 102
4 103
5 Cruise 104
where rows 3 and 4 are blank because they are not Live.
Any help is greatly appreciated.
Brian Bygland
|