Excel problem

Closed
bob - Mar 6, 2012 at 10:21 AM
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
- Mar 6, 2012 at 10:14 PM
Hi

I have a slight problem with excel. I have inputted all my data with links on the same worksheet. Now I am trying to separate the different categories into different worksheets. when i tried, all the links became broken. Does anyone know how to do it without re-typing all the links?

Regards and thanks
Bob

1 reply

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
805
Mar 6, 2012 at 10:14 PM
"I am trying to separate the different categories into different worksheets."

do you do it in a macro

if you use
.pastespecial
add

.pastespecial paste:=xlpasteall

try this
0