| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy a Formula from a Column to a Row
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 !!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy a Formula from a Column to a Row
use $
as in $C5 Jon wrote: 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 !!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy a Formula from a Column to a Row
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 "Bob I" wrote: use $ as in $C5 Jon wrote: 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 !!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COPY FORMULA DOWN A COLUMN | Excel Discussion (Misc queries) | |||
| copy formula down a column and have cell references change within formula | New Users to Excel | |||
| How do I copy a formula all the way down a column........ | Excel Worksheet Functions | |||
| copy a formula within a row from a column on another worksheet | Excel Worksheet Functions | |||
| Copy a formula down a column | Excel Worksheet Functions | |||
![Jon[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
