Line Automation

  • Thread starter Lenora via OfficeKB.com
  • Start date
L

Lenora via OfficeKB.com

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?
 
R

rgarber50

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

Richard
 
L

Lenora via OfficeKB.com

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.
Could you describe in more detail what's on each worksheet by row and
column?

Richard
I am using Excel 2000.
Click to expand...
[quoted text clipped - 11 lines]
Is there a way to have the monthly spreadsheet automatically move down
a line?
Click to expand...
Click to expand...
 
R

rgarber50

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
 
L

Lenora B via OfficeKB.com

thank you for the assistance. I'll give it a try.
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
Form is set-up like a table
Click to expand...
[quoted text clipped - 27 lines]
Click to expand...
 
Top