dimuthumme
New member
- Joined
- Mar 17, 2014
- Messages
- 4
- Reaction score
- 0
- Points
- 0
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 it in column N & O manually.
Many thanks
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 it in column N & O manually.
Many thanks