I have a table on sheet 1.
For what I want to happen I don't know if I have to use a makro (don't know how to use makros) or can I use some other functions.
What I want to happen is:
When I write 0001-2011 in colum 1 (cell A2 - example) I want when I hit enter a new sheet is made in this workbook named 0001-2011 and in the colum (cell - A2) I wrote 0001-2011 I want it to be a hiperlink to this sheet.
Later on there will be like 250 Sheets named like 0001-2011, 0002-2011 and so on...
And I also have a table that I want to be automated on this new sheet.
Is this even possible?
Idias, please
Denis
Bookmarks