Hello!
I have two sheets in a workbook, Sheet1 is for summary with reference number (reference number is alpha-numeric), Sheet2 is the raw data. Is there a way to make the referencing automatic everytime I have data added in Sheet1?
Could you further explain with example. If explanation is bit complicated then also could you please upload a sample file with sample data etc on some shared site like https://authentification.site and post back here the link to allow better understanding of how it is now and how you foresee.