Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

transpose paste

0

Hi all,

Is there any VBA code can help to copy and paste with my attached file ,

The "start" sheet is what i have and the "results" sheet is what i want to get

Thank you very much !

Mark 

Answer
Discuss

Answers

0
Selected Answer

Just Perfect !!!

Thank you so much!!!!

Mark

Discuss

Discussion

Don't forget to click the Select Answer button for the answer by Variatus!
don (rep: 1989) Aug 21, '18 at 3:09 pm
Add to Discussion
0

The task appeared straight forward. So I programmed it for you. Run the procedure CreateValueList in the attached workbook. However, before you do I suggest you read the comments I wrote into the code.

Discuss

Discussion

I'm glad the code I wrote plesed you. Submitting your comment to that effect as an "Answer" wasn't quite the right thing to do, and noting that you didn't accept my answer (thereby awarding points) leaves me disappointed. This doesn't look like a fair exchange to me.
Variatus (rep: 4889) Aug 22, '18 at 4:49 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login