Instead of using two worksheets, just put your data on a single worksheet. You
can add a column that represents the week.

Then by applying data|Filter|autofilter, you'll be able to see any week you
want.

And by keeping the data in one location, you'll find that you can do many more
things with it--including pivottables, charts. And you won't have to worry
about the data getting out of sync.

Gizelle wrote:

I am working on creating cashflows for my company. I have a monthly
spreadsheet and a weeekly spreadsheet. What i need to know is 'Is it possible
to have a tab for monthly and weekly with tabs inside both for the months of
the year?'
As i need the monthly pages to update from the weekly pages, i assume they
need to be within the same workbook?

--

Dave Peterson