I have an excel table where users will enter data in columns A3 -> D3. Column E is hidden and contains a simple formula of =row(). Essentially to generate an ID number for each entry. So if they enter data in A3->D3, the formula in E3 is row(D3), which will return the number 3.

Since it's in excel table format, as the user enters more entries, it will expand to include the formula in column E.

What I want to do, in column F, is copy the value generated in E. So if a user enters 10 entries starting from A3 to D12, the formula in column E will generate values of 3 through 10, and what I want is a VBA (on worksheet change) that will auto copy the values of 3 through 10 and paste them in column F, starting from F3 through F12 (adjacent to the formula in column E).

I expect users to input data over a wide range; anywhere from 50 entries up to 2000 entries. Can someone help with this?