Ive got 2 xls file each with 7 tabs in them lets call them books A.xls and
B.xls. I want to take all the information from the 7 tabs in book A.xls and
place it in a new book called ZZZ.xls. So I have all the information from
book A placed in 1 sheet on ZZZ.xls. I know I can simply copy and paste this
information on tab at a time but the trick is I want anything that I update
in book A.xls to be reflected in my new file ZZZ.xls. So if I add a line in
the 3rd tab in book A I want it to show up in the appropriate place on my new
ZZZ.xls file. So how do I do this?

When you copy and paste use the Paste special on the edit menu. there is a
box on the bottom left corner labeled link. This will put a link link the
data rather than use the actual values.

"Bart Hautala PE DE" wrote:

Ive got 2 xls file each with 7 tabs in them lets call them books A.xls and
B.xls. I want to take all the information from the 7 tabs in book A.xls and
place it in a new book called ZZZ.xls. So I have all the information from
book A placed in 1 sheet on ZZZ.xls. I know I can simply copy and paste this
information on tab at a time but the trick is I want anything that I update
in book A.xls to be reflected in my new file ZZZ.xls. So if I add a line in
the 3rd tab in book A I want it to show up in the appropriate place on my new
ZZZ.xls file. So how do I do this?

Yes this works if I only change existing data but not if I add new data. When
I add new data to the original sheet and save it and open the new sheet it
ask me if I want to update so I say yes but the new data does not appear. Why
is this or what am I doing wrong?

"Joel" wrote:

When you copy and paste use the Paste special on the edit menu. there is a
box on the bottom left corner labeled link. This will put a link link the
data rather than use the actual values.

"Bart Hautala PE DE" wrote:

Ive got 2 xls file each with 7 tabs in them lets call them books A.xls and
B.xls. I want to take all the information from the 7 tabs in book A.xls and
place it in a new book called ZZZ.xls. So I have all the information from
book A placed in 1 sheet on ZZZ.xls. I know I can simply copy and paste this
information on tab at a time but the trick is I want anything that I update
in book A.xls to be reflected in my new file ZZZ.xls. So if I add a line in
the 3rd tab in book A I want it to show up in the appropriate place on my new
ZZZ.xls file. So how do I do this?

Because there are no links???

I think yoiu need to link empty cell where new data is going to get
enetered. then when the data does get entered in the old sheet it will be
seen in the new sheet.

Make sure when you do the paste special you do it twice. Once for the link.
Then repeat and pastte special format. You may not be seeing all the data
because the format is wrong.

"Bart Hautala PE DE" wrote:

Yes this works if I only change existing data but not if I add new data. When
I add new data to the original sheet and save it and open the new sheet it
ask me if I want to update so I say yes but the new data does not appear. Why
is this or what am I doing wrong?

"Joel" wrote:

When you copy and paste use the Paste special on the edit menu. there is a
box on the bottom left corner labeled link. This will put a link link the
data rather than use the actual values.

"Bart Hautala PE DE" wrote:

Ive got 2 xls file each with 7 tabs in them lets call them books A.xls and
B.xls. I want to take all the information from the 7 tabs in book A.xls and
place it in a new book called ZZZ.xls. So I have all the information from
book A placed in 1 sheet on ZZZ.xls. I know I can simply copy and paste this
information on tab at a time but the trick is I want anything that I update
in book A.xls to be reflected in my new file ZZZ.xls. So if I add a line in
the 3rd tab in book A I want it to show up in the appropriate place on my new
ZZZ.xls file. So how do I do this?