This is my first post, so please forgive me if I haven't provided enough information or if I've broken any rules.
I have a macro that pulls a report into this workbook (sheet "24HR"). It is pulled every 12 hours, but needs to be transferred to the 1st worksheet ("Saturday").
So far, I'm just copying/pasting "Days" data after that shift is done, but now I need to transfer "Nights" data after that shift is done to match it up.
I would like to pull the data from "24HR" (D3:E6) and place it in (T9:T12), based on matching the Unit numbers of each sheet. After that, I need it to loop through each unit and put it in the right cells.
I have tried VBA and VLookup, but I run into problems because at times, a specific unit may not have data to pull on nights, so I need to match it up.
Thank you so much in advance. Please let me know if you need more information.
I have attached a sample file.
Bookmarks