Hi this is my first post I've had a look round and wow I never knew you could do so much with excel! I'm definately gonna be back I'm considered good at excel at my company but if I could learn 10 of the stuff on here I would be a legend to them all lol
Anyway I can't find an answer to this problem anywhere I'm sure its simple but its got me stumped!
I've got a table structured like this (sorry I will learn proper way to post tables soon but it is late):
A----------B----------C
Adam---10/11/05---12
Adam---11/11/05---6
Adam---12/11/05---4
Adam---13/11/05---3
John----10/11/05---67
John----12/11/05---4
John----13/11/05---3
Jack----10/11/05---9
Jack----11/11/05---1
Jack----12/11/05---2
Jack----13/11/05---45
What I want is to have a sheet for each of Adam, John and Jack that shows there data. I have cell A1 that holds there name and the A3 onwards has the date and I want B3 onwards to hold the numbers from column C above that relate to the correct day and person.
This is a simplified version of what I want but if I can get this working I think I can get what I want to work.
Sorry if this is really simple but please post an answer it would really help me!
Oh by the way the dates are not always continous as you can see from john if he didnt sell anything one day then nothing appears. Also the sheets have all days down the left hand side and all sheets show the same dates ie 01/11/05-30/11/05.
Many thanks in advance
Anyway I can't find an answer to this problem anywhere I'm sure its simple but its got me stumped!
I've got a table structured like this (sorry I will learn proper way to post tables soon but it is late):
A----------B----------C
Adam---10/11/05---12
Adam---11/11/05---6
Adam---12/11/05---4
Adam---13/11/05---3
John----10/11/05---67
John----12/11/05---4
John----13/11/05---3
Jack----10/11/05---9
Jack----11/11/05---1
Jack----12/11/05---2
Jack----13/11/05---45
What I want is to have a sheet for each of Adam, John and Jack that shows there data. I have cell A1 that holds there name and the A3 onwards has the date and I want B3 onwards to hold the numbers from column C above that relate to the correct day and person.
This is a simplified version of what I want but if I can get this working I think I can get what I want to work.
Sorry if this is really simple but please post an answer it would really help me!
Oh by the way the dates are not always continous as you can see from john if he didnt sell anything one day then nothing appears. Also the sheets have all days down the left hand side and all sheets show the same dates ie 01/11/05-30/11/05.
Many thanks in advance