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.

1 reply

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