Hi again

I've tried the copy & paste method but the hyperlinks just refer back to the worksheet from which the copy was made.

Their must be a way to have hyperlinks within a worksheet that link to various point within that worksheet & then when that worksheet is copied & pasted the hyperlinks will link to the new worksheet?

Otherwise each time I do this I have to edit each hyperlink pointing it to the current worksheet?

Any advice?