Results 1 to 7 of 7

If check box is checked, then copy specific cells to new sheet

Threaded View

  1. #1
    Registered User
    Join Date
    04-14-2012
    Location
    Paris, France
    MS-Off Ver
    Excel 2010
    Posts
    25

    If check box is checked, then copy specific cells to new sheet

    Hello everybody,

    I've been working on a template to create an estimate based on checked items in the ItemList sheet. So far I was able to copy the entire row of the checked items to the estimate sheet. What I'm actually trying to do are two things: (1) be able to copy specific cells from the row of the checked items (Cells from columns A, C, E, G) and (2) then paste them and present the information the same way it's displayed on the Estimate sheet. On the Estimate sheet, you can see that the Group Name has been inserted on top, while the checked items are listed beneath it, and finally there's a formula to sum the total amount of that specific group. Any help on this would be appreciated alot.

    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Check Box that shows options in Combo Box if Checked, and Hides if Not Checked
    By dumbjodie in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-13-2013, 10:06 AM
  2. [SOLVED] When checkbox is checked it does not copy to new sheet. Only if not checked using false
    By thelisa in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-28-2013, 07:59 AM
  3. Check cell Value in range and copy specific cells to another sheet
    By jmethejedi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-08-2013, 06:25 PM
  4. Replies: 2
    Last Post: 12-19-2012, 11:23 PM
  5. Copy data against each checked check box and paste in a new excel workbook
    By rnd in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-28-2010, 06:04 AM

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