Copy and Past

[Guest]

I have a cell that refernces data in another worksheet. Example:
=5.61*'(12-05)'!$D$30. I want to copy and paste this cell and have the
worksheet it references, (12-05) increment to (1-06). Is this possible?

 

[raypayette]

Yes.
Create a Custom format: mm-yy by clicking Format, Cells, Custom,...
Select a range on a sheet and format it with that custom format.
You will be able to create a series with it and you can use VBA to
create new workbooks using the series of names.