Did you check the link? It explains how to use the indirect function. Each
day, you'd just enter, for instance, into cell A1, the number of servers
required. So, it's 4. So it looks at worksheet 4 'cause you use the Indirect
function to get it.
************
Anne Troy
www.OfficeArticles.com

"taltos1" wrote in
message ...

OK, so if I understand correctly, there would be a total of 7 worksheets
(for servers 4-10) and then 1 MAIN worksheet that is the first one? How
would the indirect function work with calling forth the correct
worksheet number?

Thanks a lot


--
taltos1
------------------------------------------------------------------------
taltos1's Profile:
http://www.excelforum.com/member.php...o&userid=28684
View this thread: http://www.excelforum.com/showthread...hreadid=483647