I appreciate everyone's replies. Skip, Your replies have generated more questions. Is nesting of For..Next even possible?? If so, How do i do it without getting the results I am getting?
Another question about the copy/paste idea...If Range("J" & Variable) and Range("K" & Variable), How would...
Sorry, I was trying to be as brief, but detailed as possible...To answer your questions, The dates are the dates of the detachment. Each day they rate OT.
The hours are as follows:
Total Pay
OT Hrs w/o OT Base Pay
H J K
58 1 $93.94 $46.97
59...
The groups of names will be paid overtime on the last day of a detachment
I have copied a group of names from "Data" worksheet (J2 - J13) to "Attach" worksheet for each day they will be on Detachment (ie, May 13, 14, 15, 16 etc...)
May 13 Name1 (base $$$)K54
May 13 Name2 (base $$$)K55
May 13...
Private Sub FixData2_Click()
Dim KNum
Dim LNum
Dim MNum
Dim PNum
Dim RNum
Dim TNum
Dim Counter
Dim Check
Check = True: Counter = 0
KNum = Range("N2").Value ' Should be equal to "2".
LNum = Range("N4").Value
RNum = Range("N12").Value
If KNum = 2 Then
Range("K" & RNum).Select...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.