+ Reply to Thread
Results 1 to 2 of 2

VBA Macro Copy/Paste Based on Two Data Validation Drop Down Lists

  1. #1
    Registered User
    Join Date
    11-04-2019
    Location
    Columbus, OH
    MS-Off Ver
    2016
    Posts
    1

    Question VBA Macro Copy/Paste Based on Two Data Validation Drop Down Lists

    Hello all,

    I am looking to use a macro that copies specific cells based on two different drop down lists. Fore example, if cell B3 = 'x' AND cell B4 = 'y' then copy and paste cells B44,F44, etc. to a different worksheet. Cell B3 contains 16 different options, and cell B4 contains 12 (months out of the year). Also, each 'y' variable will need to be one row below the previous one.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,884

    Re: VBA Macro Copy/Paste Based on Two Data Validation Drop Down Lists

    Please read the yellow banner at the top of this page.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. Replies: 5
    Last Post: 12-23-2016, 10:12 AM
  2. MACRO REQUIRED - Paste results from Data Validation drop down into separate tabs
    By FULTANIO in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-08-2015, 06:38 AM
  3. [SOLVED] data validation lists - drop down lists too small
    By reglook0736 in forum Excel General
    Replies: 3
    Last Post: 04-24-2015, 12:49 PM
  4. I need a macro to enter data based on data validation lists.
    By DorothyFan1 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-30-2012, 08:58 AM
  5. Drop down based on multiple validation lists
    By projectile in forum Excel General
    Replies: 9
    Last Post: 11-17-2011, 11:11 PM
  6. Using a macro to copy and paste lists of data from one sheet to another
    By johnnieboi89 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-28-2011, 04:39 PM
  7. [SOLVED] how do i copy drop down lists and paste them
    By KJP in forum Excel General
    Replies: 1
    Last Post: 10-07-2005, 10:05 AM

Tags for this Thread

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