I need to return the data from a cell, but the cell to identify where the data is stored moves
So I have the below data returned from a time clock in system. Ill be pulling this data in to a master sheet from a folder, and then subsequently pulling in the newest report stored into the folder there after.
I need to be able to return in a separate sheet the id number accompanied by the total hours for the individual.
So it would read like this.
ID HRS
3 15
4 28.45
5 41.77
The Total Hours column row and ID row will differ report to report due to clocking in and out for breaks and not so no way to hard code the data to a cell. Im not amazing with power query and wondered if that would be able to solve my issues but i cant think of any excel function that will be able to do what i require it to do. Any help
[link] [comments]
Want to read more?
Check out the full article on the original site