OK, I've checked out both approaches described here. They both show some promise.
But the filtering method I don't think will serve my purpose. It's nice but the owner wants a record of every day/week even if I don't do any work on certain days. So there are going to be blank rows at least in the copy for him. He wants to see everything to get an idea of how I'm using my time.
And I've tried the method put forth by Usasma only to find that it's pretty much the same thing as copy and paste. IE., it doesn't work like a "Formula" where when I enter data on the "Monthly" sheet (after setting up the "Formula" on a template) then the data automatically gets copied to the weekly sheets from the Monthly sheet.
I'm looking more for a "Formula" that permanently reduces my work load. I just make a template and wallah when I keep track of my hours on the monthly sheet the data gets duplicated automatically to the weekly sheets. Also, I need and would like it if I change data on the monthly sheet then it automatically updates on the weekly sheets.
I already know that I can copy and paste.
Oh, I also would like to do the same thing with the "descriptions" - what I write up to describe what I did during the hours worked that I include on my work sheets.
That would be when I write up the descriptions on the monthly sheet then it gets duplicated automatically onto the weekly sheets.
Of course if I'm doing something wrong please do Enlighten me.
Here is the "formula"? that I've ended up using to duplicate what Usasma advised me to try: "='[Nov 2007]Nov 2007'!F13" (without the quotes).
1. "Nov 2007" is the monthly sheet that I'm copying data from and "Week 1" is the first weekly sheet that I'm copying the data too.
2. "Weekly 1" is conspicuously absent in the formula however the data does transfer when setting this "formula"? up in "Weekly 1".
3. However, the data will not update automatically on the weekly sheet when I change it on the monthly sheet. i need/want it to update automatically.
The question then is this the right formula: "='[Nov 2007]Nov 2007'!F13"? ("F13" being the column and row of the data being duplicated).
Does that help?