Copy data from one sheet to another

[darrenkain]

Hello guys. I need your help with writing a macro. I have an excel file that has 2 sheets:

Sheet1 has 3 columns: item (column A), quantity(column B), details (column C)
Sheet 2 has 2 columns: item (column A), details (column B)

I want to copy the data from sheet1 to sheet2 like this:

If item x has a quantity of y in sheet1, then I want to copy the item x and paste it y times in sheet2.
When pasting the item x in sheet2, y amounts of times, i don't want to include the quantity column.

Please see the attached image. Thank you in advance! You help will be greatly appreciated.
Pic.png

[FDibbins]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.

http://www.excelforum.com/excel-prog...o-another.html