I need help to combine the two ranges together to give me the new row
in a new sheet.
Sheet1 has the two ranges i.e. A1:C50 , E1:G50.
How to use a VBA module to create the new rows under the belo
conditions.
A1:C1+E1:G1 continue until A1:C1+E50:G50
This combination will produce 50 rows (A1:F50)
then
A2:C2+E1:G1 continue until A2:C2+E50:G50
This combination will produce 50 rows (A51:F100)
until the last conditions
A50:C50+E1:G1 continue until A1:C1+E50:G50
So after completing combining A1:C50 with E1:G50, Sheet2 will have 250
rows (50x50) (A1:F2500)
Thank you.
Regards
Michae
--
Message posted from
http://www.ExcelForum.com