Hi Experts,
Attached file has a few sheets which (need to) do the following:
Sheet "Data"; contains the data to work with. This will be updated each week by previous week (or multiple weeks) data
Sheet "Calculation": is column A:L from sheet "Data" copied into column A:L, column M:Q contains formulas
Sheet "Overtime", "Clock Adjusted" and "Clocktime" needs to be filled based on the below.
I've already created a macro which copies lines with overtime (Column M <> 0 in sheet "Calculation") to the sheet "Overtime".
What I still need and what I can't get to work is:
1. a macro (new or added to the excisting one) which copies column A:L from sheet "Data" to sheet "Calculation" column A:L (thus leaving the formulas in column M:Q intact)
2. a macro (new or added to the excisting one) which copies the lines from sheet "Calculation" to sheet "Clock Adjusted" if cell value in column N and/or column O <> 0
3. a macro (new or added to the excisting one) which copies the lines from sheet "Calculation" to sheet "Clocktime" if cell value in column P and/or column Q <> 0
4. For all 3 sheets the macro need to add only the unique lines, so don't copy lines which are already there when the macro is run again.
I hope that I've explained the above a bit clear for you, if not, please do let me know.
Thanks for all your time and effort!!
Peter
template.xlsm
Bookmarks