I manage a nightclub and want to create a sales tracking chart per
server. This is easy if all servers occupied the same cells on every
worksheet. However, corporate insists that the daily sales report be
designed around stations. Therefore, my servers rotate from station to
station on a daily basis. I know i could always make a seperate
worksheet designed around the servers and input the server totals a
second time onto that worksheet but i was hoping of finding someway of
linking a second worksheet that totals up the sales per server as i
enter them into the daily sales report (the one designed around
stations).

Any ideas??


--
DIXIEDH
------------------------------------------------------------------------
DIXIEDH's Profile: http://www.excelforum.com/member.php...o&userid=24553
View this thread: http://www.excelforum.com/showthread...hreadid=381471