I created three spreadsheets using Excel 2000: (1) Lunch Weekly Summary, (2)
Breakfast Weekly Summary and (3) Deposit Reports -- these forms are linked
together via columns to eliminate redundent tying with numbers changing
weekly.

I need to create another form (Monthly Income Summary) based on the Lunch
or Breakfast Weekly Summary Forms with headings of Date, Number of
Participants, Number of Staff/Guest, Number of Foodandlers, Participants
Contribution, Staff, Guest Contribution, Foodhandler Contribution, total
and grand total columns.

I need to create an Income Summary Report Form with 30/31 rows and 8
columns having the same headings as the Lunch/Breakfast Forms. My problem
is having the Income Summary Report automatically move down one row/column
when the next weeks dates are typed into the Lunch or Breakfast Summary
Form. How can this be accomplished?

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