Copy-Paste range based on condition

[Link]

Hello all,

Could you please help me with following request?

I have attached a workbook as an example. As you can see "Raw data" are included in columns from A to F. I would like to run a macro which will go through all rows and will check all rows based on time in column B. If the particular row is in time period 7:00 - 17:00 (including 7:00 and 17:00) it will copy data from the particular row to section "Working Hours Only". I need to process only data occurred during working hours.

I will appreciate all the replies.

Thank you in advance.

[MaczaQ]

some error in time of sending reply

[MaczaQ]

Please check out following solution:

Please Login or Register  to view this content.

You also shoud change formatting for cells in column H & I

Best Regards

[Link]

Thank you very much. It works exactly as I expected

[MaczaQ]

consider to mark this thread as solved

Best Regards