I have made a sheet on which i have assigned several hyperlink which are linked with the cells present on that sheet only.
Now i uses a vba code which enable that excel file to create new sheet on the basis of current date. Now when this new sheet is formed the hyperlinks which i have assigned in the source sheet don't appear in the new sheet infact they get connected with the source sheet.
How i can make excel do this that when a new sheet is created the hyper link also adjust them selves from the previous sheet to the new sheet so that when we click on some hyperlink it take us to the desired cell on the same sheet not on the previous sheet.
Now i uses a vba code which enable that excel file to create new sheet on the basis of current date. Now when this new sheet is formed the hyperlinks which i have assigned in the source sheet don't appear in the new sheet infact they get connected with the source sheet.
How i can make excel do this that when a new sheet is created the hyper link also adjust them selves from the previous sheet to the new sheet so that when we click on some hyperlink it take us to the desired cell on the same sheet not on the previous sheet.