Data from two sheets onto one new sheet using VBA

[twanbiz]

Hello,

I have data on two sheets. Sheet1 has data in column A. Sheet2 has data in column A. What I want to do is on sheet3 take each cell on sheet1 and place it column A repeating the cell value for as many rows as there are in sheet2. Then I want to have each value of sheet2 in column B of sheet3 next to the repeating value from sheet1. I am having a hard time describing what I want but if you take a look at the file I uploaded it is pretty explanatory. Thanks.

[patel45]

Please Login or Register  to view this content.

[abduljaleel.mca]

Use this macro....

[twanbiz]

Thanks to the first poster patel45 one worked like a gem. Appreciate it.