can i input info in excell one page at a time instead of seeing .

  • Thread starter Thread starter barry
  • Start date Start date
B

barry

i am new to using excell and my accountant has created a spead sheet for me ,
i was wondering can i set up a page so that the information i enter is done
on its own page and then put in the speadsheet behind the scenes

a bit like entering you contact details then it creates a address book
 
Hi,
Sure you can , you will need to be more specific on what you want to do, an
example will help
 
barry said:
i am new to using excell and my accountant has created a spead sheet for me
,
i was wondering can i set up a page so that the information i enter is
done
on its own page and then put in the speadsheet behind the scenes

a bit like entering you contact details then it creates a address book
Click to expand...

Yes you can and it is something I would recommend. It's good to separate
user data from the 'main' part of the spreadsheet. That way if a user
inputs inaccurate information whilst it will go through to the 'main' part
it can be corrected. On the other hand allowing a user to the mechanics
(formulae) of the spreadsheet could spell disaster.

Have a look at my web site www.1001solutions.co.uk and, in particular,
"Designing a spreadsheet" for more information.

Bill R
 
Back
Top