| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
copying formulas from worksheet to worksheet
I need to copy a row of cells from one worksheet to a column of another
worksheet. I want it to reference the cells listed in the row of one worksheet to the column of the other worksheet. I found out how to do the reverse - =offset('worksheet name'!$a$1,0,row(1:1)-1) - but it doesn't work for copying rows to columns? Can you help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel 2002 - copying formulas to another worksheet | Excel Discussion (Misc queries) | |||
| Replicating Formulas with Various Worksheet References | Excel Worksheet Functions | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
| Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
| hyperlinks and copying a worksheet | Excel Worksheet Functions | |||
Threaded Mode
