Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Latest Taxation Books available at jain book depot LATEST BOOKRELEASES | Excel Worksheet Functions | |||
How do I have seperate headers for seperate pages in 1 worksheet? | Excel Discussion (Misc queries) | |||
Fill a seperate cell with info depending on the input in another c | Excel Discussion (Misc queries) | |||
show latest date input only | Excel Discussion (Misc queries) | |||
Cut and Paste to A Seperate Worksheet | Excel Programming |