Cell and Sheet references
I am not too familiar with scripts in Office However I'd like to do the
following:
I have a workbook with 1 sheet for each employee.
I'd like to check (cell A40) for the shift they are on (A,B,C or D) IF A
shift display their name (Cell B2) On the sheet titled A-Shift with the
following info (cells C42,D42,E42)
Move to the next sheet and check the next employee
Ideally I will end up with 4 sheets with a list of employees on each shift.
I know it will be a loop or and an if then statement or two but I have no
VBscript skills
thanks,
wingnut258
|