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 810
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