Forum Discussion
copy data from 1 sheet to another if a condition is met
sheet1 has a column that list "employee names" and a column for their "punch in" times. sheet2 has a column that list "employee names" and a "start work" time column. (time when they turn the k...
dank1868 , This may not be the perfect answer, but here's my attempt at solving your problem using Power Query. I had to make a few decisions to fill in the gaps of my understanding of your industry so review carefully.
TheAntonythank you for your help.. couple of ?'s
at the end of each day i'd like to run what you created with the new "status_raw" and "hour_raw" times,. can I do this and how? can you save the workbook so it has your query and format presented to me as a new sheet and i'll just past the data in the worksheets and new totals with calculate/.. I really appreciate your help and look forward to your next mail.