Auto Populate Cell When Data Is Entered In Another Cell

[houndogs]

Hi,

Thank you for taking the time to look at my question.

I am helping my wife create a spreadsheet for her workplace. What I am trying to do is make the reference number column auto fill with a incrementing number each time a date is entered in the date column. I have attached the document so it will make sense when you see it.

When a date is entered into B10 I would like A10 to show the reference number TNC16/1. When the date is entered into B11 I would like A11 to autofill with TNC16/2 and so on down the spreadsheet. The spreadsheet also needs to be infinite.

Any help would be very much appreciated.

Many thanks,
David

[alansidman]

Here is a VBA solution

Please Login or Register  to view this content.

Copy the above code. Open the VBE (Alt +F11). In the left window, click on the worksheet indicated as Sheet1. The right window will appear. Paste the code into that window. Save and close the VBE. Save the file as an .xlsm (macro enabled). Save the workbook. When you open the workbook, this macro will be enabled. When you add dates to the Column B, it will automatically update column A.

[houndogs]

Hi Alan,

Thank you so much for your help. Your instructions were incredibly clear. You are extremely knowledgeable and I'm very grateful to you.

Best Regards,
David