Vba to copy the data in a column multiple times

[tonywatsonhelp]

Hi Everyone,

Ok So
Range C9:C29 holds Employee Names
And
Range E9:E29 holds the number of Months they have been wityh us

I'd like a macro that when run take each name in Range C9:C29

and pastes it into column Z from row 5 down, the number of times they have been with us shown in Range E9:E29
so if Bob has been with use 5 month you would have "BOB" in C "5" in E and we would get 5 rows of bob in Z
and so on

please help if you can
Thanks
Tony

 

[jdellasala]

Hi Everyone,

Ok So
Range C9:C29 holds Employee Names
And
Range E9:E29 holds the number of Months they have been wityh us

I'd like a macro that when run take each name in Range C9:C29

and pastes it into column Z from row 5 down, the number of times they have been with us shown in Range E9:E29
so if Bob has been with use 5 month you would have "BOB" in C "5" in E and we would get 5 rows of bob in Z
and so on

please help if you can
Thanks
Tony

So if C5="BOB", and E5=5, and Z5:Z10="bob", where does C6="PHIL", E6=10 go? It can't go to Z6:Z16 because Z6:Z10 already have "bob"? Perhaps if you said what the purpose of Column Z is or posted a sample (using XL2BB) of the data and result, it would help. Also, are you talking about months this year, or total months? Someone there for 3 years will need 36 results. I'm confused!
Since you have 365, you might want to try putting the original data in an Excel Table too.

 

[tonywatsonhelp]

Hi,
Didn't realise this was unclear but after reading it back maybe I could have worded it better
here's a very basic example
as you see Bob goes in Z5:Z10
Phil Would go in Z11:Z21
And the next name Z22 etc.
hope that helps as I'm really stuck
Basically, I'm putting each employee's wages into the month they were paid for a check we are doing
I have a list of everything I need
But each employee is only listed once
If I do it manually it will take ages
so what I want to do is get each name as many times as they have been paid which is the number in E
I know this sounds like a strange way to do this but with the data I have it is going to be a huge help so if anyone can help please do
Thanks
Tony