| 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 !!! |
| 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)
Threaded Mode
