I am creating a Accounts Receivable workbook. I have a worksheet for
each client. On the first sheet of the workbook, I have created a
hyperlink to each client's records. I want to list the balance on the
main sheet as well. This requires the last cell with a value in the
Column (F, in this case) to be displayed, because each client has a
running total. Please help me with the formula to achieve these
results. Thank you in advance for any assistance.

Assuming XL version prior to 2007, try:
=LOOKUP(2,1/(F1:F65535<""),F1:F65535)

Doesn't work for an entire column, so if you have data in cell F65536, will
need to find a different solution.

" wrote:

I am creating a Accounts Receivable workbook. I have a worksheet for
each client. On the first sheet of the workbook, I have created a
hyperlink to each client's records. I want to list the balance on the
main sheet as well. This requires the last cell with a value in the
Column (F, in this case) to be displayed, because each client has a
running total. Please help me with the formula to achieve these
results. Thank you in advance for any assistance.

Assuming that there are no gaps in the data...

=INDEX(A1:A5000,COUNT(A1:A5000),1)

Start at the first cell if not A1, likewise adjust A5000 to somewhat
past the last cell with data.

If the client were on sheet2 try:

=LOOKUP(9E+99,Sheet2!F:F)

If you already have a list of sheet names from the hyperlinks in column
A you could fill down:

="=LOOKUP(9E+99,'"&A:A&"'!F:F)"

Then select the column copy and paste values and choose Text to Columns
Finish to evaluate.

wrote:

I am creating a Accounts Receivable workbook. I have a worksheet for
each client. On the first sheet of the workbook, I have created a
hyperlink to each client's records. I want to list the balance on the
main sheet as well. This requires the last cell with a value in the
Column (F, in this case) to be displayed, because each client has a
running total. Please help me with the formula to achieve these
results. Thank you in advance for any assistance.

Try this:
=LOOKUP(9.99999999999999+307,F:F)


" wrote:

I am creating a Accounts Receivable workbook. I have a worksheet for
each client. On the first sheet of the workbook, I have created a
hyperlink to each client's records. I want to list the balance on the
main sheet as well. This requires the last cell with a value in the
Column (F, in this case) to be displayed, because each client has a
running total. Please help me with the formula to achieve these
results. Thank you in advance for any assistance.

Thank you so much! It was exactly what I needed :-)


Lori wrote:
If the client were on sheet2 try:

=LOOKUP(9E+99,Sheet2!F:F)

If you already have a list of sheet names from the hyperlinks in column
A you could fill down:

="=LOOKUP(9E+99,'"&A:A&"'!F:F)"

Then select the column copy and paste values and choose Text to Columns
Finish to evaluate.

wrote:

I am creating a Accounts Receivable workbook. I have a worksheet for
each client. On the first sheet of the workbook, I have created a
hyperlink to each client's records. I want to list the balance on the
main sheet as well. This requires the last cell with a value in the
Column (F, in this case) to be displayed, because each client has a
running total. Please help me with the formula to achieve these
results. Thank you in advance for any assistance.

Glad it helped - thanks for the reply! Lori

wrote:

Thank you so much! It was exactly what I needed :-)


Lori wrote:
If the client were on sheet2 try:

=LOOKUP(9E+99,Sheet2!F:F)

If you already have a list of sheet names from the hyperlinks in column
A you could fill down:

="=LOOKUP(9E+99,'"&A:A&"'!F:F)"

Then select the column copy and paste values and choose Text to Columns
Finish to evaluate.

wrote:

I am creating a Accounts Receivable workbook. I have a worksheet for
each client. On the first sheet of the workbook, I have created a
hyperlink to each client's records. I want to list the balance on the
main sheet as well. This requires the last cell with a value in the
Column (F, in this case) to be displayed, because each client has a
running total. Please help me with the formula to achieve these
results. Thank you in advance for any assistance.