Row Reference by Page Number and Alphabetical Order.

[nitrammada]

Hi Folks,
I'm looking for assistance for line referencing and would appreciate any help given. Each row of data in my report requires a row reference in this format
1/A for row 1 and
1/B for row 2 and so on. 1 being the page number and "A" being the first alphabetical reference for the first row.

So for page 2 I need the row reference to start again at "A" but for page 2 the reference needs to looke like
2/A
2/B
etc
If there are more than 26 rows 2/AA, 2/AB is fine.

I have been trying to use VBA to reference the page count using the HPageBreaks with the pgbr.Location command but it's a bit beyond me to be honest.
If any one can assist with some vba code, I would be most grateful.
Thanks in advance.

Below is what I'm trying to achieve, I hope this makes sense.

 

[Marc L]

​

Thanks ! Easy just using some Excel basics like here a beginner level formula …​