Auto-fill cells depending on input

Hello,

I am trying to have cells auto-filled depending on the input, I attached an example of the format I'm looking at.
I previously was able to do this with regular functions, however, now there would be a number stating how many times the cells need to be repeated.

I have attached an example Excel with the data format. I split it in 2 tabs to make clear what input and what output would be.

Here, Column A-D would be a text string, and E on the input tab as a number, noting how many times A-D should be repeated.

I'm struggling with linking the number of repeats to the output, without "replacing" lines.

If you could push me in the right thinking path already that would be great!

(Is this even possible)

Thank a lot in advance,
Kobe

Here is another macro (non-looping) that you can try... run it with your data sheet active (I can modify the code if you will need to run it with a different sheet active)

Please Login or Register  to view this content.

Originally Posted by Richard Buttrey

.......Neat!

Nope! As it turns out, my code appears not to be neat at all... because it doesn't work correctly (anymore). I tested it before I posted it and I could swear it worked correctly... then, but in testing it again on a brand new workbook it no longer is working correctly. I am not sure what went wrong... yet, but I'll figure it out (hopefully) and post back with corrected code once I have done so. In the meantime, ignore the code in Message #3!!!

Okay, I figured it out. While I was at it, I made it so the last column can be anything the programmer specifies... all they have to do is assign the column letter designation for the last column to the LastCol variable.

Please Login or Register  to view this content.

Thanks Rick, this code works brilliantly!

Just to understand how this work, how do I define the starting position? Let's say that instead of Row 2 I want it to start from row 3

Here is my code modified to start on Row 3 (I highlighted all of the changes in red)...

Please Login or Register  to view this content.

Thanks a lot Rick, this really helped me out, probably saving 100s of hours in the long run :-)