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?
Click to expand...

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?
Click to expand...

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...
Click to expand...

Bernard,
Thanks
Gene
 
Top