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