Excel problem

Closed
bob - 6 Mar 2012 à 10:21
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 6 Mar 2012 à 22:14
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
Related:

1 response

venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
6 Mar 2012 à 22:14
"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