Prev: Can I automatically hide a column with zero values in Excel
Next: cell is blank then dont count range
From: gramps on 4 Jul 2008 12:44
This maybe quite simple but I seem to be getting into quite a state.

I have a workbook comprising of 2 worksheets;-
#1 – “roster”
#2 - “myrota”
The first compiles a roster for the 16 man department for the coming week
and is compiled automatically on entering the w/c date using a VLookup list.

What I want to do on “myrota” is to enable any member of the department to
enter their name which gets looked up in the “roster” and get a list of their
duties for the next 16 weeks.

I'm not sure whether I have given all the information you need to help but
any assistance would be greatly appreciated.

 | 
Pages: 1
Prev: Can I automatically hide a column with zero values in Excel
Next: cell is blank then dont count range