thanks for replying I appreciate it
I have a certain schedule that is used for a certain period
my whole aim is i dont want to do it manually
rather have this done automated or using vba
I will have a look again but it looks like I am going to do it manually