I should have added that the column I want the last cell from is regularly
added to...so I want the LAST cell added each time to show in a cell on the
other worksheet.

"Bundy" wrote:

I would like to be able to transfer the value from the LAST used cell in a
column in one worksheet into a cell on a different worksheet..is this
possible?
Thanks