Hello,

I want to select the dates(from column H) in which the value(in column I) is greater than zero and paste them in column K(Attachment). At the same time, I want to expand each day for 24 hours. That means, I want to repeat the date 24 times while pasting in column K. Kindly help me. I would prefer the formula as I hv to repeat the same for large number of sheets.

To make it more clear, I hv illustrated what I need in column N & O manually.

Many thanks