Page 1 of 3 1 2 3 LastLast
Results 1 to 10 of 30

Thread: Array working different in two files

  1. #1

    Array working different in two files



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have had File A (attached) working for years now. It was our timecard. I have removed some information but it doesn't affect my issue. So, I have a macro called Consolidate that would look at each day and the week and at the bottom under Weekly Job Totals, would list each job number individually worked on, then tally the hours for that job number. Columns I through P were hidden on the card and were used to help with array by day.

    Now we switched to a new timecard (File B) and I've been making the same codes in the new one so it functions the same but now the array tallies the numbers including the job number. I have matched everything to a 't' that i know of, (font style, type, etc.). Why is it adding my job numbers together? Also, the next column labeled CC in Column Q of File B, I'll need that to not add together also.

    Any help?
    TIA
    Last edited by Ken Puls; 2014-04-07 at 07:03 PM. Reason: Attachments removed due to sensitive contents at user's request

  2. #2
    Neither tallies each job number individually that I can see. A tallies them all into 1, B tallies into 2.

  3. #3
    Quote Originally Posted by Bob Phillips View Post
    Neither tallies each job number individually that I can see. A tallies them all into 1, B tallies into 2.
    Try this updated one. It works for me, but I didn't remove as much data as before, in which case we may be on to something....if I removed something important on the first post but I'm pretty sure I didn't.

    Use job numbers 1022000, 1023000, and 1024000 with different combinations of hours. Then at the bottom hit Sign, then Submit (at top.)
    Last edited by Ken Puls; 2014-04-07 at 07:04 PM. Reason: Attachments removed due to sensitive contents at user's request

  4. #4
    There are no jobs to aggregate there, so apart from a few zeroes, it does nothing.

  5. #5
    Here is a different copy of the file. In this version, the Submit won't work which is fine but you can at least hit the Sign button and run the Consolidate Macro. If we look at this a different way because it's not working on your end, how would you array the data to achieve a list at the bottom listing each job number during the week and the total Regular hours to that job number?

    Thanks for your help on this!
    Attached Files Attached Files

  6. #6
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Can you please post links to your thread(s) in other forum(s)?


  7. #7

  8. #8
    I'm still at a loss here. I found myself trying to find another method of tallying hours based on the job number but the original issue is that this array worked on my old timecard, but doesn't on the new one. I don't understand what would have changed. Is there any ideas or new ways to array my job numbers/time?

  9. #9
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,479
    Articles
    0
    Excel Version
    365
    I'm not sure at all, but are you missing something from the end of the consolidate statement?

    …Function:=xlSum, TopRow:=False, LeftColumn:=True, CreateLinks:=False
    instead of:
    …Function:=xlSum

  10. #10
    It wasn't on my original excel file, however I added it to the new file and it worked for the most part! What is each command doing? It worked on my job numbers and the hours, but there's another column of data next to the job number (Column Q "CC") that is still adding when I just need it to list the data once. How can I achieve that?

    Thank you for the input!

Page 1 of 3 1 2 3 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •