Extend cell

[MartinPlovdivBg]

Hello, can someone help me with this situation because im stuck and cant find solution. Is it possible to multiply the active cell with values down based on the quantity? As I have shown in this case, the name John Smith has a value of 10. I need John Smith to appear 10 times down the column! I'm not an expert on VBA, and for that reason I'm asking for help. I would be grateful if you could help me! Thank you in advance!

 

[6StringJazzer]

You may not need VBA depending on why you want to do this.

Is 10 just an arbitrary value, or do you want to use 10 because that's how many times this name occurs?

If you just need a count of how many times the name occurs then you can use this formula in column B:

=IF(A1="","",COUNTIF(A:A,A1))

 

[MartinPlovdivBg]

The problem is that i have list of 150 000 and some of them are with quantity different of 1. The formula that i created can work only if the cells are only positioned this way down!

 

[MartinPlovdivBg]

Im using Vlookup to find specific list with articles numbers for this reason i need export income invoices with the article numbers. The problem is that the software can export only this way John Smith 10Pcs.. The only way that i can do it with Vlookup but Vlookup takes only the first result. I found solution for that but now im stuck Because i have 10pcs but for Vlookup i have just one

 

[MartinPlovdivBg]

Th

You may not need VBA depending on why you want to do this.

Is 10 just an arbitrary value, or do you want to use 10 because that's how many times this name occurs?

If you just need a count of how many times the name occurs then you can use this formula in column B:

=IF(A1="","",COUNTIF(A:A,A1))

Thank you for your fast response. 10 is just arbitrary number . I have 150000 articles with different quantities. Like I explained I need some function or VBA that can drop the article down leading by quantity It’s impossible for me to do it