Ok so I have one more for you. I need to have a calculation formula within
that formula you just provided. For example, I need to take B50/A50, but
still need it to look at the last cell with data. Basically I need to ensure
every time I update the "Data" tab, the "Summary" tab is always updated with
the last entry from the "Data" tab.

Thoughts? Thanks again.

"SMH" wrote:

OH WOW!! Thank you so much! I really appreciate it! :)

"BoniM" wrote:

=LOOKUP(99^99,Sheet1!A:A)

Where Sheet1 is the name of the sheet containing data in column A - will
return the last value in the column.

"SMH" wrote:

Within one workbook, I'm trying to have one tab read off another using a
formula. I need the "Summary" tab to display the last cell with data (not
null) in a particular column. For example, column A has data populated from
A2:A50, I want to show A50. Any suggestions?