Hi. I'm an absolute noob when it comes to VB and am learning as I go. I've managed to create and edit a few macros that work well, but am stuck on an important calculation that I need built into a macro.
My sheet is extracted data from a timeclock we use to calculate payroll. I have it set up to run a macro where it sets up the data the way I need it and then does a Sum to Blanks in my "totals" column, giving me a total hours for each employee. What I need now is to have excel pull out the regular hours of the summed cells and place it in the cell to the right. I've got it working ok, but it will only put the value of the 1st summed cell into all the corresponding cells throughout the column (for example: my 1st summed cell is 76. It puts 76 in all the cells, instead of going through each of the summed cells to see their value). I've tried adding a loop, but I think i'm failing miserably here. Any help would be greatly appreciated. My data is in Column U and I want to have the Reg hours put into column V for each "Special Cell that has a Formula" in Column U.
Bookmarks