nitrammada
Board Regular
- Joined
- Oct 10, 2018
- Messages
- 78
- Office Version
- 365
- Platform
- Windows
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.
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.