Results 1 to 6 of 6

Copy Data from Column and Paste to Next Blank Column on 2nd Sheet

Threaded View

  1. #1
    Registered User
    Join Date
    01-28-2010
    Location
    montreal, canada
    MS-Off Ver
    Excel 2003
    Posts
    6

    Copy Data from Column and Paste to Next Blank Column on 2nd Sheet

    I am using Excel 2003
    Sheet 1: A1:A20 Contain Questions, B1:B20 is where we will insert answers

    I want to be able to push a button linked to a macro that will copy/paste the range b1:b20 and paste to the next empty column on sheet 2, starting with column B.

    Ideally this macro would then blank out the cells b1:b20 on sheet 1

    Please any help would be appreciated, I am very inexperienced.
    Last edited by adammark; 04-19-2010 at 11:00 AM.

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