+ Reply to Thread
Results 1 to 2 of 2

extracting data

  1. #1
    Forum Contributor
    Join Date
    06-27-2014
    Location
    bristol, england
    MS-Off Ver
    excel 2007
    Posts
    250

    extracting data

    Hi Guys, I have a userform that a user will choose a different month number from 2 comboboxes, a month from box1 and another month number from box2, this works and copies all relevant data to another sheet.
    What I need is some code that topull relevant data based on the month number but also some other columns from the row, see below

    I.E - there could be 30 rows of data copied,
    if for instance the data copied is for months 2 and 7, I need to pull data for column A and column j for months 2 and 7, I can do this now using countifs and sumifs, the problem is the months entered and copied will change
    [code]
    =SUMIFS($T$2:$T$500,$Z$2:$Z$500,"=1",$AA$2:$AA$500,"=A")
    [code/]

    the Z range is the month

    any idea's

    scouse13

  2. #2
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,302

    Re: extracting data

    to keep it simple and easy to read on the sheet - the userform could write what it copied over to a couple of cells and you can reference them in the formula?

    lets say A1 and B1 so something like this in the userform (whatever you call box 1 and box2)

    Please Login or Register  to view this content.
    and

    Please Login or Register  to view this content.
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.

+ 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: 37
    Last Post: 08-02-2019, 05:47 AM
  2. Replies: 0
    Last Post: 01-30-2018, 06:10 PM
  3. Replies: 1
    Last Post: 02-02-2015, 11:47 AM
  4. [SOLVED] Counting specific data and extracting that data by rearranging by assigning numbering
    By paradise2sr in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-25-2014, 07:11 AM
  5. Extracting data from file in directory and extracting filename
    By brad999 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-20-2014, 11:21 AM
  6. Replies: 0
    Last Post: 10-25-2013, 12:14 PM
  7. Extracting data from one massive worksheet to split to smaller sheets of data
    By michaelkwc in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-21-2008, 06:35 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