copy paste hyperlinks in diff worksheets

V

Venkateswaran SA

hi all,
I have a hyperlink in excel in one of the colums of a worksheet
I have 50 other worksheets.
i want to paste the test and hyperlink together in one go, in all the work
sheets in the same position
copy paste after selecting all the sheets, only copies the text

any solution for this. Urgent... Please help


--
=-=-=-=-=-=-=-=-=-=-=-=-
Thanks and Regards
Venkat SA

M: 973 - 3978 2493
R: 973 - 17 2345 17
E: [email protected]
=-=-=-=-=-=-=-=-=-=-=-=-
 
D

davesexcel

When I grouped the sheets and typed in the Hyperlink Formula like this:
=HYPERLINK("#A1","Go Here")
It did work for each sheet, this takes you to A1 and has the text Go
Here
 
Top