Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel Training and help » excel training seminar - Transpose - link
|
|
|
Bookmark this page|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
excel training seminar - Transpose - link
Resolved · Low Priority · Version Standard
Reply
Transpose - link
Hi
I am trying to "link" a list of values in a column into a row . I need to keep the link "live" so the copy / paste-transpose is not what I need.
I have 100's of values in the column and this will be an extremely arduous manual task manually linking the column values into the row. Is there an automated way of doing this??
Cheers
NICK
For upcoming training course dates see: Pricing & availability
RE: Transpose - link
Hi Nick,Are you trying to do this in Excel?
Is it a hyperlink you are wanting to copy?
are you able to link the cell using the = sign?
Regards
Richard
RE: Transpose - link
RichardYes, trying to do this in Excel and trying to link the cells with the "=" sign - trying to link a vertical data series (column) into a horizontal data series (row)
Cheers
Nick
RE: Transpose - link
Nick,I have simulated your question, and it seems that when I used the Transpose option, the links stayed live.
They were external links (ie . www.google.com)
You mention that you do not need to use transpose, so I am i bit confused. Do you want the link to be live from the original cell and the copied cell?
Richard
RE: Transpose - link
RichardI think the word "link" is confusiung us here.
I am not referrring to hyperlinks - I am simply trying to establish a row of data (numbers) from a column of data (numbers). I can not however use the copy-paste transpose function as that only allows you to transpose 'values'
E.g. I want to recreate (link) the data in cells A1, B1, C1, D1, E1 ...... into B3, C3, C4, C5, C6......... using the "=" sign. I have hunders of rows of data so doing this manually will be a very time consuming task - is there a way of automating this function in excel??
What I need resolved should have a very simple solution, it is however difficult to explain - Is there a facility to attach a spreadhseet so that i can show you what I mean??
Cheers
NICK
RE: Transpose - link
Thanks Nick,I think I get waht you are saying. Have had the same question come up for me in the past, but do not remember is I actually managed to solve it. Willing to give it a bash.
Send your file to info @ microsofttraining . net and we can take a look.
Richard
|
 |
|
» Forum post: Graph intersect |
I need to find the point where 2 lines on a line graph intersect. I've found the "Intercept" function but this only gives a y axis intercept.
