In one worksheet, how do I refer to the first unoccupied cell in a column in another worksheet?
S Stan Katz Sep 14, 2004 #1 In one worksheet, how do I refer to the first unoccupied cell in a column in another worksheet?
P Peo Sjoblom Sep 14, 2004 #2 Stan said: In one worksheet, how do I refer to the first unoccupied cell in a column in another worksheet? Click to expand... =CELL("address",INDEX(Sheet2!A1:A2000,MATCH(TRUE,Sheet2!A1:A2000="",0))) entered with ctrl + shift & enter will return the address to the first empty cell Peo Sjoblom\ \ (No private emails please, for everyone's\ benefit keep the discussion in the newsgroup/forum)\
Stan said: In one worksheet, how do I refer to the first unoccupied cell in a column in another worksheet? Click to expand... =CELL("address",INDEX(Sheet2!A1:A2000,MATCH(TRUE,Sheet2!A1:A2000="",0))) entered with ctrl + shift & enter will return the address to the first empty cell Peo Sjoblom\ \ (No private emails please, for everyone's\ benefit keep the discussion in the newsgroup/forum)\
