Linking to Consecutive Cells is it possible?

[Tom]

I want to link a cell in a worksheet to a data set in
another workshhet that will be updated monthly. The update
in the data worksheet will be entered in the next adjacent
cell (ie. Jan data point will be in B12, when entering Feb
data point it will be in B13 and so on). I want the cell
in the non data worksheet to update sequentially so that
when I enter Feb, the cell will automatically update to
that cell and when I enter March in B14, it will update to
that cell. Is this possible? For further explanation if
needed please e-mail me. Thanks.

 

[Harlan Grove]

I want to link a cell in a worksheet to a data set in
another workshhet that will be updated monthly. The update
in the data worksheet will be entered in the next adjacent
cell (ie. Jan data point will be in B12, when entering Feb
data point it will be in B13 and so on). I want the cell
in the non data worksheet to update sequentially so that
when I enter Feb, the cell will automatically update to
that cell and when I enter March in B14, it will update to
that cell. Is this possible? For further explanation if
needed please e-mail me. Thanks.

If the cells for months yet to come would be blank (and I mean truly blank as in
no contents whatsoever, so not containing a single quote or ="" or a space
character ot two), and if Jan through Dec would be in B12:B23, and if the data
entered would be numeric, then the formula

=LOOKUP(9.99999999999999E+307,DataSheet!B12:B23)

would return the value for the most recent month with an entry.