how to get latest input on an seperate worksheet
 

I have a workbook with multiple spreadsheets and I would like to make a page
with all the latest inputs combined from the other sheets. How can I get
excel to determine which is the latest input in a formula to import to the
summary sheet automatically, or is it even possible

Dean

how to get latest input on an seperate worksheet
 

There is nothing you can access that defines the last formula to calculate
on a sheet.

So I guess people would need to know more about what you mean by the latest
inputs. Is this something someone enters in the worksheet? Do they do it
in a specific cell, or is it the last cell in a column perhaps?

--
Regards,
Tom Ogilvy


"Dean Comer" <Dean wrote in message
...
I have a workbook with multiple spreadsheets and I would like to make a
page
with all the latest inputs combined from the other sheets. How can I get
excel to determine which is the latest input in a formula to import to the
summary sheet automatically, or is it even possible

Dean

how to get latest input on an seperate worksheet
 

I would be looking for the last input in a column

"Tom Ogilvy" wrote:

There is nothing you can access that defines the last formula to calculate
on a sheet.

So I guess people would need to know more about what you mean by the latest
inputs. Is this something someone enters in the worksheet? Do they do it
in a specific cell, or is it the last cell in a column perhaps?

--
Regards,
Tom Ogilvy


"Dean Comer" <Dean wrote in message
...
I have a workbook with multiple spreadsheets and I would like to make a
page
with all the latest inputs combined from the other sheets. How can I get
excel to determine which is the latest input in a formula to import to the
summary sheet automatically, or is it even possible

Dean

how to get latest input on an seperate worksheet
 

Dean,

Is the 'last input' always going to be the last cell in the same column
on any given sheet?

You may simply need to create a dynamic Name on each sheet to name this
last cell and then refer to these names with formulas on your summary
sheet.

NickH