Making a Database
 

Hello,

I was wondering is it possible to make a database that copies info from one
Sheet to another?

For example if we had 12 sheets below like

January
February
March
April
May
June
July
August
September
October
November
December


Can we take some data that is on January's Sheet and Add it to July's Sheet?

I know Excel to a point, but my boss wants me to come up with this Marathon
Database Sheet and I have NO idea how and I know even less about Access.

Thank you!

~Nikki

Making a Database
 

Yes you can take some data from January to July.

Do you want to copy it? See "linking" in Help

Do you want to move it? Would require VBA to do this.

We need more details before a complete answer can be given.

Like what data from January and what would be the logic involved to trigger the
copy/move?


Gord Dibben MS Excel MVP

On Mon, 11 Feb 2008 14:30:22 -0800, Darlin-Nikki
wrote:

Hello,

I was wondering is it possible to make a database that copies info from one
Sheet to another?

For example if we had 12 sheets below like

January
February
March
April
May
June
July
August
September
October
November
December


Can we take some data that is on January's Sheet and Add it to July's Sheet?

I know Excel to a point, but my boss wants me to come up with this Marathon
Database Sheet and I have NO idea how and I know even less about Access.

Thank you!

~Nikki

Making a Database
 

In this database he wants to have it like this. Lets say there is only 10
people running. The First Column are the racers, the second is the time they
finished and the third is the age group they are in.

A 6 10*15
B 3 21*25
C 4 10*15
D 2 16*20
E 7 21*25
F 10 16*20
G 8 10*15
H 1 21*25
I 9 16*20
J 5 10*15

What he is wanting to do with different sheets is to make one for racers
finishing in order.

H 1 21*25
D 2 16*20
B 3 21*25
C 4 10*15
J 5 10*15
A 6 10*15
E 7 21*25
G 8 10*15
I 9 16*20
F 10 16*20


And another sheet for the age bracket

C 4 10*15
J 5 10*15
A 6 10*15
G 8 10*15
D 2 16*20
I 9 16*20
F 10 16*20
H 1 21*25
B 3 21*25
E 7 21*25


Now how do I make it that the information on Sheet One transfers the info on
to sheet 2 & 3.

Like I write in that Racer A came in 6th over all and 3rd in the 10-15 yo
bracket.



HELP PLEASE!!!!

~Nikki

"Gord Dibben" wrote:

Yes you can take some data from January to July.

Do you want to copy it? See "linking" in Help

Do you want to move it? Would require VBA to do this.

We need more details before a complete answer can be given.

Like what data from January and what would be the logic involved to trigger the
copy/move?


Gord Dibben MS Excel MVP

On Mon, 11 Feb 2008 14:30:22 -0800, Darlin-Nikki
wrote:

Hello,

I was wondering is it possible to make a database that copies info from one
Sheet to another?

For example if we had 12 sheets below like

January
February
March
April
May
June
July
August
September
October
November
December


Can we take some data that is on January's Sheet and Add it to July's Sheet?

I know Excel to a point, but my boss wants me to come up with this Marathon
Database Sheet and I have NO idea how and I know even less about Access.

Thank you!

~Nikki