LinkBack URL
About LinkBacks
I have one list
List A
Suppose list A has 5 items.I want to regenerate same list in transpose form and want it to be dynamic.That is if i change number of items to 7,it reflects in transposed list.
Thanks for help
I have one list
List A
Suppose list A has 5 items.I want to regenerate same list in transpose form and want it to be dynamic.That is if i change number of items to 7,it reflects in transposed list.
Thanks for help
You dont show any sample data, nor expected outcome, but you could probably do this with INDEX/MATCH/MATCH
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
3. Click on the star if you think someone helped you
Regards
Ford
Possible with a "Private Sub" macro
Right click on the tab for the sheet you to transpose the values in. Then click "View Code" and paste this code in the new window that opens. This macro will run every time a new value is entered in column A.
Alf
Please Login or Register to view this content.
I have attached sample file.
"D12"Formula:
Please Login or Register to view this content.
Copy Paste across.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks