B
brettopp
I need to display the text from a single cell in a fixed column range, but
the location of the cell with text in it varies. The fixed column range I
have is P2540000. This column range will either be completely blank, or
will have a single cell within the range that will contain text (could be
cell P48 one time, cell P2705 the next, cell P30 the next, etc.). If there
is a cell with text in it somewhere in column range P2540000, I want to be
able to display that cell's text in cell Y5.
Any ideas?
the location of the cell with text in it varies. The fixed column range I
have is P2540000. This column range will either be completely blank, or
will have a single cell within the range that will contain text (could be
cell P48 one time, cell P2705 the next, cell P30 the next, etc.). If there
is a cell with text in it somewhere in column range P2540000, I want to be
able to display that cell's text in cell Y5.
Any ideas?