Hi All,
Just getting into Macros etc.
Can anyone provide me with a macro or tell me if it's possible to do this..
If I have a sheet called 'Look' with a series of six digit numbers in column A is there a macro that I can run that will create a new sheet for each value in column A and rename it accordingly? Presumably the length of column A shall not go over 20 as I believe that this is the maximum number of sheets that Excel shall allow?
Any ideas one and all would be greatly appreciated!
Thanks,
Paul
Just getting into Macros etc.
Can anyone provide me with a macro or tell me if it's possible to do this..
If I have a sheet called 'Look' with a series of six digit numbers in column A is there a macro that I can run that will create a new sheet for each value in column A and rename it accordingly? Presumably the length of column A shall not go over 20 as I believe that this is the maximum number of sheets that Excel shall allow?
Any ideas one and all would be greatly appreciated!
Thanks,
Paul