Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hidden Protected Formula?
Hello all,
Hopefully there is a simple answer to my question. I have two worksheets that are the same, I enter numerical data on them. I primarily enter data on the first worksheet, the second worksheet (which looks exactly the same) has data entered that needs to be added to the same corresponding areas on the primary worksheet. Here is the problem that I am having. I can make formula's that cover the primary sheet that say =+Secondary!G4 and when I put something into the secondary worksheet it does add to the primary. However since I enter data on the primary worksheet also, I find myself having to rewrite the formula every time I enter new data. Is there any way integrate the forumla to the cell so that I can enter data into it without erasing the formula? Thanks for any help you can offer. James O |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions |