Hi, I am copying / pasting data from another source to my excel sheet…That I can do it manually no problem.
Now I would like to transpose that data and paste say sheet2..That can also done manually, but the challenge is I need to copy and transpose only the cells in the rightmost ( containing data)…its like 40 files and I need to convert one excel sheet . Please see the attached sample testing data. The DATA tab is the data I am copying one file from these 40 files. And RESULT tab shows the desires result of each file ( I only did the first file, bu the second file goes to row 2 and s on). If I can get this on help ..Really appreciated. Jimmy. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
testing data.xls
Description: MS-Excel spreadsheet
