Hi hi,

I'm working on a Duty Schedule and a Time Sheet in the same WorkBook just on
different sheets. The Duty is horizontal c5:ag5 but the TimeSheet is Vertical
c5:c35. The TimeSheet referees to Duty Schedule cell. ( When Duty is changed
the TimeSheet changes automatically). Is there a way to copy a horizontal
line vertical so that the Letter changes but the Number stays the same ?? Or
do I just have do enter everything by hand in?

Thanks !!!