Excel worksheet - Can I make changes in one sheet affect contents of other sheet?

[lcrawford]

I can already tell this is going to be difficult to explain. Perhaps
I'm asking in the wrong place or even asking too much from a program,
but here goes:

In short I'm doing this what I consider "the hard way" because that's
how the brass here wants it done. I have an excel file that is simply
a chart with 10 columns and about 100 rows at any given time. This
file is to keep track of meetings that my team attends. Going across
the top, the columns are labeled with date, time, meeting title,
location and things such as that. Each row is a different meeting kept
in chronological order. I add new meetings as they are scheduled and
paste old or cancelled meetings into another worksheet with a new tab
and the same columns set up. Each day I print the calendar (one page,
landscape) for the week we are in removing the meetings that we have
already attended that week.

I would like to set up a third sheet as a "rolling" calendar that would
be less detailed than the first sheet in that it would have less
columns and a more narrow row width. For this sheet I would need only
date, time, meeting title and location. I imagine this fitting on one
page portrait style.

Is there a way that I can make page one copy to this page 3 and
automatically update it as I change the contents of page 1?

Thanks!

 

[Guest]

Assuming that all the data is in static locations on the first sheet you can
set up formulae on the new sheet so that for example cell A1 is =Sheet1!A1
and so on

This means that as you update in the first sheet the new sheet automatically
shows the same data
HTH - Sheila
www-c-i-m-s.com
MS Office training - London

 

[lcrawford]

So, in short, I'll have to format each cell of the rolling calendar
with a formula which corresponds to the appropriate cell of the
original meeting calendar? Or is there some other way to do this?

 

[Guest]

There's always another way but I tried to answer the question you asked! You
could just hide the columns you don't want to see and print it like that...
really depends what your main objective is which is the best way to do it
Sheila
www.c-i-m-s.com
MS Office training - London