Good Morning Bill,

It's 8 am in the Pacific North West.

Thank you so much for your comments.
Serge

"Bill Ridgeway" wrote:

The best strategy is to have all sheets in a single workbook - as far as
possible.

You can, of course, have information 'pulled in' from another workbook by
reference to the cell. However, if the source cell is moved say, by a
change in the structure of the spreadsheet, the target is moved and you can
get some rather strange results. The main disadvantage is that everyone
either (sort of) trusts the computer or doesn't see a wayward figure and
bases a business critical decision on the outcome. This is especially so
when the incorrect data may be only marginally adrift. This can be overcome
by naming the target cell (<Insert<Name) and referring to the name rather
than the cell. This will not work if the target workbook is moved or
deleted.

So, unless there is a very good business reason (or paranoia) it would be as
well to have all the spreadsheets together in a single workbook.

Hope that helps.

Regards.

Bill Ridgeway
Computer Solutions

"Serge" wrote in message
...
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