Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Extend series using ref cell formula transposed
I need to extend a fill series using ref's from sheet 2.
Sheet 1 info needs to fill "down" the rows.. and the info it's referencing is "across the columns" How do I extend the fill series to run : A1 B1 C1 etc.. ?? Losing all my hair over this and wha'ts left of it is going Grey!!.. If it was only 1 worksheet I wouldn't bother to fill.. yet sheet 1 will be a master of info for 120 indiviual sheets... Any help would be appreciated Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding a formula in a cell but when cell = 0 cell is blank | Excel Worksheet Functions | |||
numbers being entered show in formula bar but not in cell? | Excel Discussion (Misc queries) | |||
Percent and Rank formula in one cell | Excel Discussion (Misc queries) | |||
looking for a formula | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |