Copy a Formula from a Column to a Row

[Jon]

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 !!!

 

[Bob I]

use $
as in $C5

 

[Sheeloo]

This will not work...

1. Enter C5, D5, E5 and so on upto AG5 in a column, say Col A, of time sheet
[(assuming duty sheet is named Sheet1]
then enter the formula against the first timesheet cell (D5?)
=Indirect("'Sheet1!"&A1) and copy down