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.
Bookmarks