Excel problem [Closed]

Question

Excel problem [Closed]

Report

bob - Mar 6, 2012 at 10:21 AM
venkat1926

Posts: 1862
Registration date: Sunday June 14, 2009
Status: Contributor
Last seen: July 30, 2015

- 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

Ask a question

venkat1926 · Answer 1 · 2012-03-06T22:14:15-0500

Answer 1 / 1

venkat1926

Posts: 1862
Registration date: Sunday June 14, 2009
Status: Contributor
Last seen: July 30, 2015

797
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

Excel problem [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!