Reference number in excel

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

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
May 5, 2010 at 06:01 AM
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.
0