Auto Populating a number of cells based on the value of another cell

Hi Guys,

Hopefully I can explain what I'm struggling with alright.

Basically I have a Table of names with values next to them, what i require is for the name to populate the same number of cells in a column on a different tab as the number next to the name

Is this possible? If so is it also possible to populate the cells below the first lot with the next name for how ever many cells that are stipulated in the original table

Apologies if this makes no sense

Thank you

Regards

Craig

Hi Craig,

I've hopefully created something what you wanted It's hard sometimes to make sense without examples.

So for Example if I had on Sheet 1:
A B
John 2
Steve 3
David 1

On sheet 2 I should see:
A
John
John
Steve
Steve
Steve
David

Please Login or Register  to view this content.

Perhaps include and example if this isn't what you needed to make it more clear for me

Hi Owen,

Thank you for this,

Yes it is exactly what I need but I can't seem to get it to work, or an upload an example

Apologies I haven't posted in here much

Regards

Example.xlsx

Worked out how to attach,

Basically what I need is how ever many the table states so in tab 1 the 1st 50 cells in column A should be person1, then the next 50 person4

I hope that makes sense

Regards

Even after a weekend of trying I still can't solve this,

Is what I'm after even possible does anyone know?

Thanks

Hi Craig,

Sorry I didn't have time over the weekend to do this for you.

Hopefully this should do the trick!

To run either run Macro1 or click the command button.

You can add as many people to the list and as many columns, just ensure that you add a new sheet with the following number.

Let me know if this works for you!

Thanks

Owen

Hi Owen,

That is exactly what I need,

Thank you so much!!

Regards

Craig