I am using Excel 2003. I want to be able to enter/update data in one
spreadsheet so that corresponding data in another, related spreadsheet also
updates automatically. I think both spreadsheets will be in the same
workbook. I also want to ensure that since the lines of each spreadsheet
will hold related data that the correct line is updated.

Is there a name for this procedure/formula?

If the cell you're referencing is in the same workbook, you can just
reference the sheet and the cell. the following example references cell A5
in Sheet 1 from another worksheet.

=Sheet1!A5

If the cell you wish to reference resides in another workbook you would
reference the workbook, worksheet followed by the cell address:

=[Book1]Sheet1!$A$5


--
Kevin Backmann


"Allie" wrote:

I am using Excel 2003. I want to be able to enter/update data in one
spreadsheet so that corresponding data in another, related spreadsheet also
updates automatically. I think both spreadsheets will be in the same
workbook. I also want to ensure that since the lines of each spreadsheet
will hold related data that the correct line is updated.

Is there a name for this procedure/formula?

Thank you Kevin,

If I were to read further on this, would it be called "referencing" because
I have a book on Excel 2003 but there's nothing in the index called
"referencing"?

So I simply put an equals sign (=), name of the sheet i want to link
(Sheet1,2,3 etc), add an exclamation mark (!) then the two or more cells I
want linked (A5)?

Couple of questions:

1) Can I link more than one sheet in this way
2) Can i link more than two cells?
3) Can I link rows like this?
2) What is the exclamation mark for?
3) if the two cells are both A5 in each worksheet that's fine, but if they
are different cell names, how do I reference (A5 + A6 for example?)

This referencing is new to me, so apologies if I sound dumb!

Allie

"Kevin B" wrote:

If the cell you're referencing is in the same workbook, you can just
reference the sheet and the cell. the following example references cell A5
in Sheet 1 from another worksheet.

=Sheet1!A5

If the cell you wish to reference resides in another workbook you would
reference the workbook, worksheet followed by the cell address:

=[Book1]Sheet1!$A$5


--
Kevin Backmann


"Allie" wrote:

I am using Excel 2003. I want to be able to enter/update data in one
spreadsheet so that corresponding data in another, related spreadsheet also
updates automatically. I think both spreadsheets will be in the same
workbook. I also want to ensure that since the lines of each spreadsheet
will hold related data that the correct line is updated.

Is there a name for this procedure/formula?

If you go to Excel Help and type in "cell referencing" it should take you a
help page with the following heading:

About cell and range references

The following links are on that page:

The A1 reference style
The differences between relative and absolute references
The 3-D reference style The R1C1 reference style

The reference type that was illustrated in my last reply is the 3-D
reference style.

I think you'll find some much needed information on these help screens.

The only dumb questions are the ones that go unasked.




--
Kevin Backmann


"Allie" wrote:

Thank you Kevin,

If I were to read further on this, would it be called "referencing" because
I have a book on Excel 2003 but there's nothing in the index called
"referencing"?

So I simply put an equals sign (=), name of the sheet i want to link
(Sheet1,2,3 etc), add an exclamation mark (!) then the two or more cells I
want linked (A5)?

Couple of questions:

1) Can I link more than one sheet in this way
2) Can i link more than two cells?
3) Can I link rows like this?
2) What is the exclamation mark for?
3) if the two cells are both A5 in each worksheet that's fine, but if they
are different cell names, how do I reference (A5 + A6 for example?)

This referencing is new to me, so apologies if I sound dumb!

Allie

"Kevin B" wrote:

If the cell you're referencing is in the same workbook, you can just
reference the sheet and the cell. the following example references cell A5
in Sheet 1 from another worksheet.

=Sheet1!A5

If the cell you wish to reference resides in another workbook you would
reference the workbook, worksheet followed by the cell address:

=[Book1]Sheet1!$A$5


--
Kevin Backmann


"Allie" wrote:

I am using Excel 2003. I want to be able to enter/update data in one
spreadsheet so that corresponding data in another, related spreadsheet also
updates automatically. I think both spreadsheets will be in the same
workbook. I also want to ensure that since the lines of each spreadsheet
will hold related data that the correct line is updated.

Is there a name for this procedure/formula?

You're so helpful - but I am unable to access any online help pages through
my software. Its a problem I have had for a long time and seems to affect
all software on my computer, hence I have to ask in forums like these or
consult manuals!

Allie

"Kevin B" wrote:

If you go to Excel Help and type in "cell referencing" it should take you a
help page with the following heading:

About cell and range references

The following links are on that page:

The A1 reference style
The differences between relative and absolute references
The 3-D reference style The R1C1 reference style

The reference type that was illustrated in my last reply is the 3-D
reference style.

I think you'll find some much needed information on these help screens.

The only dumb questions are the ones that go unasked.




--
Kevin Backmann


"Allie" wrote:

Thank you Kevin,

If I were to read further on this, would it be called "referencing" because
I have a book on Excel 2003 but there's nothing in the index called
"referencing"?

So I simply put an equals sign (=), name of the sheet i want to link
(Sheet1,2,3 etc), add an exclamation mark (!) then the two or more cells I
want linked (A5)?

Couple of questions:

1) Can I link more than one sheet in this way
2) Can i link more than two cells?
3) Can I link rows like this?
2) What is the exclamation mark for?
3) if the two cells are both A5 in each worksheet that's fine, but if they
are different cell names, how do I reference (A5 + A6 for example?)

This referencing is new to me, so apologies if I sound dumb!

Allie

"Kevin B" wrote:

If the cell you're referencing is in the same workbook, you can just
reference the sheet and the cell. the following example references cell A5
in Sheet 1 from another worksheet.

=Sheet1!A5

If the cell you wish to reference resides in another workbook you would
reference the workbook, worksheet followed by the cell address:

=[Book1]Sheet1!$A$5


--
Kevin Backmann


"Allie" wrote:

I am using Excel 2003. I want to be able to enter/update data in one
spreadsheet so that corresponding data in another, related spreadsheet also
updates automatically. I think both spreadsheets will be in the same
workbook. I also want to ensure that since the lines of each spreadsheet
will hold related data that the correct line is updated.

Is there a name for this procedure/formula?

Here are some sites that might be of some assistance:

http://kb.iu.edu/data/ahdm.html

http://www.worldstart.com/tips/tips.php/940

http://www.csun.edu/itr/guides/excel/2000/beg03.html

http://www.peachpit.com/articles/art...&seqNum=2&rl=1

Hope this helps...
--
Kevin Backmann


"Allie" wrote:

You're so helpful - but I am unable to access any online help pages through
my software. Its a problem I have had for a long time and seems to affect
all software on my computer, hence I have to ask in forums like these or
consult manuals!

Allie

"Kevin B" wrote:

If you go to Excel Help and type in "cell referencing" it should take you a
help page with the following heading:

About cell and range references

The following links are on that page:

The A1 reference style
The differences between relative and absolute references
The 3-D reference style The R1C1 reference style

The reference type that was illustrated in my last reply is the 3-D
reference style.

I think you'll find some much needed information on these help screens.

The only dumb questions are the ones that go unasked.




--
Kevin Backmann


"Allie" wrote:

Thank you Kevin,

If I were to read further on this, would it be called "referencing" because
I have a book on Excel 2003 but there's nothing in the index called
"referencing"?

So I simply put an equals sign (=), name of the sheet i want to link
(Sheet1,2,3 etc), add an exclamation mark (!) then the two or more cells I
want linked (A5)?

Couple of questions:

1) Can I link more than one sheet in this way
2) Can i link more than two cells?
3) Can I link rows like this?
2) What is the exclamation mark for?
3) if the two cells are both A5 in each worksheet that's fine, but if they
are different cell names, how do I reference (A5 + A6 for example?)

This referencing is new to me, so apologies if I sound dumb!

Allie

"Kevin B" wrote:

If the cell you're referencing is in the same workbook, you can just
reference the sheet and the cell. the following example references cell A5
in Sheet 1 from another worksheet.

=Sheet1!A5

If the cell you wish to reference resides in another workbook you would
reference the workbook, worksheet followed by the cell address:

=[Book1]Sheet1!$A$5


--
Kevin Backmann


"Allie" wrote:

I am using Excel 2003. I want to be able to enter/update data in one
spreadsheet so that corresponding data in another, related spreadsheet also
updates automatically. I think both spreadsheets will be in the same
workbook. I also want to ensure that since the lines of each spreadsheet
will hold related data that the correct line is updated.

Is there a name for this procedure/formula?

Thanks very much for that...

"Kevin B" wrote:

Here are some sites that might be of some assistance:

http://kb.iu.edu/data/ahdm.html

http://www.worldstart.com/tips/tips.php/940

http://www.csun.edu/itr/guides/excel/2000/beg03.html

http://www.peachpit.com/articles/art...&seqNum=2&rl=1

Hope this helps...
--
Kevin Backmann


"Allie" wrote:

You're so helpful - but I am unable to access any online help pages through
my software. Its a problem I have had for a long time and seems to affect
all software on my computer, hence I have to ask in forums like these or
consult manuals!

Allie

"Kevin B" wrote:

If you go to Excel Help and type in "cell referencing" it should take you a
help page with the following heading:

About cell and range references

The following links are on that page:

The A1 reference style
The differences between relative and absolute references
The 3-D reference style The R1C1 reference style

The reference type that was illustrated in my last reply is the 3-D
reference style.

I think you'll find some much needed information on these help screens.

The only dumb questions are the ones that go unasked.




--
Kevin Backmann


"Allie" wrote:

Thank you Kevin,

If I were to read further on this, would it be called "referencing" because
I have a book on Excel 2003 but there's nothing in the index called
"referencing"?

So I simply put an equals sign (=), name of the sheet i want to link
(Sheet1,2,3 etc), add an exclamation mark (!) then the two or more cells I
want linked (A5)?

Couple of questions:

1) Can I link more than one sheet in this way
2) Can i link more than two cells?
3) Can I link rows like this?
2) What is the exclamation mark for?
3) if the two cells are both A5 in each worksheet that's fine, but if they
are different cell names, how do I reference (A5 + A6 for example?)

This referencing is new to me, so apologies if I sound dumb!

Allie

"Kevin B" wrote:

If the cell you're referencing is in the same workbook, you can just
reference the sheet and the cell. the following example references cell A5
in Sheet 1 from another worksheet.

=Sheet1!A5

If the cell you wish to reference resides in another workbook you would
reference the workbook, worksheet followed by the cell address:

=[Book1]Sheet1!$A$5


--
Kevin Backmann


"Allie" wrote:

I am using Excel 2003. I want to be able to enter/update data in one
spreadsheet so that corresponding data in another, related spreadsheet also
updates automatically. I think both spreadsheets will be in the same
workbook. I also want to ensure that since the lines of each spreadsheet
will hold related data that the correct line is updated.

Is there a name for this procedure/formula?

I always right click on the cell I want to copy. Select copy, go to the sheet
where you want the information and right click again. Click on Paste Link.
This way as the info is updated in the other sheet, it is updated in all
links. This also works between workbooks. When you open the workbook it will
ask if you want to UPdate. Select yes and all your link cells will be updated
with the new info.
--
Life is an adventure, are you living it?

These are just my opinions, please feel free to correct them if they are
wrong.


"Allie" wrote:

Thanks very much for that...

"Kevin B" wrote:

Here are some sites that might be of some assistance:

http://kb.iu.edu/data/ahdm.html

http://www.worldstart.com/tips/tips.php/940

http://www.csun.edu/itr/guides/excel/2000/beg03.html

http://www.peachpit.com/articles/art...&seqNum=2&rl=1

Hope this helps...
--
Kevin Backmann


"Allie" wrote:

You're so helpful - but I am unable to access any online help pages through
my software. Its a problem I have had for a long time and seems to affect
all software on my computer, hence I have to ask in forums like these or
consult manuals!

Allie

"Kevin B" wrote:

If you go to Excel Help and type in "cell referencing" it should take you a
help page with the following heading:

About cell and range references

The following links are on that page:

The A1 reference style
The differences between relative and absolute references
The 3-D reference style The R1C1 reference style

The reference type that was illustrated in my last reply is the 3-D
reference style.

I think you'll find some much needed information on these help screens.

The only dumb questions are the ones that go unasked.




--
Kevin Backmann


"Allie" wrote:

Thank you Kevin,

If I were to read further on this, would it be called "referencing" because
I have a book on Excel 2003 but there's nothing in the index called
"referencing"?

So I simply put an equals sign (=), name of the sheet i want to link
(Sheet1,2,3 etc), add an exclamation mark (!) then the two or more cells I
want linked (A5)?

Couple of questions:

1) Can I link more than one sheet in this way
2) Can i link more than two cells?
3) Can I link rows like this?
2) What is the exclamation mark for?
3) if the two cells are both A5 in each worksheet that's fine, but if they
are different cell names, how do I reference (A5 + A6 for example?)

This referencing is new to me, so apologies if I sound dumb!

Allie

"Kevin B" wrote:

If the cell you're referencing is in the same workbook, you can just
reference the sheet and the cell. the following example references cell A5
in Sheet 1 from another worksheet.

=Sheet1!A5

If the cell you wish to reference resides in another workbook you would
reference the workbook, worksheet followed by the cell address:

=[Book1]Sheet1!$A$5


--
Kevin Backmann


"Allie" wrote:

I am using Excel 2003. I want to be able to enter/update data in one
spreadsheet so that corresponding data in another, related spreadsheet also
updates automatically. I think both spreadsheets will be in the same
workbook. I also want to ensure that since the lines of each spreadsheet
will hold related data that the correct line is updated.

Is there a name for this procedure/formula?

Thanks, I'm going to have a good practice over the weekend - If I get the job
I was interviewed for yesterday I HAVE to be able to do this stuff next week,
so thanks for all your help and here's hoping I can do it with confidence!...

"Hanr3" wrote:

I always right click on the cell I want to copy. Select copy, go to the sheet
where you want the information and right click again. Click on Paste Link.
This way as the info is updated in the other sheet, it is updated in all
links. This also works between workbooks. When you open the workbook it will
ask if you want to UPdate. Select yes and all your link cells will be updated
with the new info.
--
Life is an adventure, are you living it?

These are just my opinions, please feel free to correct them if they are
wrong.


"Allie" wrote:

Thanks very much for that...

"Kevin B" wrote:

Here are some sites that might be of some assistance:

http://kb.iu.edu/data/ahdm.html

http://www.worldstart.com/tips/tips.php/940

http://www.csun.edu/itr/guides/excel/2000/beg03.html

http://www.peachpit.com/articles/art...&seqNum=2&rl=1

Hope this helps...
--
Kevin Backmann


"Allie" wrote:

You're so helpful - but I am unable to access any online help pages through
my software. Its a problem I have had for a long time and seems to affect
all software on my computer, hence I have to ask in forums like these or
consult manuals!

Allie

"Kevin B" wrote:

If you go to Excel Help and type in "cell referencing" it should take you a
help page with the following heading:

About cell and range references

The following links are on that page:

The A1 reference style
The differences between relative and absolute references
The 3-D reference style The R1C1 reference style

The reference type that was illustrated in my last reply is the 3-D
reference style.

I think you'll find some much needed information on these help screens.

The only dumb questions are the ones that go unasked.




--
Kevin Backmann


"Allie" wrote:

Thank you Kevin,

If I were to read further on this, would it be called "referencing" because
I have a book on Excel 2003 but there's nothing in the index called
"referencing"?

So I simply put an equals sign (=), name of the sheet i want to link
(Sheet1,2,3 etc), add an exclamation mark (!) then the two or more cells I
want linked (A5)?

Couple of questions:

1) Can I link more than one sheet in this way
2) Can i link more than two cells?
3) Can I link rows like this?
2) What is the exclamation mark for?
3) if the two cells are both A5 in each worksheet that's fine, but if they
are different cell names, how do I reference (A5 + A6 for example?)

This referencing is new to me, so apologies if I sound dumb!

Allie

"Kevin B" wrote:

If the cell you're referencing is in the same workbook, you can just
reference the sheet and the cell. the following example references cell A5
in Sheet 1 from another worksheet.

=Sheet1!A5

If the cell you wish to reference resides in another workbook you would
reference the workbook, worksheet followed by the cell address:

=[Book1]Sheet1!$A$5


--
Kevin Backmann


"Allie" wrote:

I am using Excel 2003. I want to be able to enter/update data in one
spreadsheet so that corresponding data in another, related spreadsheet also
updates automatically. I think both spreadsheets will be in the same
workbook. I also want to ensure that since the lines of each spreadsheet
will hold related data that the correct line is updated.

Is there a name for this procedure/formula?