Copying last entry in column
Closed
lisa dawn
-
Jun 28, 2010 at 09:15 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 28, 2010 at 12:23 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 28, 2010 at 12:23 PM
Hello,
I would like to know it there is a way to copy the last entry in a column that moves down on a daily basis with new entries imputed.
For example, today my last entry might be on a6, but tomorrow it will be on a9. I want to be able to automatically copy that value(date entry) thru a forumula that will put it in a designated column on a different worksheet. I do not want to have to change the formula on the destination worksheet daily to reflect the new cell, i want excel to look for the last value in the column and do it automatically.
Is that even possible?
I would like to know it there is a way to copy the last entry in a column that moves down on a daily basis with new entries imputed.
For example, today my last entry might be on a6, but tomorrow it will be on a9. I want to be able to automatically copy that value(date entry) thru a forumula that will put it in a designated column on a different worksheet. I do not want to have to change the formula on the destination worksheet daily to reflect the new cell, i want excel to look for the last value in the column and do it automatically.
Is that even possible?
Related:
- Copying last entry in column
- Protect pdf from copying - Guide
- Nokia.mobi/entry/van/main/c7-00 - Phones, PDA & GPS Forum
- Missing or invalid registry/ini entry need for speed most wanted - Video Games Forum
- N8-00 - Nokia Forum
- How to delete column in word - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 28, 2010 at 12:23 PM
Jun 28, 2010 at 12:23 PM
What kind of values would be on that column, numbers ? only text or alpha numeric ?