J
Joseph
Hi all,
I need serious help with this. I have a staff break rota on sheet1 that
is updated from a couple of userforms full of tickboxes. What I need to
do now in sheet two is some kind of table that updates in sheet2 as the
range in sheet1 is updated. I have a feeling its some kind of lookup,
but Im not sure, are lookups dynamic, and is this the solution I need?
So what I would end up with:
Sheet1: A row of times with user names appearing underneath as they
select 10 minute (ie 8:30-8:40, 8:40-8:50 etc)timeslots on the userform
(I've got this bit).
Sheet2: A row of 9 slots containing selected breaks and a column of
names, both to update as sheet1 is filled in. (This data will change on
a daily basis. I also need to 'UnUpdate' if the user removes themself
from the table in sheet1. (The userform has a button for this).
I've been scratching my head over this for ages now and am about ready
to commit hare kare and give up. Help!
Thanks in advance
I need serious help with this. I have a staff break rota on sheet1 that
is updated from a couple of userforms full of tickboxes. What I need to
do now in sheet two is some kind of table that updates in sheet2 as the
range in sheet1 is updated. I have a feeling its some kind of lookup,
but Im not sure, are lookups dynamic, and is this the solution I need?
So what I would end up with:
Sheet1: A row of times with user names appearing underneath as they
select 10 minute (ie 8:30-8:40, 8:40-8:50 etc)timeslots on the userform
(I've got this bit).
Sheet2: A row of 9 slots containing selected breaks and a column of
names, both to update as sheet1 is filled in. (This data will change on
a daily basis. I also need to 'UnUpdate' if the user removes themself
from the table in sheet1. (The userform has a button for this).
I've been scratching my head over this for ages now and am about ready
to commit hare kare and give up. Help!
Thanks in advance