Need help on Excel macro [Closed]

Report
-
Posts
2368
Registration date
Sunday September 23, 2012
Status
Moderator
Last seen
December 13, 2018
-
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

Posts
2368
Registration date
Sunday September 23, 2012
Status
Moderator
Last seen
December 13, 2018
19
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!