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?
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?
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.
Best regards,
Ray
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks