Hi,
I would like to know a way in which I can link data from rows on one sheet to another sheet into columns. Basically, transposing the data however I need them to be linked (instead of copy and paste) so the reader knows the source of the data. I would prefer a formula than a Macro as the file is already large.
Thanks in advance guys!
Hello,
The only formulas come to my mind are ROW, COLUMN and ADDRESS if you want to do this without using macro / transpose from paste special.
If possible, can you provide a small sample file?
(copy pasta from Ford)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
Regards,
Lem
Pl see the attached file.
There's also the =TRANSPOSE() function http://office.microsoft.com/en-us/ex...833.aspx?CTT=1
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks