If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
finding a way to extract information to a new worksheet
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 |
#2
|
|||
|
|||
finding a way to extract information to a new worksheet
Amelia,
See help for the countif function. Good luck ray -----Original Message----- 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 . |
#3
|
|||
|
|||
finding a way to extract information to a new worksheet
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. -----Original Message----- 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 . |
#4
|
|||
|
|||
finding a way to extract information to a new worksheet
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. -----Original Message----- 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. -----Original Message----- 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 . . |
Thread Tools | |
Display Modes | |
|
|