Excel formula - because it is beyond my expertise can Excel do this: I want to post 3 scenarios on Worksheet A. User will click a check box or something to make one of the 3 true. If they were to check Scenario 1, then on Worksheet B, A1=1, A2=2, A3=3; if they click Scenario 2, then A1=4, A2=5, A3=6 and so forth. Can you write the formula in Worksheet A so that clicking or choosing one of the 3 will place/write those values in the corresponding cells on Worksheet B? I want the user to be able to, if any of the 3 scenarios are not applicable, they can go to Worksheet B and place/write the values in A1, A2, and A3 on their own (which would overwrite the formula (if written) in Worksheet B - thus the poser - can you write the formula in Worksheet A and have it "place the text or value" in Worksheet B. Any help or pointing me in the right direction helps. thanks

Sure, Mick, you can do this. In Worksheet B, go to the cell where you want the Worksheet A data, hit the + key and then switch to Worksheet A, place the cursor in the cell with the new data and hit enter. Now, Worksheet B will have that data, and your formula can work on it. I do this sort of thing every day. You can link just about anything to just about anything else. I hope this helps. Bob :)

Yes Bob! that helps alot. Since you do this often, can i ask you then - what if the individual decided none of the 3 scenarios are applicable and then starts to fill in the data on their own, THEN, realizing they kind of screwed up the worksheet and should start over. Rather than closing and not saving their work and opening up a fresh template, is there a formula or macro I could write that would 1) clear te contents of the cells in Worksheet B and 2) place all the "+-links" back in Worksheet B? Thanks for your help.

Oh and one more poser PC Bob - in your first response, your formula - if the cell in Worksheet A is blank(null), I want it to return a blank cell as well, not "0.0" or "0" - If the values in Worksheet B are 0 in Worksheet A, then I want it (the cell) in Worksheet B to be blank. Thanks again - you rock!

Good questions, Mick. I don't have Excel here at home, so I'll have to look into this tomorrow at work. As for the blank cells, I think there is a setting somewhere in there for that. As for the one about entering it and then realizing they made a mistake, I always rely on the Undo button. It's saved my butt many times! I'm not sure how many Undo's you can do, but, again, I think that's settable in the preferences somewhere, too. I love Excel, and I use it for everything. Even mtho I'm using the old 97 verwsion, it's still the best thing around, I think. Good luck. Bob

ok, i was able to answer the p.s. poser by putting an if statement in Worksheet B: =IF(C17="",0,(C17*150) +(IF(E17="",0,(E17*135)) +(IF(G17="",0,(G17*75))))) This formula is in column I. It is totalling the values of the cells in Column(s) C, E and G and then multiplying them by their respective $rates. The values in C, E and G are coming from Worksheet A using your "+" formula. The formula in Worksheet A says if it is null, then leave it blank. What was happening when the value was Null is in the above formula, the total in Column I for that would would return a "#Value" result so the above IF statement then takes that cell if it has a " " value and gives it a "0" value so it can add the 3 columns together and aesthetically, leave the cell blank rather than placing a "0" in it. I guess there may be a more experienced way to do this but im kind of new at this. Am interested though to see what you can find out about clearing the cells and resetting Worksheet B back to its original state (formula, etc.) Thanks for your help Bob. Mick