ashleyuk1984
12-12-2014, 03:37 AM
Hi,
I'm sure there are loads of ways to do this, but I think the fastest way would be to use an array, and sorting through the list, and storing only unique values in the array.
I have a list of references on sheet1, in column A.
The references look something like this:
RE11111
RE22222
RE33333
AD11111
AD22222
OE11111
ME11111
ME11111
I need to create/rename the sheets, using the first 3 characters of the reference (Starting from Sheet 2 (renaming Sheet1 as RAW DATA))
Sheet2 would be called RE1
Sheet3 would be called AD1
Sheet4 would need to be added, and called OE1
Sheet5 would need to be added, and called ME1
At the moment, I can't really use a static list of references within the code, as the references in the list change from time to time, and new ones are being added.
So I need to look into creating a more dynamic method.
I haven't learnt arrays before, so this might be a good starting point for me.
Thank You
I'm sure there are loads of ways to do this, but I think the fastest way would be to use an array, and sorting through the list, and storing only unique values in the array.
I have a list of references on sheet1, in column A.
The references look something like this:
RE11111
RE22222
RE33333
AD11111
AD22222
OE11111
ME11111
ME11111
I need to create/rename the sheets, using the first 3 characters of the reference (Starting from Sheet 2 (renaming Sheet1 as RAW DATA))
Sheet2 would be called RE1
Sheet3 would be called AD1
Sheet4 would need to be added, and called OE1
Sheet5 would need to be added, and called ME1
At the moment, I can't really use a static list of references within the code, as the references in the list change from time to time, and new ones are being added.
So I need to look into creating a more dynamic method.
I haven't learnt arrays before, so this might be a good starting point for me.
Thank You