Transpose between worksheets

[Laurie]

Thank you for your help. I am not a experienced user of excel andI have a question.

I want to transpose a row to a column between worksheets, while maintaining the link. How do I do this?

Thank you.

Laurie

 

[maxflia10]

http://www.asap-utilities.com

has a transposes data function and which keeps formulas. Under Range.

Always forgetting the .com
This message was edited by maxflia10 on 2002-10-28 16:16

 

[Laurie]

Thank you, but I can't find the command range. Can you be more specific?

Laurie

 

[maxflia10]

Laurie,

Highlight the range you want tranposed, go to ASAP Utilities and Range/Transpose data with formulas, enter, then in the window that appears, enter the first cell where you want the data to be transposed to.

don't forget to add the worksheet name i.e. sheet1!a1
This message was edited by maxflia10 on 2002-10-28 18:04

 

[Laurie]

Where and when do I add the sheet name?

Laurie