Copy and Past

J

Joe

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?
 
R

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.
 
Top