Hey Gang,
First off, new to Power automate, but I do want to learn it. I have an existing idea for an automation that I could use to to help me learn power automate.
I want to have several employees to use an excel sheet to enter their daily hours. these hours could and usually would be assigned to different job numbers and job codes. *(IE) Job number: 4000 1.5 hours Design
4001 1.0 hours Design
etc. There could be several entries per day or just 1 entry for the Monday to Saturday work week.
When all the hours are entered for the day or even week, I want to automate the process of populating another excel work book that acts as the summary for all my people. Entering all the data into a sortable table based on job number, hours, code, etc in some kind of formatted sheet.
Is power automate the right tool for something like this. I know I could do it with a lot of VBA code, but I was hoping there was a more low code approach like this.
Thanks in advance
Terry