Repeat a cell value in another column X number of times

[art1234]

I am trying to get a macro to repeat to the next record and produce more data.
I will explain

I don’t know VB so I found a macro and changed a few values to get it to work for me but it won’t repeat.
Basically all I want the macro to do is take a number or letter that I put in column A and paste it in column C as many times as I told it in column B.
And the go back to A2 and repeat the process and pasting that results under the previous.

IE in A1 A2 A3 are the values 5, B1, 777
In B1 is the value 3
When the macro is executed the results in column C would be
5 in c1, c2 and c3 - b1 on c4,c5, and so on
I have the macro working for record 1 but that’s all it will do
The finished data could be put on a separate sheet if that helps
Also, as I said I copied the macro off the web and don’t know VB so there may well be commands that are not necessary.
Thanks much in advance. Macro below.

Please Login or Register  to view this content.

[Leith Ross]

Hello art1234,

Welcome to the Forum!

If you have an example workbook, you should post it. It will make clear what you want to do and provide a reference for creating the VBA code. This will ensure you get the right solution for your problem.

[art1234]

file now attached

I am trying to get a macro to repeat to the next record and produce more data.
I will explain

I don’t know VB so I found a macro and changed a few values to get it to work for me but it won’t repeat.
Basically all I want the macro to do is take a number or letter that I put in column A and paste it in column C as many times as I told it in column B.
And the go back to A2 and repeat the process and pasting that results under the previous.

IE in A1 A2 A3 are the values 5, B1, 777
In B1 is the value 3
When the macro is executed the results in column C would be
5,5,5,B1,B1,B1,777,777,777
I have the macro working for record 1 but that’s all it will do
The finished data could be put on a separate sheet if that helps
Also, as I said I copied the macro off the web and don’t know VB so there may well be commands that are not necessary.
Thanks much in advance. Macro below.

Please Login or Register  to view this content.

[Leith Ross]

Hello art1234,

Thanks for posting the workbook.

Does cell C1 contain all the values: 5,5,5,B1,B1,B1,777,777,777 ?

Does C1 = 5,5,5 and C2 = B1,B1,B1 etc?

[royUK]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST

And please do not quote whole posts

[art1234]

trying to create a string of data in one column "C" -
C1 would be 5 C2 would be 5 C3 would be 5 C4 would be B1

Hello art1234,

Thanks for posting the workbook.

Does cell C1 contain all the values: 5,5,5,B1,B1,B1,777,777,777 ?

Does C1 = 5,5,5 and C2 = B1,B1,B1 etc?

[teylyn]

Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore Moderators' or Administrators' requests - note that this includes requests by senior members as well, if you are unclear about their request or instruction then send a private message to them asking for help. Do not post a reply to a thread where a moderator has requested an action that has not been complied with e.g Title change or Code tags...etc

[art1234]

BY Leith Ross

Here is the macro code to do what you want.

Please Login or Register  to view this content.