finding a way to extract information to a new worksheet

  • Thread starter Thread starter Amelia
  • Start date Start date
A

Amelia

Can I label infomation on one sheet and have it
extrapolate to a second.

example:

MARCH
Today Orange 1
purple 99
tomorrow green 93
Yellow 7
Yesterday Orange 88
red 6
yellow 5
purple 1
future green 75
red 20
yellow 5

I already total the infomation month-by-month and by all
the Todays, tomorrows, yeasterdays and futures. Can I
build another Sheet to automatically take all the Oranges
and all the Greens and all the other colors and total them
without me having to identify each and every cell
individually?

Can it recognize "Orange" and the cell next to it and add
it to the Orange total?

As I already organize the data two different ways. It's
a large worksheet densly packed with all kinds of
information... I can't just reorganize or sort this data
so all the oranges and reds are together and then total.
There's too much at stake.

Thank you for understanding this. Hoping someone can be
of help,

Amelia
 
Not really enough information in your question. Hopefully
you are using the sumif or vlookup function to find the
total for the separate items, which you can also you on
the new formula. Keep in mid that if you look for oranges
on ALL the sheets, you will count some of them twice,
maybe three times - since today becomes tomorrow..

If you're are not using the sumif or vlookup, you may want
to consider it since you don't need to identify individual
cells - but rather the array.
 
I've looked at both sumif and vlookup and they don't give
me what I want.

I'll try to explain again. I've got Excel 97 and could be
upgraded to 2000 if necessary.

I have a workbook with sheets for each month. On each
sheet we've divided by department. We have two summary
sheets which are showing monthly purchase totals and year-
to-date dapartment purchase totals. Now, we need to look
at this information a third way.

Each department makes a purchase of, say, pens. One P.O.
One date. But, different color pens. I would like to be
able to list one the one line that has all the rest of the
information (so as not to duplicate it) that they
purchased 50 pens: 10 Red, 10 Green, 10 Black, 10 Blue, 10
Gold.

Then I want to be able to extract from each department
monthly how many Blue pens is our company buying in total.

I have 265 variables that need to be tracked.

Does this explain it any better?

Thank you.
 
Back
Top