***Two Input Data Tables***

  • Thread starter Thread starter rbekka
  • Start date Start date
R

rbekka

Hi there,

I have a sheet with multiple data input (row and column) tables -
several other sheets are linked to this data. I would like to make this
user friendly and put the input cells on a new sheet and hide the actual
data table sheet from the end user (also to lock it down).

I have tried to use the usual cell ref formula and also naming ranges.
Neither seem to work.

I would like any ideas on how to make this workbook user friendly and
take the input cells away from the actual input tables.

Thanks so much.
 
You could enter the values on the input sheet.
Hi there,

I have a sheet with multiple data input (row and column) tables -
several other sheets are linked to this data. I would like to make this
user friendly and put the input cells on a new sheet and hide the actual
data table sheet from the end user (also to lock it down).

I have tried to use the usual cell ref formula and also naming ranges.
Neither seem to work.

I would like any ideas on how to make this workbook user friendly and
take the input cells away from the actual input tables.

Thanks so much.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Interactive Data Input Boxes 6
Inputting data into two worksheets 3
Adding worksheets using sumproduct function gives error 14
link data that changes each month 1
Input sheet with INDEX formula 4
Auto Populate fields based upon dropdown selection 4
Attempted edit of protected cell jumps user to another cell 2
cells linked from worksheet to worksheet 1

Back
Top