Hi all, the problem ...in a column I may have a user enter a receipt
number which is incremental so day 1 seperate sheet may have no
receipts and day two (seperate sheet) may have 3 receipts. I want to be
able to pull out the last receipt number from the column for auditing.

Day 1
column a column b column c

day 1 nothing
so use the last receipt number on other worksheet
Day 2
5555



5556

receipt 5556 will be placed as last receipt number day 2 on other
worksheet.

Hope you can help