I am using Excel 2000.

I have created spreadsheets named Lunch and Breakfast.that has 5 rows and 6
columns.
These sheets are updated weekly (data input: 8/1 - 8/ 5 on separate lines
with $ collected etc.)

I need to create a monthly spreadsheet that will result in a monthly report
for each spreadsheet identified above.

Is there a way to have the monthly spreadsheet automatically move down a line?



--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200508/1

Could you describe in more detail what's on each worksheet by row and
column?

Richard

Lenora via OfficeKB.com Wrote:
I am using Excel 2000.

I have created spreadsheets named Lunch and Breakfast.that has 5 rows
and 6
columns.
These sheets are updated weekly (data input: 8/1 - 8/ 5 on separate
lines
with $ collected etc.)

I need to create a monthly spreadsheet that will result in a monthly
report
for each spreadsheet identified above.

Is there a way to have the monthly spreadsheet automatically move down
a line?



--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200508/1


--
rgarber50
------------------------------------------------------------------------
rgarber50's Profile: http://www.excelforum.com/member.php...o&userid=11350
View this thread: http://www.excelforum.com/showthread...hreadid=393505

Form is set-up like a table

Al = Date B1=No. of Participants C1=No of Staff/Guest D1=No of
Foodhandler E1=Participants Contribution F1=Staff/Guest Contribution
G1=Foodhandler Contribution

A2=Space to put date (i.e. 8/1/05) B2= insert a number (i.e. 7) C2=Same
as B2. D2=Same as B2. E2=Insert $ amount. F2 & G2 same as E2.

Repeat until you have completed a weeks input ending with 8/5/05. Then total
all colums down and across.

The next weeks input will be: 8/8 - 8/12, 8/15 - 8/20, 8/23 - 8/27 etc. until
you reach the end of the month.

rgarber50 wrote:
Could you describe in more detail what's on each worksheet by row and
column?

Richard

Lenora via OfficeKB.com Wrote:
I am using Excel 2000.

[quoted text clipped - 11 lines]
Is there a way to have the monthly spreadsheet automatically move down
a line?



--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200508/1

Lenore
I am not one of the Excel gurus but I would try using the excel
subtotal feature.
First I would add a column to the left of A1 that was titled something
like week #. Then I would use the one worksheet for the whole month.
Each date gets the particular week#.
Select the whole list including headers
From the Excel menu - Data - subtotal
At each change in: Week#
be sure to check off each field you want to have subtotaled.

You'll see the outline symbol to the left that will allow you to hide
or show whatever detail you want. You can then format your outline as
you want.

Check out the excel help on subtotals - and Exceltip.com in the excel
tips section has a good number of hints.

Hope this helps.
Richard





Lenora via OfficeKB.com Wrote:
Form is set-up like a table

Al = Date B1=No. of Participants C1=No of Staff/Guest D1=No of
Foodhandler E1=Participants Contribution F1=Staff/Guest Contribution
G1=Foodhandler Contribution

A2=Space to put date (i.e. 8/1/05) B2= insert a number (i.e. 7)
C2=Same
as B2. D2=Same as B2. E2=Insert $ amount. F2 & G2 same as E2.

Repeat until you have completed a weeks input ending with 8/5/05. Then
total
all colums down and across.

The next weeks input will be: 8/8 - 8/12, 8/15 - 8/20, 8/23 - 8/27 etc.
until
you reach the end of the month.

rgarber50 wrote:
Could you describe in more detail what's on each worksheet by row and
column?

Richard

Lenora via OfficeKB.com Wrote:
I am using Excel 2000.

d text clipped - 11 lines Wrote:

Is there a way to have the monthly spreadsheet automatically move
down
a line?



--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/ms-excel/200508/1


--
rgarber50
------------------------------------------------------------------------
rgarber50's Profile: http://www.excelforum.com/member.php...o&userid=11350
View this thread: http://www.excelforum.com/showthread...hreadid=393505

thank you for the assistance. I'll give it a try.

rgarber50 wrote:
Lenore
I am not one of the Excel gurus but I would try using the excel
subtotal feature.
First I would add a column to the left of A1 that was titled something
like week #. Then I would use the one worksheet for the whole month.
Each date gets the particular week#.
Select the whole list including headers
From the Excel menu - Data - subtotal
At each change in: Week#
be sure to check off each field you want to have subtotaled.

You'll see the outline symbol to the left that will allow you to hide
or show whatever detail you want. You can then format your outline as
you want.

Check out the excel help on subtotals - and Exceltip.com in the excel
tips section has a good number of hints.

Hope this helps.
Richard

Lenora via OfficeKB.com Wrote:
Form is set-up like a table

[quoted text clipped - 27 lines]
down
a line?



--
Message posted via http://www.officekb.com