D
dan
I'm trying to do a very simple thing and I think I'm making it a lot
harder for myself than I need to. Here's my deal: I have a calculator
spreadsheet in my workbook with all my measurements; we'll call it
"Calculator" . I have another sheet in this workbook with formulas
linked back to the Calculator that we'll call the "Layout". The result
of this exercise is to produce the exact layout of dimensions to write
on the slab of a custom home. The one thing I'm having problems is
creating a formula to make the R.O. dims link back to the Calculator. I
have height in one cell and width in another and I am trying to merge
the two into one cell and put an "x" in-between. I tried doing this
in a very bone-head way by just saying:
=(Calculator!B10)""x""(Calculator!B6); that didn't work because I
don't know how to allow labels. I can't find the
"Tools>Options" menu that the help viewer suggests. It's simply
not there. If anyone can help, please email me
(e-mail address removed). Thanks for your help.
Dan Jones
harder for myself than I need to. Here's my deal: I have a calculator
spreadsheet in my workbook with all my measurements; we'll call it
"Calculator" . I have another sheet in this workbook with formulas
linked back to the Calculator that we'll call the "Layout". The result
of this exercise is to produce the exact layout of dimensions to write
on the slab of a custom home. The one thing I'm having problems is
creating a formula to make the R.O. dims link back to the Calculator. I
have height in one cell and width in another and I am trying to merge
the two into one cell and put an "x" in-between. I tried doing this
in a very bone-head way by just saying:
=(Calculator!B10)""x""(Calculator!B6); that didn't work because I
don't know how to allow labels. I can't find the
"Tools>Options" menu that the help viewer suggests. It's simply
not there. If anyone can help, please email me
(e-mail address removed). Thanks for your help.
Dan Jones