So I am having trouble determining what code to use to past value. The situations is as follows:
On Sheet1 I have a list of names in column A, as well as a list of how many times I need to copy and past the name in column B.
Example: A1= John, B1=15
A2= Larry, B2= 23
A3= Bob, B3= 55
A4= Jeff, B4= 18
What I need is to copy John's name 15 time, Larry's 23, Bob's 55, and Jeff's 18. Then have those names past in Sheet2 column J their respected number of time.
Example End Result: J1-15 will have John's name
J16-38 will have Larry's name and so on...
The values in column B will change on a daily basis.