T
Tiesthatbind
Hello the board, please forgive me if this subject has been posed
elsewhere.
How do I create a formula to read data from eg. G70:AR70 Sheet 1, to
Column G5 Sheet 2 and drag down to as many cells needed ?
one way I have tried is =INDIRECT(ADDRESS(70,7)) , which works on Sheet
1 and transposes and reads perfectly, however I am unfamilar with how to
put this formula onto Sheet 2, reading from Sheet one, and then it
doesn't drag down the column (reading across the Sheet1 row70). any
help from the very knowledgable members is appreciated!
elsewhere.
How do I create a formula to read data from eg. G70:AR70 Sheet 1, to
Column G5 Sheet 2 and drag down to as many cells needed ?
one way I have tried is =INDIRECT(ADDRESS(70,7)) , which works on Sheet
1 and transposes and reads perfectly, however I am unfamilar with how to
put this formula onto Sheet 2, reading from Sheet one, and then it
doesn't drag down the column (reading across the Sheet1 row70). any
help from the very knowledgable members is appreciated!