Re: Displaying only specified values-not using Autofilter

No, it's not different, rather it seems I just described what I was
trying to do really poorly the first time around. I'm sorry about that.
Roger pointed me to a good site elsewhere in this thread, and I _think_
I can use that to accomplish what I'm trying to do (which is in fact
what you deduced below). Thanks for your time and effort, and sorry
about the confusion!

--
Dave Holman

Pete_UK wrote:
What you are describing here is totally different to what you say in
your first posting, or perhaps I misunderstood. You seem to be saying
now that you want to make a selection from the "1"s on *** 1 and have
only that selection displayed/copied to *** 2, followed by the
selection from the "2"s etc.

Is this correct?

Pete

David Holman wrote:

Two reasons, at least as near as I can tell. First, the number of rows
containing information is substantial; about 250 in fact. Only some of
those rows will contain the aforementioned values (1, 2, 3, etc.). To
provide a clearer example, say one is looking at items on a menu, or
classes at a University, or available workers. You might wish to select
'eggs', 'bacon', and 'sausage' for BREAKFAST, and 'steak' and
'potatoes' for DINNER, while omitting 'corn' and 'tofu' (using Data -->
Validation to create a list of options). Similar logic applies for
classes that someone might enroll in at University or workers who could
be assigned to Shift A,Shift B, and Shift C.

I'd like *** one then to only display those selected items. So say
the first area of the spread*** could be formatted to display all
items that were selected for 'BREAKFAST' or "WINTER SEMESTER', or
"SHIFT A'. Then the next section of the spread***, be it to the right
or further down the page, would display 'LUNCH', 'SHIFT B', etc. It
wouldn't be very valuable to first display, say, all of the breakfast
items, and then list the other 247 items just below that.

The second reason is simply aesthetic, and can be discarded if need be.
I want to create a consolidated *** wherein selections taken from a
fairly large database are consolidated and made easy to view for the
user. That way, they can tell at a quick glance what items have been
selected for each and every period (be it meals, semesters, or worker
shifts) without being distracted by having to view the other 98% of the
material that they have no use for. In other words, I'm trying to
simplify their planning by enabling them to view every selection for
't' periods at once.

--
Dave Holman

Don Guillett wrote:
Is there a reason not to SORT?

--
Don Guillett
SalesAid Software
dguillett1@xxxxxxxxxxxxx
"David Holman" <davidmholman@xxxxxxxxxxx> wrote in message
news:1164309221.074998.13000@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have a somewhat unusual question based on something that's stumped me
for over a week. I'm hoping the collective wisdom of this newsgroup
might be of some help.

I'm attempting to display all of the results of value "x" from one
*** on another. To elaborate, *** 2 has a column, let's call it
column A. Each cell in column A has a value, let's say, for simplicity
sake, "1", "2", "3", or "4". What I want to do is go back to *** 1
and format it in such a way that all of the rows containing value "1"
in the aforementioned cell are displayed, however many rows that
happens to be, be it one or fifteen. Next to or below these values, I
want to display the same data, only this time using all of the rows
containing value "2", and so on.

Obviously, I can't use something like a standard filter, as all that
will serve to do is compress all of the nonconforming rows to size
zero, and that's not really conducive to my goal of being able to
display _all_ of the results, based on each distinct value (1, 2, 3, or
4). Does doing this require a macro or some similar type of Excel magic
that I simply don't have the experience to either derive or understand,
or am I missing something reasonably straightforward?

Any help that can be provided would be greatly appreciated. Thanks in
advance!

--
Dave Holman


.

Loading