Advanced Excel Help

[bertusgeert 1]

alright - I have searched for hours without finding an answer, and I always find one on here...see if you can follow along:

I have two Excel WORKBOOKS: #1 and #2.
in each, I have two sheets i.e.
book1sheet1
book1sheet2
book2sheet1
book2sheet2

I have a formula in book1sheet1 that depends on data in book1sheet2.

HERE IS THE PROBLEM: I want to copy the FORMULA from book1sheet1 to the corresponding cell in book2sheet1 so that the forumala in book2sheet1 will depend on data in book2sheet2.

Pasting, Paste Special, and all the other crap I tried makes the copied formula, now in book2sheet1, depend on data in book1sheet2.

I want an INDEPENDENT workbook (book2), that doesn't depend on book1.

Anyone know how to do this?! Please?

---------------------------------------------
As jy dom is moet jy bloei!

[BIGUN 1,471]

If I understand correctly that your goal is to have a single workbook...

Have you tried renaming the tab (rght-clk - Rename) on book1sheet1 to test
Then, renaming the tab on book1sheet2 to test2

Right-clicking on the tab in book1sheet1 and doing a "copy" to "insert prior" to book2sheet1
Right-clicking on the tab in book1sheet2 and doing a "copy" to "insert prior" to book2sheet2
To place everything in a single workbook and then test your formula?

http://exceltips.vitalnews.com/Pages/T002686_Moving_a_Worksheet_to_Another_Workbook.html

Nobody has time to listen; because they're desperately chasing the need of being heard.

[bertusgeert 1]

That's a solution - but my real workbook is 5 sheets, all interdependent, the entire width of the book, 400 lines, that has to be saved every couple of days, same format. That way when crap goes wrong, it looks the same as it did yesterday and it is easy to figure out.

However, I found the solution (I hope, we'll see). It's as simple as copying all the formulas you want (which, after being copied is now dependent on another workbook&sheet), and then going to EDIT>>Links>>Change Source -> and selecting the workbook itself, so it will source internally.

Let's pray that it works!

Thanks though

---------------------------------------------
As jy dom is moet jy bloei!