Good points, Earl. I agree, it's much easier to update and manipulate data
if it's only in one place!

Doug

"Earl Kiosterud" wrote in message
...
Doria,

Another, and non-macro, solution would be to put the month in some common
sheet containing a named cell, like "Month". Then in the various month
sheets, refer to that name, =Month. You'd want to protect that cell to
keep
users from typing into it.

Having similar data in separate sheets precludes the use of a lot of
terrific Excel functionality. I'll include my standard blurb on the
subject:

There's a lot of Excel functionality that isn't available when similar
data
is spread across multiple sheets, as well as across workbooks. Questions
abound where users already have data in separate sheets, and now want to
find certain data, summarize the data, etc. and there are no direct means
to
do that.

If the layout of the data in the sheets will be the same (same column
headings), it is generally best to put all the data in a single sheet,
with
an additional column for what originally was the various sheets. For
example, if you have a sheet for each month, put all the data in a single
sheet, with an additional column for month. An Autofilter can easily
reduce this consolidated sheet to the equivalent of one of the original
(month) sheets. Now you can sort in various useful ways, use Data -
Subtotals, easily make a pivot table to summarize the data, use database
functions (DSUM, COUNTIF, etc.).

If the separate sheets already exist, it's a straightforward one-time
project to combine them. Just make a sheet with the extra (month) column.
Now paste the records from the first sheet, and enter Jan into the month
column and copy down with the fill handle or copy/paste. Repeat for the
other sheets.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Doria/Warris" wrote in message
...
Hi,

I finally managed to create an arcaic mechanism that enables me to input
a
number from1 to 12 (months) in a specific cell and get the YTD results.

I have now another, hopefully, simpler issue to solve.
The worksheets have the same format, the cell is B4 in all of them, how
do
I
get the number I input to appear on all the sheets contemporaneously?

For instance, I enter 6 in sheet1 to see the June YTD results, what I'd
like
to see is also sheet2, sheet3 etc, to switch to 6, regardless from which
sheet the input occurs.

I hope the question is clear enough

Thank you
Alex