Off the top of my head (someone could have a much better idea), I would name
my worksheets 4 through 10. Then I would use Indirect to get the data from
those worksheets onto my main worksheet.
http://www.officearticles.com/excel/...ft_excel.h tm
So, you could have the same layout on all sheets, but the home worksheet
would use Indirect formulas in its layout. and you just put the number of
servers in A1 (which also corresponds to the sheet name).
************
Anne Troy
www.OfficeArticles.com

"taltos1" wrote in
message ...

Hello,
I am just getting into Excel and would like some help very much. I am
basically trying to make a spreadsheet for a restuarant that would
specify how many servers would be the floor and their sidework and that
ties into the server schedule. Problem is that different nights have a
different number of servers on. So my question is? Do I need to make a
spreadsheet for all the varients of servers (say 4-10 servers) or is
there some way I can input a number like 6 and the spreadsheet will
modify itself automatically?

Thanks so much.


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