Drowned in the ocean of Excel Spreadsheets

The extensive use of Excel which is now very powerful has made some people
almost drowned in it. Very large worksheets being established and linked to
each other. When I tried to take over spreadsheets of my fellow employee
during his being hospitalized, I almost give up. Figures and formulas
scattered all across the pages and it is difficult to know where to start
from.
I'm thinking about pooling Data input totally in one sheet, pooling all the
calculations in another sheet and displaying all the reports in other sheet.
Does any body have the experience on such arrangement? Thanks
SUNAN

Hi Sunantoro,

> I'm thinking about pooling Data input totally in one sheet, pooling all the
> calculations in another sheet and displaying all the reports in other sheet.
> Does any body have the experience on such arrangement?

Sounds like the way to go.
It is an arrangement I favour.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

You might even think of separating the data and the logic into separate
workbooks.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jan Karel Pieterse" <[email protected]> wrote in message
news:[email protected]...
> Hi Sunantoro,
>
> > I'm thinking about pooling Data input totally in one sheet, pooling all
the
> > calculations in another sheet and displaying all the reports in other
sheet.
> > Does any body have the experience on such arrangement?
>
> Sounds like the way to go.
> It is an arrangement I favour.
>
> Regards,
>
> Jan Karel Pieterse
> Excel MVP
> http://www.jkp-ads.com
>