View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
John McCabe John McCabe is offline
external usenet poster
 
Posts: 18
Default can i input info in excell one page at a time instead of seeing .

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.
"Bill R" wrote in message
...
"barry" wrote in message
...
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