| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy, split and transpose a range of values
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy and transpose basing on cell values | Excel Discussion (Misc queries) | |||
| Copy, Transpose and Paste Values for a Large Data Set | Excel Programming | |||
| I WANT TO TRANSPOSE LINKS, AS WE TRANSPOSE VALUES | Excel Worksheet Functions | |||
| copy Transpose range data | Excel Programming | |||
| Range COPY function - how to copy VALUES and not formulas | Excel Programming | |||
Linear Mode
