Transpose automatically using Macros,
Dear all,
I am having some data of Training which day to day need transpose as soon as i update data, kindly help me to get some transpose of row to columns automatically.
Kindly help to Transpose row to columns as I need to get individual record, My requirement is when i select any name Table should appear showing no. of training attended (Topic name) another column with respective Hours.
The merged cell at DU1:DV1 was removed and replaced with two separate text cells.
SUMMARY sheet was added. Choose a name in the yellow cell and the classes they've taken will appear with the hours.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks a lot for your quick reply it helped a lot.
Can you help me soome more. can you add one column more in Summary which shows date of Training.
In short when we select name one column shows date of training, second shows Training topic, Third column shows Hours and finally Sum of Total hours just near the name.
Thanks
Hansheel Shah
Like so:
You can view this code by right-clicking on the SUMMARY sheet tab and selecting VIEW CODE.
Please Login or Register to view this content.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks