Sam Longstaff
Member
Hi,
I have a need to collate an number of dates that appear in set areas of one worksheet (worksheet name SL) into a list without any gaps. The list that is generated will be used to update an outlook calendar at a later date. I have managed to use array formulas to gather the dates from the set areas within worksheet SL in to a list in worksheet named SL calendar. To do this has taken a few steps as you will be able to see.
I wonder if using VBA would be a better way to do this? I don't have the excel skills to be able to construct this though so I would be very pleased if someone was able to help out with this. Also my example shows only one person's working pattern that is to be collated in to a list for a calendar. It would be my intention to replicate this for all staff members. Each staff member has their own worksheet. I'm pretty clueless on how to construct the code so that it loops through all the sheets I would need it to.
Many thanks in advance.
I have a need to collate an number of dates that appear in set areas of one worksheet (worksheet name SL) into a list without any gaps. The list that is generated will be used to update an outlook calendar at a later date. I have managed to use array formulas to gather the dates from the set areas within worksheet SL in to a list in worksheet named SL calendar. To do this has taken a few steps as you will be able to see.
I wonder if using VBA would be a better way to do this? I don't have the excel skills to be able to construct this though so I would be very pleased if someone was able to help out with this. Also my example shows only one person's working pattern that is to be collated in to a list for a calendar. It would be my intention to replicate this for all staff members. Each staff member has their own worksheet. I'm pretty clueless on how to construct the code so that it loops through all the sheets I would need it to.
Many thanks in advance.