Newbie Help. Is this possible?

T

taltos1

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

Thanks so much
 
A

Anne Troy

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/indirect_to_switch_worksheets_in_microsoft_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
 
T

taltos1

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

Thanks a lo
 
A

Anne Troy

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
 
T

taltos1

I just read it again and I think I understand it better now, thanks.
now have my 7 worksheets done with the various floorcharts. Now I nee
to figure out how to tie that into the server schedule which is
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 usin
the data from the schedule by ordering the servers in at the earlie
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 lo
 
Top