Results 1 to 7 of 7

Copy countries from sheet 2 to sheet 3 after certain creteria macro

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-28-2012
    Location
    madrid
    MS-Off Ver
    Excel 2010 at work excel 2016
    Posts
    1,119

    Copy countries from sheet 2 to sheet 3 after certain creteria macro

    Hi. I have below test sheet, which have many countries with statistic. The layout is very nice thanks to Alphafrog for some great codes to do that.
    What i need now is the possibility to choose countries to copy the data from sheet 2 to sheet 3.

    The real sheet have many many countries, so it will be a great help.

    I need a macro where a input box ask which countries i need to copy (i guess seperated by comma) press ok
    The next input box shall ask what year. press ok

    The third shall ask which months, would be nice here if i dont fill this one out it just take the upper creteria. All year i have choosen.

    Then it has to copy the country data choosen to sheet 3.(can easily been seen logically in the test sheet)

    If i do again it have to continue with 2 rows blank between the next run of the code.
    This will give me the option to collect date for countries which are connected to each other.

    So i can example collect 4 nordic countries with the year, month etc

    After i can run again with 2 rows seperation example for UK, Ireland.

    All and i think it logically when you check the test sheet how it has to be.

    I have made how it can look in sheet 3. I selected first Argentina and Austria, year 2014 and jan,feb
    After i selected Belgium, Bulgaria ,year 2014 and jan,feb

    And there is 2 blank rows between the 2 runs

    Please have a look, it some which will be a great for me to solve.

    Thanks in advance

    Sincerely

    Abjac
    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. copy rows to another sheet after merging using specific creteria
    By saurabh2k26 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-16-2013, 10:37 AM
  2. Replies: 4
    Last Post: 11-20-2012, 05:25 PM
  3. [SOLVED] Macro to Copy Data from one Sheet A to Sheet B based on value in cell on sheet A
    By scass in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-11-2012, 07:21 PM
  4. Macro: Count rows in sheet A, copy count in sheet B, paste offset in sheet A
    By Agent:Orange in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-19-2011, 07:56 AM
  5. Macro/Module running as background process, copy data from sheet to sheet
    By ctor in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-05-2009, 05:48 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