I am trying to copy data depending on whether the hour of the day in sheet 1 matches the hour in sheet 2. Currently, the code below looks at contract numbers in TRANS SPECS sheet and finds that contract in sheet3 it then finds the same contract in Sheet DA-RT Flow. The macro copies a block of 24 cells indiscriminately. I was wandering if there is a way to match the hour in sheet3 with the hour in sheet DA-RT Flow once the contract has been found in both sheets. Thank you so much for any help provided!
Dim Contract As Variant
Dim Flow As Double

Please Login or Register  to view this content.