+ Reply to Thread
Results 1 to 2 of 2

Copy range and paste depending on the selected checkbox

  1. #1
    Registered User
    Join Date
    07-21-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2010
    Posts
    46

    Question Copy range and paste depending on the selected checkbox

    Im looking for a macro that can get a cell RANGE, the data in the RANGE will be copied then if the checkbox is selected it will copy the same data in the RANGE and add the selected checkbox in next column

    Please see my sample below

    I have column A and Column B < this is my selected range

    Capture1.PNG

    I will have a form that has checkbox and buton.

    When all the checkbox is selected. when the button is click. the result will be.

  2. #2
    Forum Contributor
    Join Date
    08-15-2012
    Location
    Australia
    MS-Off Ver
    Excel 2016
    Posts
    349

    Re: Copy range and paste depending on the selected checkbox

    Something like this;
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] copy-paste-selected-cell-range-another-sheet
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 04-26-2013, 06:12 AM
  2. copy paste selected range from one sheet to another
    By sivdin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-10-2011, 06:57 AM
  3. Replies: 0
    Last Post: 05-11-2011, 04:11 AM
  4. Need Macro to copy lines depending on agent selected and date range
    By eglassburn in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-22-2010, 07:22 PM
  5. CheckBox Code to copy & paste range
    By Casey in forum Excel General
    Replies: 0
    Last Post: 10-13-2005, 12:32 PM

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