About Us

Lori

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.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I combine spreadsheets and documents in one file?	Trish	Excel Discussion (Misc queries)	3	November 9th 06 09:17 PM
macro	unouwanme	Excel Discussion (Misc queries)	9	August 31st 06 09:38 PM
Return SEARCHED Column Number of Numeric Label and Value	Sam via OfficeKB.com	Excel Worksheet Functions	23	January 30th 06 06:16 PM
creating a bar graph	Johnfli	Excel Discussion (Misc queries)	0	October 26th 05 08:16 PM
Possible Lookup Table	Karen	Excel Worksheet Functions	5	June 8th 05 09:43 PM