Newbie Help. Is this possible?

**taltos1** · 11-09-2005, 04:03 PM

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.

Anne Troy · 11-09-2005, 06:00 PM

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/...soft_excel.htm
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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

**taltos1** · 11-10-2005, 02:31 PM

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

Anne Troy · 11-10-2005, 04:55 PM

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

**taltos1** · 11-10-2005, 05:30 PM

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