MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

dynamic column length need last cell value

  Asked By: STEPHEN    Date: Jan 28    Category: MS Office    Views: 1133


I am working on a problem in an Excel sheet. I have a column of data that is dynamic. It changes lengths based upon the amount of data input.
I am needing the value of teh last number input in that column.

For example, one time I will have 32 data inputs in colum A rows 1-32, and need the last value cell A32 to be copied into cell C1.

The next time I will have 12 data inputs again in column A from 1-12, and need the value from A12 copied into cell C1.

I am not sure if there is a formula I can use or if i need to use a VB macros.

Thanks in advance for all the assistance.



No Answers Found. Be the First, To Post Answer.

Didn't find what you were looking for? Find more on dynamic column length need last cell value Or get search suggestion and latest updates.