Can I have info on first tab transferred to subsequent tabs?

[Guest]

I have a worksheet with 5 tabs - 1 is a yearly overview, ie Jan - Dec. The
next 4 are quarterly tabs, therefore Jan - Mar, Apr - June etc. Can I put
data onto the first tab and have it appear in the correct cell on the
relevent quarter tab?
New to excel, would appreciate any help, thanks!

 

[Don Guillett]

Sure, just select the tabs desired and then enter on one to automatically go
to all.

 

[Bernie Deitrick]

Jaime,

If you mean, can you enter all your data into the overview, and have it
automatically entered onto the appropriate quarterly sheets, then no.

The best way to do this is to not use 5 sheets, but use a single sheet.
Insert an extra column, with the heading "Quarter". When you enter your
data, enter the appropriate quarter number into this column. Then, when you
want to see first quarter results, simply filter your data set using Data |
Filter... Autofilter, and select the "1" from the drop down at the top of
that column. Or use the data set to produce a pivot table, which can do all
sorts of wonderful things.

In general, you only want information to appear in one place in your
workbook - otherwise, changes and checking become problematic.

HTH,
Bernie
MS Excel MVP

 

[Guest]

=Sheet1!$a$1
This entered in a cell on any other sheet will display the value in Sheet
1-Cell A1
If you change the value in Sheet1, the cell with this formula will change
accordingly.
Vaya con Dios,
Chuck, CABGx3