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

[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

 

[Eduardo]

Hi,
Sure you can , you will need to be more specific on what you want to do, an
example will help

 

[Bill R]

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

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

 

[John McCabe]

I setup one with cash columns and account columns. The total of each column
feeds the Trial Balance and that feed the P&L - Balance sheet.
NO need to go over the P&L or B.S. -all transactions are fed from the
transactions journal.