Results 1 to 2 of 2

moving data from one sheet to another based on criteria

Threaded View

  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

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