Thread: Line Automation
View Single Post
  #3   Report Post  
Lenora via OfficeKB.com
 
Posts: n/a
Default

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