M
minnie_mo
I am creating a form in Excel that can be filled out by any user, and the
data entered by the user on the first page should be automatically shown on
subsequent pages so that the user doesn't have to reenter the data over and
over.
I created this process by going to each subsequent page (other than page
one), typing an = sign where I want to replication, then clicking on the tab
for Worksheet #1 and clicking on the cell I want to replicate. I hit the
ENTER key, a voila, the formula is set.
What I don't want, is to show zeros where I have placed formulas in cells on
the subsequent pages. Because some of the formulated cells require numbers,
or X's in checkboxes, it might get confusing to show on check box with an X
and others with a Zero.
Is there a way to have Excel NOT show the zeros in these cells on subsequent
pages, and just show blank cells?
Oh, I neglected to mention that I am protecting (and locking) the
non-fillable cells in the workbook, including those cells that should be
automatically filled by the formula above. Not sure if this matters, but
thought I should include it nevertheless.
Thanks!!
data entered by the user on the first page should be automatically shown on
subsequent pages so that the user doesn't have to reenter the data over and
over.
I created this process by going to each subsequent page (other than page
one), typing an = sign where I want to replication, then clicking on the tab
for Worksheet #1 and clicking on the cell I want to replicate. I hit the
ENTER key, a voila, the formula is set.
What I don't want, is to show zeros where I have placed formulas in cells on
the subsequent pages. Because some of the formulated cells require numbers,
or X's in checkboxes, it might get confusing to show on check box with an X
and others with a Zero.
Is there a way to have Excel NOT show the zeros in these cells on subsequent
pages, and just show blank cells?
Oh, I neglected to mention that I am protecting (and locking) the
non-fillable cells in the workbook, including those cells that should be
automatically filled by the formula above. Not sure if this matters, but
thought I should include it nevertheless.
Thanks!!