Hi
So I have some data in column B in one sheet that is labelled "Jan 2011.txt" and I am looking to copy it into column A of a sheet named "Jan 2011 Data". I have this for quite a few sheets/months, was wondering how in VBA it is written that we take the 'Jan 2011' and then add the 'Data', so that can be used in a bigger macro that goes through a few of these sorts of sheets? Basically the naming!
Cheers
So I have some data in column B in one sheet that is labelled "Jan 2011.txt" and I am looking to copy it into column A of a sheet named "Jan 2011 Data". I have this for quite a few sheets/months, was wondering how in VBA it is written that we take the 'Jan 2011' and then add the 'Data', so that can be used in a bigger macro that goes through a few of these sorts of sheets? Basically the naming!
Cheers