Need help on Excel macro

Closed
Vaibhav - Apr 6, 2017 at 08:25 PM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Apr 8, 2017 at 05:33 AM
I need help to create a macro which helps me to get data from 'Sheet1' and paste that number of counts in 'Sheet2'

for example, i have a table in sheet1

Count------name
20----------ABCD
40----------EFGH
11----------IJKL

i need to paste '20 values for name 'ABCD' in 'sheet2' also i want to insert one blank row between each name change.

Please help me on this.
Related:

1 response

Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Apr 8, 2017 at 05:33 AM
Helo Vaibhav,

If your Excel File doesn't contain any personal or sensitive data please feel free to share the file on this link:

http://www.tinyupload.com/index.php

Once you have uploaded the file you can share the link for the uploaded file with me and I will look into it to solve your problem.
0