S
sparky3883
Hi all.
I'm having a wee problem and was wondering if any one out there coul
please help me.
I have created a sheet in Excel which contains 8 columns.
Column A contains peoples names and the other seven columns contain
time.
What i am hoping to do, is transfer peoples names and the times for th
column selected onto another sheet that i have created.
So, for example, if i select column C, all the people who have a tim
in that coulmn will be transfered onto the other sheet.
Basically, it is for a rota system for my work. The 'weekly' rota shee
contains my staff and the times and days that they are working thi
week. The other sheet is a 'daily' rota sheet and i only want the name
and times of the peope who are working on that day to be shown on thi
sheet
I have thought about using the SELECT INTO statement, but i a
struggling to make it happen. I have attached my 'rotas' so you ca
have a loook if it helps.
Any help/info would be much appreciated
Thanks in advanc
Attachment filename: weekly.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=50728
I'm having a wee problem and was wondering if any one out there coul
please help me.
I have created a sheet in Excel which contains 8 columns.
Column A contains peoples names and the other seven columns contain
time.
What i am hoping to do, is transfer peoples names and the times for th
column selected onto another sheet that i have created.
So, for example, if i select column C, all the people who have a tim
in that coulmn will be transfered onto the other sheet.
Basically, it is for a rota system for my work. The 'weekly' rota shee
contains my staff and the times and days that they are working thi
week. The other sheet is a 'daily' rota sheet and i only want the name
and times of the peope who are working on that day to be shown on thi
sheet
I have thought about using the SELECT INTO statement, but i a
struggling to make it happen. I have attached my 'rotas' so you ca
have a loook if it helps.
Any help/info would be much appreciated
Thanks in advanc
Attachment filename: weekly.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=50728