Macro to duplicate lines changing cell value

**jdepablo69** · 05-29-2012, 10:17 AM

Hi,

Sorry if this has been already solved in some other thread but I've been unable to find it.

Basically I have an spreadsheet with skus in column A (say 'baseball bat', 'baseball cap', 'baseball jacket'...) and a qty in column B (i.e. 300, 200, 150...).

Is there a way to split row 1 'baseball bat' = 300 resulting in 8 rows (1 to 8) 'baseball bat' = 60, then row 2 (now row 9) 'baseball cap' = 200 in 4 rows 'baseball cap' = 50, and so on...

Thank you.

**arlu1201** · 05-29-2012, 10:22 AM

This can be done. But you need to explain on what basis do we create the duplicate rows? How do we know that baseball bat should be 8 rows and baseball cap should be 4 rows?

**jdepablo69** · 05-31-2012, 06:04 AM

Thank you. I'm sorry. I would need resulting lines of 50 (300 = 6 lines not 8), (200 = 4 lines), (150 = 3 lines)... if I have, say, 125 I would need 50, 50, rest (25). Thank you so much again!!!!

**arlu1201** · 05-31-2012, 06:42 AM

Is there data only in columns A & B?

**jdepablo69** · 06-01-2012, 02:28 AM

Sometimes there's a column C but I could enter that column after running the macro. Anyway if there're more columns they shouldn't change. Thanks!

**arlu1201** · 06-01-2012, 06:21 AM

Try this code

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose Tools | Macro | Macros
Select a macro in the list, and click the Run button.