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
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 a moderator: