Repeat value certain number of times [Closed]

Report
Posts
1
Registration date
Thursday June 1, 2017
Status
Member
Last seen
June 1, 2017
-
 Blocked Profile -
Hi Guys!

I'm having a hard time creating a formula to extract data based from this.

This is what's showing in one of the sheets:

8:30 PM 4.00
8:45 PM
9:00 PM 2.00

I would want to paste that on the next sheet which should look like this:

Mon
Shift Time
Emp 1 8:30 PM
Emp 2 8:30 PM
Emp 3 8:30 PM
Emp 4 8:30 PM
Emp 5 9:00 PM
Emp 6 9:00 PM

Basically, the next sheet will paste the time on column 2 four times if the first sheet's column 2 will have a value >0

1 reply


POst some code and we can help. Take a look here: https://ccm.net/faq/53497-how-to-manipulate-data-in-excel-using-vba that should have everything you are looking for. If not, post some code and we can help out!