copy, split and transpose a range of values

L

Lucas Budlong

I need to copy, split and transpose the times on a roster to the times on a
timehseet.

Sheet1 is a roster.
Sheet2 is a timesheet.
Sheet2 has to get its information from sheet1.
The times are shown in the sheet1 range: B2:B8 as "9:00 - 5:30pm".
The times must be entered into the sheet2 range:
C8 as 9:00
D8 as 17:30
C9 as 9:00
D8 as 17:30
etc down to D14.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split "9:00 - 5:30pm" to "9:00" "17:30" 3
Eliminate blanks while copy row and transpose 11
OnTime Change_Event macro AND copy to sheet2 macro trouble 7
Cell values to an array, then array transpose to another workbook 8
loop to copy paste 5
Copy and paste range ontime 2
Payment calculation 1
copy/paste in the next column 4

Top