M
MDBJ
I had a huge spreadsheet that I assembled by the end of the summer.
at one point, it pulled data from one worksheet to the next using an
INDIRECT combined with ROW()
now- at the end of the summer, I'm re-writing it- but for display purposes,
I find it works better vertically where before it was horizontal.
I'm stuck, I know where..
before, my indirect("sheetname!"&$A1&ROW()) worked fine if A1 had a letter
so I might get an address of "sheetname!d1"
now, my indirect("sheetname!"&colum()&a$1) fails-- as column() returns a
number not letter...
now I get an address of "sheetname!14"
where the first '1' of the 14 should be the letter a-followed by row 4
get this? am I splaining it well?
how might I get "from this same column" into indirect as a letter?
at one point, it pulled data from one worksheet to the next using an
INDIRECT combined with ROW()
now- at the end of the summer, I'm re-writing it- but for display purposes,
I find it works better vertically where before it was horizontal.
I'm stuck, I know where..
before, my indirect("sheetname!"&$A1&ROW()) worked fine if A1 had a letter
so I might get an address of "sheetname!d1"
now, my indirect("sheetname!"&colum()&a$1) fails-- as column() returns a
number not letter...
now I get an address of "sheetname!14"
where the first '1' of the 14 should be the letter a-followed by row 4
get this? am I splaining it well?
how might I get "from this same column" into indirect as a letter?