Getting Info from Last cell used
I put this an another newsgroup and did not get a reply so thought I would
try here. Currently I am adding many sheets together. I am using "Start Sheet" and "End Sheet" and everything in between those two sheets is adding for a total. I would (in a few cells) to just get the data from the last cell used. Example: The sheets I am adding are dates and if sheet 01-19-09 (dd-mm-yy) has the last entry in cell c18 I would like that number. However there may be blank cell before that sheet. and after that sheet there will be info in other cells. I would like that info to go into c18 of the sheet I use and named "Totals". -- Thank You in Advance Ed Davis |
Getting Info from Last cell used
hi
I would (in a few cells) to just get the data from the last cell used. so far as i know, excel does not record the last cell used much less the last cell used on multiple sheets. you would have to define what constitutes the last cell used and design from there. if you cannot define what constitutes the last cell used then i think your quest may be...uh....difficult. regards FSt1 "Ed Davis" wrote: I put this an another newsgroup and did not get a reply so thought I would try here. Currently I am adding many sheets together. I am using "Start Sheet" and "End Sheet" and everything in between those two sheets is adding for a total. I would (in a few cells) to just get the data from the last cell used. Example: The sheets I am adding are dates and if sheet 01-19-09 (dd-mm-yy) has the last entry in cell c18 I would like that number. However there may be blank cell before that sheet. and after that sheet there will be info in other cells. I would like that info to go into c18 of the sheet I use and named "Totals". -- Thank You in Advance Ed Davis |
All times are GMT +1. The time now is 03:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com