Good day friends,

I am creating an excel sheet to document our PAT testing.

What I need is the ability to go from, for example:

A101-01-01

A101-01-02

A101-01-03

A101-01-04

then

A101-02-01

A101-02-02

A101-02-03

A101-02-04

etc etc without having to type EVERY single one.

Can any of you big brains/experts help?

Many thanks in advance,

Paul

​Good day friends, I am creating an excel sheet to document our PAT testing.What I need is the ability to go from, for example:A101-01-01A101-01-02A101-01-03A101-01-04thenA101-02-01A101-02-02A101-02-03A101-02-04 etc etc without having to type EVERY single one.Can any of you big brains/experts help?Many thanks in advance,Paul  Read More

​