LinkBack URL
About LinkBacks
Hello
I am trying to get excel to copy a row into a column eg cells A1:H1 to be linked to M4:M10.
I am wondering if there is a quick formula that can be used for this as i have several hundred cells to do.
Any help is much appreciated.
Thanks
K
Hello
I am trying to get excel to copy a row into a column eg cells A1:H1 to be linked to M4:M10.
I am wondering if there is a quick formula that can be used for this as i have several hundred cells to do.
Any help is much appreciated.
Thanks
K
try
=index($A$1:$H$1,,row($A1))
then drag down
Last edited by twiggywales; 10-11-2012 at 08:25 AM.
The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
<--- If a post helps hit the star
Hi Kello,
Try entering =TRANSPOSE($A$1:$H$1) as an array formula. Highlight all the cells you want the formula in. Paste it in and then press Ctrl + Shift + Enter.
Regards
Danny
What do you mean by link? Do you mean that whatever data is in A1 for example should show up in M4 and so on for the other cells?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
i got it working thanks and sorry for the delay in getting back to you's
Thanks again
Kello
glad to have helped dont forget to mark it solved and star tap the helpers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks