Merging Documents

[Guest]

This is a little confusing, so I'll try and make it simple. I've got
workbook 'A' with worksheets 1 & 2. I've also got workbook 'B' with
worksheets 1, 2, 3, 4, 5 & 6. They are two separate documents. I know I can
move all of workbook 'B' over to workbook 'A', but what I want to know is
once I do that, is there a way to combine worksheet A2 with B6 without
messing up any of the formulas? Those two worksheets pretty much have all of
the data from the other worksheets and automatically update when the other
worksheets are changed. I'm sorry if i sound confusing!

 

[Dave Peterson]

I think it depends.

What are the formulas? And what do you mean by combine?

If you do it manually, do you mean copy the cells from B6 to the bottom of the
used range in A2?

And I guess it depends on what "mess up the formulas" means.

If I've got a formula that says =max(a:a), then by copying data at the bottom of
column A, the formula will still work, but may evaluate differently.

I think I'd just do it and see what happens to the formulas.