+ Reply to Thread
Results 1 to 3 of 3

Copy paste range of cells based on drop down list selection

  1. #1
    Registered User
    Join Date
    07-15-2016
    Location
    Lowell, Massachusetts
    MS-Off Ver
    2010
    Posts
    31

    Copy paste range of cells based on drop down list selection

    I have a column containing drop down lists with about ten options, the same drop down list appears every 4 cells, starting with B2 and is repeated hundreds of times in sheet("RunOutDates"). For each option in the drop down list I have a corresponding range of cells containing formulas on a separate sheet("Formulas"). I want to be able to make the drop down selection and have the correct range of formulas be copied and pasted from the "Formulas" tab to the "RunOutDates" tab, with the range starting two cells to the right of the drop down list.

    Please help and thanks in advanced
    Attached Images Attached Images
    Last edited by jrx; 07-20-2016 at 10:28 AM.

  2. #2
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Copy paste range of cells based on drop down list selection

    could you please provide sample workbook
    Thanks - Naveed
    -----------------------------
    If the suggestion helps you, then Click * to Add Reputation
    To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
    1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

  3. #3
    Registered User
    Join Date
    07-15-2016
    Location
    Lowell, Massachusetts
    MS-Off Ver
    2010
    Posts
    31

    Re: Copy paste range of cells based on drop down list selection

    Ive added attachments, the excel file was too large so i took screen shots. The first image is where the drop down lists are, the ones shown have the formulas already but further down they are blank. The second image is the formulas tab where i just copy pasted the other sheet so that i had a place to pull the formulas from, selected is the range i wanted to be copied, the product names listed are the selections of the drop down list.

+ 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] Auto-populate cells based on drop down list selection
    By sh1483 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-01-2016, 11:59 PM
  2. Updating cells based on selection from drop down list data validation
    By excelstun in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-18-2016, 05:11 PM
  3. Macro to copy and paste a range of cells based on ComboBox selection
    By Paul103 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 02-07-2015, 03:21 PM
  4. [SOLVED] Updating cells based on selection from drop down list data validation
    By jingles9 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-24-2013, 02:57 PM
  5. Replies: 1
    Last Post: 04-12-2013, 06:27 PM
  6. Copy cell range from another sheet based on drop down selection.
    By nhen.enry in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 08-09-2012, 09:24 PM
  7. Copy row data based on drop down list selection
    By Tom in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-21-2006, 11:55 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