Nick has attended:
Access Introduction course
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
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
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
Richard
I 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
