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