Hey there, I currently have a loop set up where a column in my sheet is updated with a track record number of the following format:
Row A
ALP1
ALP2
ALP3 and so on....
but what I would like to do is make it so that it appears as below:
Row A
ALP0001
ALP0002
'
'
ALP1023 and so on...
my sub I use to do this is of the form below:
How would I go about changing the output so that it would show as above??Please Login or Register to view this content.
Any help would be greatly appreciated.
Cheers!
Jag
Bookmarks