Reference number in excel

Closed
ghel - 5 May 2010 à 02:13
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 5 May 2010 à 06:01
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?

Thanks,
Ghe

Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
5 May 2010 à 06:01
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.