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

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

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

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

I just read it again and I think I understand it better now, thanks. I
now have my 7 worksheets done with the various floorcharts. Now I need
to figure out how to tie that into the server schedule which is a
seperate excel file. So I think a few questions arise:
1. Is it possible to pull data from a seperate excel file?
2. I would like to floorchart to get filled in automatically by using
the data from the schedule by ordering the servers in at the earlier
time at the bottom then work its way up. IE. section 7 in at 4:00PM,
section 6 in at 4:30, etc...

Any and all help is very appreaciated!!

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

Still trying to find a solution to this...Anyone.. Thanks!


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