+ Reply to Thread
Results 1 to 2 of 2

moving data from one sheet to another based on criteria

  1. #1
    Registered User
    Join Date
    07-17-2013
    Location
    Des Moines, IA
    MS-Off Ver
    Excel 2007
    Posts
    19

    moving data from one sheet to another based on criteria

    I have a workbook that tracks sales people production. All sales people will enter information about the sale on one sheet. This information includes the date(B5:B2000), client name(H5:H2000), sales person name(A5:A2000), the type of product(F5:F2000), and the company that provided the product(E5:E2000).

    I would like to aggregate this information on a separate sheet by clicking a button. The info needs to be moved to a row on the sheet based on the company that provided the product (E5:E2000) and only if the sale was made that month (B5:B2000) in order for us to calculate what we pay the sales person. The data on the sales input sheet may be sporadically placed, for example, it could be in row 7, 10, 23, 48, etc. It's not necessarily one-after-another. I would like the data to display on the second sheet without any empty rows.

    I attached an example of what I'm trying to do. Any help would be appreciated.
    Attached Images Attached Images

  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,906

    Re: moving data from one sheet to another based on criteria

    An alternative to moving the information with complex VBA would be to use the SumIfs function within Excel.

    Here is a link to a tutorial.

    http://blog.contextures.com/archives...iple-criteria/
    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. [SOLVED] need help moving info from one sheet to another sheet based on criteria
    By MariahD24 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 12-24-2012, 03:20 AM
  2. Moving rows of data to a new sheet based on date criteria
    By kaufmann98 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-11-2012, 01:41 PM
  3. [SOLVED] Moving rows to a different sheet based on yes/no criteria
    By mpc_2012 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-25-2012, 06:01 AM
  4. Moving row in one sheet to another sheet based upon criteria
    By dcpeak in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-24-2012, 10:34 AM
  5. Moving data to another sheet based on criteria
    By jantonio in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-06-2009, 12:24 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