Help Linking and Grouping Data

HillBilly · May 7th, 2002, 04:25 AM

I need some help please...
My problem is I have 3 seperate sheets(each used for a different action), each with cols a-c the same: name, date, rating.

there are approx. 50 names each appearing more than once. On sheet 4 i want to be able to summerise each of the 3 sheets for one individual.so cols a-g name, sheet1 date & rating, sheet2 date & rating, sheet3 date & rating.

have tried vlookups but with one indivdual appearing a different number times on each sheet occuring on various dates. I have hit the wall and Need HELP!!!

Cheers

Tom Schreiner · May 7th, 2002, 06:20 AM

Hi
A HillBilly that says cheers?
Smiley here >>> <<< Don't know how to insert it.

Anyway, I am fairly new to functions, but I do not think you can use 3D ranges with a VlookUp???

It would not be difficult to use a macro to solve this.
Using one sheet as a key, so to speak, you could rundown the names and pick them off the other sheets, while adding them to the summary sheet.
I would like to see your workbook, if possible, before I try and spin a code example.
If not, I will wait and see if someone else can provide you with an alternative solution.
Tom

My Email is below...

_________________
Found a solution? If so, please post again so members of this board can spend their time helping others. Better still, edit your topic(intitial post), by tagging on a word or phrase such as, "Problem Solved", or "Resolved". Thanks for being courteous!

[ This Message was edited by: TsTom on 2002-05-07 05:20 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 7th, 2002, 04:25 AM	#1
HillBilly New Member Join Date: Apr 2002 Posts: 4	I need some help please... My problem is I have 3 seperate sheets(each used for a different action), each with cols a-c the same: name, date, rating. there are approx. 50 names each appearing more than once. On sheet 4 i want to be able to summerise each of the 3 sheets for one individual.so cols a-g name, sheet1 date & rating, sheet2 date & rating, sheet3 date & rating. have tried vlookups but with one indivdual appearing a different number times on each sheet occuring on various dates. I have hit the wall and Need HELP!!! Cheers

May 7th, 2002, 06:20 AM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi A HillBilly that says cheers? Smiley here >>> <<< Don't know how to insert it. Anyway, I am fairly new to functions, but I do not think you can use 3D ranges with a VlookUp??? It would not be difficult to use a macro to solve this. Using one sheet as a key, so to speak, you could rundown the names and pick them off the other sheets, while adding them to the summary sheet. I would like to see your workbook, if possible, before I try and spin a code example. If not, I will wait and see if someone else can provide you with an alternative solution. Tom My Email is below... _________________ Found a solution? If so, please post again so members of this board can spend their time helping others. Better still, edit your topic(intitial post), by tagging on a word or phrase such as, "Problem Solved", or "Resolved". Thanks for being courteous! [ This Message was edited by: TsTom on 2002-05-07 05:20 ]