+ Reply to Thread
Results 1 to 2 of 2

Rolling up data with 3 criteria's in VBA

  1. #1
    Registered User
    Join Date
    06-01-2004
    Posts
    36

    Rolling up data with 3 criteria's in VBA

    Good day folks,

    Note: This post can also be found on
    http://www.mrexcel.com/forum/showthread.php?t=344516

    I was wondering if someone could help me with a function that will sum up hours based on a employees timecard. It is kind of a unique setup but I think someone may have come across a similar problem. Here is the setup, I have a Raw data tab that contains:

    EE ID, EE Name, HrsWorked, Rate
    1 Name1 3 10
    1 Name1 3 10
    1 Name1 8 15
    2 Name2 3 15
    2 Name2 3 15
    2 Name2 8 15
    2 Name2 6 15
    2 Name2 4 15
    3 Name3 1 14
    3 Name3 9 14
    3 Name3 8 18
    3 Name3 8 18
    3 Name3 7 18

    Then I have a main tab that sums up each employee based on there "Rate". The calc is this HrsWorked * Rate. But the catch is this, if the employee's rate changes this that will afect the line item on the main tab. The main tab looks like:


    EE ID EE Name HrsWorked Rate Fees
    1 Name1 6 10 60
    2 Name1 8 15 120
    3 Name2 24 15 360
    2 Name3 10 14 140
    2 Name3 23 18 414

    I understand the VBA part on bringing over the name, but I cannot understand how to separte this data by rate? Essentically, I want to take the data from the Raw tab and transfer it over the main tab, and at the same time rolling up the data, based on the Rate. Keeping in mind that the Rate may or may not change during the time frame. If anyone could help me on this it would be great. I have attached the file to make it more clear.

    Thank you,
    Attached Files Attached Files
    Last edited by TheLeafs; 09-30-2008 at 03:22 PM.

  2. #2
    Forum Contributor
    Join Date
    02-27-2008
    Posts
    764

    macro

    Hi
    Pl run the macro in the attached file
    Ravi
    Attached Files Attached Files

+ 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. Data and number manipulation
    By Mwhite in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-15-2015, 06:41 AM
  2. automatically move left one cell after data input by scanner.
    By dgbillings in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-24-2010, 10:58 PM
  3. Replies: 2
    Last Post: 02-14-2008, 05:02 PM
  4. 12 months rolling data in graph format
    By brissy in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-20-2007, 08:05 AM
  5. Macro to create new sheets from master data sheet
    By adsigel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-04-2006, 09:21 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