Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    St. John's, NFLD
    Posts
    18

    Question Unanswered: Copy range of cells based on selection From Combo Box

    Based on a user selection in a combo box, Is it possible to copy a range of cells from sheet1 and move them to sheet2??

    I'm kinda lost as to how to tackle this?

    Thanks, for any help I can get it.

    Greatly Appreciate it!

  2. #2
    Join Date
    Mar 2004
    Location
    St. John's, NFLD
    Posts
    18
    I have a combo box that looks up a list with 29 objects through data validation. The combo box is filled from a sheet called 'Species list' with a range A2:A30. The combo box is located on a sheet called Step 2 in cell C5.

    I would like the user to be able to select a specific object from that list and automatically copy whats in the cells on a sheet called 'dscombo'!C11:C20:G19 and paste the values from those cells into a sheet called 'Step 2'!C11:C20:G19.

    The key point that I should make is that the range of cells to be copied and pasted will vary depending on what object is selected from my combo box.

    In the range described above that I want copied and pasted, the user would have selected the first object from the list in my combo box.

    I hope this helps explain my question.

    Thanks

Posting Permissions

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