Results 1 to 4 of 4

Populate multiple columns

Threaded View

  1. #1
    Registered User
    Join Date
    05-17-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    11

    Populate multiple columns

    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.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1