Populate multiple columns

**jrg123** · 06-18-2012, 02:51 PM

I am in need of help to populate 2 columns with information from a single column. Example Range a1:A10 on sheet one to populate Range A1:A5 and B1:B5 on sheet 2. The amount of information from sheet one will be variable never over 10 rows so the macro will also have to address populating the next row on sheet two (ex. populate a1 to a5 and then the next row to populate would be B1 followed by b2.... Hopefully this makes sense. I have attached a sample book to show what I am looking for the end product to be.

**K m** · 06-18-2012, 04:01 PM

In Cell B4 of Sheet2 put this formula:
=IF(ISBLANK(Sheet1!A2),"",Sheet1!A2)
In Cell C4 put this formula:
=IF(ISBLANK(Sheet1!A2),"",Sheet1!B2)
copy these two cell down to row 8
In Cell D4 put this formula:
=IF(COUNTA(Sheet1!$A$2:$A$11)<(ROW(A4)+2),"",+Sheet1!A7)
In Cell E4 put this formula:
=IF(COUNTA(Sheet1!$A$2:$A$11)<(ROW(B4)+2),"",+Sheet1!B7)
copy these two cell down to row 8

Attached is the example you provided with the answer

Workbook Example Multiple Columns.xlsx