fa2020
05-25-2020, 12:36 AM
Hi, everyone
I have a code for summarizing personnel work time while it's sensitive to 8 hours shift, means if the user types work time for a personnel in a specific date which their cumulative work time exceeds 8 hours, this code omits it and just write 8 hours for that personnel in that date. This code was wrote by my friend but I want to develop it to my real world problem in excel. In the last command, you see there is SumIfs object which refers to limited rows. I want to develop it to all rows in those determined columns. So, if I write my data till row 15233 (my real data in huge), there is no need to make any change in the code. I don't know how to make such a change in my code. I'm new to VBA. Please help me to learn.
I have a code for summarizing personnel work time while it's sensitive to 8 hours shift, means if the user types work time for a personnel in a specific date which their cumulative work time exceeds 8 hours, this code omits it and just write 8 hours for that personnel in that date. This code was wrote by my friend but I want to develop it to my real world problem in excel. In the last command, you see there is SumIfs object which refers to limited rows. I want to develop it to all rows in those determined columns. So, if I write my data till row 15233 (my real data in huge), there is no need to make any change in the code. I don't know how to make such a change in my code. I'm new to VBA. Please help me to learn.