Previous Topic Next Topic

Excel problem

Closed
bob - Mar 6, 2012 at 10:21 AM
venkat1926 Posts 1863 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
Related:

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses