Y
yorkeyite
Hi
I have a workbook that each sheet tab needs to be named the after a
particular date in its worksheet. This is so that the contents can be
imported into a database as they are updated. The dates have to be
presented "yyyymmdd" with no dividers. Obviously it is a
representation of a date and not the real thing. I am always getting
errors because currently the sheets are being named manually with many
mistakes. The sheet name comes from an actual date in cell E5
I have some vba to do it, but it is clumsy, using year month and day
functions combined with conditional statements to allow for single
figure months and days. It takes up many lines.
Has anybody got anything neat and tidy?
I have a workbook that each sheet tab needs to be named the after a
particular date in its worksheet. This is so that the contents can be
imported into a database as they are updated. The dates have to be
presented "yyyymmdd" with no dividers. Obviously it is a
representation of a date and not the real thing. I am always getting
errors because currently the sheets are being named manually with many
mistakes. The sheet name comes from an actual date in cell E5
I have some vba to do it, but it is clumsy, using year month and day
functions combined with conditional statements to allow for single
figure months and days. It takes up many lines.
Has anybody got anything neat and tidy?