Thread: Schedule table
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pedro Costa[_3_] Pedro Costa[_3_] is offline
external usenet poster
 
Posts: 12
Default Schedule table

Hi, is there a way to make this table in VBA?

Mon Tue Wed Thu Fri
A 1 2 3 4 5
B 2 1 5 3 4
C 3 4 1 5 2
D 4 5 2 1 3
E 5 3 4 2 1

What i need is a table with 5 schedules that can never repeat for one person
(A, B, C, D or E) in the week.
There are only 5 schedules in every day that should be distributed for the 5
persons

Thanks