Richard_mcr
New Member
- Joined
- Oct 19, 2023
- Messages
- 8
- Office Version
- 2019
- Platform
- Windows
Hi All,
I'm building a calculation worksheet which involves inserting copied rows. I have what I imagine is an easy problem that I'm making difficult!
Senario:
Rows 1 to 5 are related to one set of data with a sequential letter reference. Each time I insert a new set, I copy and inset a defined additional 5 rows and the next alphabet letter; therefore I result in simple terms with:
A = Row 1 to 5
B = Row 6 to 10
C = Row 11 to 15
Etc...
At the moment, I have a validation on the letter cell and manually change the to the next letter.
Requirement:
Once the new 5 rows are inserted at the end of the data, I want to look at the cell with the letter in the previous set and select the next letter in the alphabet. The letter cell in each set is currently the second row, column B.
If anyone could point me in the right direction, I'd very much appreciate it!
I'm building a calculation worksheet which involves inserting copied rows. I have what I imagine is an easy problem that I'm making difficult!
Senario:
Rows 1 to 5 are related to one set of data with a sequential letter reference. Each time I insert a new set, I copy and inset a defined additional 5 rows and the next alphabet letter; therefore I result in simple terms with:
A = Row 1 to 5
B = Row 6 to 10
C = Row 11 to 15
Etc...
At the moment, I have a validation on the letter cell and manually change the to the next letter.
Requirement:
Once the new 5 rows are inserted at the end of the data, I want to look at the cell with the letter in the previous set and select the next letter in the alphabet. The letter cell in each set is currently the second row, column B.
If anyone could point me in the right direction, I'd very much appreciate it!