Workbook 1 to workbook 2

G

Gene DeLallo

I have an identical column of numbers in workbook 1 and Workbook 2.
if I change the numbers in Workbook 1 how can I set it up so that the
numbers automatically change in Workbook 2?
 
B

Bernard Rey

I have an identical column of numbers in workbook 1 and
Workbook 2. if I change the numbers in Workbook 1 how
can I set it up so that the numbers automatically change
in Workbook 2?

The formula:
=[Workbook1]Sheet1!A1

in WorkBook2, Sheet1, cell A1, will replicate the content.

To make it easy, simply type "=" (without the quotes) in
the first cell (let's say "A1") on the second sheet. Then
click in the corresponding cell ("A1" too, then) on the
first sheet and then strike the "Enter" key.

Then, get rid of the "$" symbols in that cell (thus having
a formula like the one above) and copy the cell down as
much as needed. Here you are...
 
G

Gene DeLallo

Bernard Rey said:
I have an identical column of numbers in workbook 1 and
Workbook 2. if I change the numbers in Workbook 1 how
can I set it up so that the numbers automatically change
in Workbook 2?

The formula:
=[Workbook1]Sheet1!A1

in WorkBook2, Sheet1, cell A1, will replicate the content.

To make it easy, simply type "=" (without the quotes) in
the first cell (let's say "A1") on the second sheet. Then
click in the corresponding cell ("A1" too, then) on the
first sheet and then strike the "Enter" key.

Then, get rid of the "$" symbols in that cell (thus having
a formula like the one above) and copy the cell down as
much as needed. Here you are...

Bernard,
Thanks
Gene
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top