Hello All , I have taken interest in excel VBA recently and am trying to learn and apply some optimizations to my daily excel workflow sheets.

I have an excel sheet where there are unique references for each transaction i record. I record all the transactions for the day then the next day i clear those transactions and pull up the new unused unique references to start my day.

I feel there is a macros where to automate this mundane task.

Appreciate the support and thank you.

Example Below
Excelforum example.png