copy paste hyperlinks in diff worksheets

  • Thread starter Thread starter Venkateswaran SA
  • Start date Start date
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: (e-mail address removed)
=-=-=-=-=-=-=-=-=-=-=-=-
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hyperlinks 2
I copied Visible Cells Only, but it pastes only the first cell 1
Copy hyperlinks 6
Copying hyperlink in excel 1
Table of contents with hyperlinks to worksheets, plus "home" hyperlink 2
Copy certain rows to new worksheet 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Activating hyperlinks 3

Back
Top