Sheet 1- include labels to set out information to be included.

Sheet 2- this depends on the job in hand. When you think you've done this
put some dummy data in Sheet 1 and make sure the results are absolutely
accurate. You could also try breaking it by loading Sheet 1 with some silly
data. It's called idiot proofing but this is only as good as far as is
tested and idiots can do things you have not tested for. I like to colour
code cells containing formula as a reminder that the information is computed
not actual and that it shouldn't be touched. (This is OK if it isn't to be
printed). You could also hide the whole sheet (at least from someone who
doesn't know how to unhide it).

Sheet 3- again this depends on the job in hand.

Regards.

Bill Ridgeway
Computer Solutions

"Serge" wrote in message
...
can you provide a sample formula?

"Serge" wrote:

Hello Bill,
I could not have put it better myself in your explanation. I thought
your
first paragraph had lot of humor to it, but very important to remember.

As you put it I have an 'input sheet' (sheet 1), a calculation sheet
(which
is invisible) and an output sheet (sheet 2).

What is the stradigy to achieve what I want to accomplish?

Thanks

Serge

"Bill Ridgeway" wrote:

I am sometimes sceptical when I hear the question "How do you do?" in
terms
of function rather than objective. It suggests that the questioner is
asking about the bus stop for a particular service rather than checking
if
the bus goes to his destination. A question in terms of how do I do
this is
likely to elicit help only on that topic. A question in terms of how
do I
get to the end point may just elicit a way of doing achieving what is
required in a way which the questioner may not have thought of.

OK. So now we know a bit about what you are trying to do we can try to
help
you. In my experience of designing spread sheets it is sometimes best
to
have an 'input sheet', sometimes a 'calculation sheet' and an 'output
sheet'. The 'input sheet' would be the only area in which users should
be
changing data. The 'calculation sheet' would be the area in which the
inputs are combined to produce the output data. The 'output sheet'
would be
an area which contains tables and graphs for printing. Obviously this
is
only a design template to be adapted to needs.

I hope that something along these lines may be the answer to your
query.

Regards.

Bill Ridgeway
Computer Solutions

"Serge" wrote in message
...
Hello again Bill,

I'm trying to come up with a way to eliminate user input on sheet 2.
That
sheet 2 will summerize the content of sheet 1 automatically. Someone
told
me
I would need to learn Visual Basic to achive this. Is that true?
Serge

"Bill Ridgeway" wrote:

Whether you push or pull data it comes to the same thing. I'm
intrigued
by
why you want to push data instead of pull data.

Regards.

Bill Ridgeway
Computer Solutions

"Serge" wrote in message
...
Thanks for your reply Bill,
Would there be a way to memic this? Make it look like what you say
"push
data".

"Bill Ridgeway" wrote:

No! You can pull data but you can't push data.

Regards.

Bill Ridgeway
Computer Solutions

"Serge" wrote in message
...
On sheet 1 I have multiple entries with three specific
critereas in
each
rows.
On sheet 2 there are 6 areas that require user input in each of
the
6
areas
in order to sum up quantities that meet the tree specific
critereas.
Is there a method of automatically sending data from sheet 1 to
sheet 2
&
keeping count & adding as sheet 1 populates?
Thank you in advance.
Serge