| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
use an input box to select a range and copy to another worksheet
Hello, I would like a sub that allows a user to select a date. That row is
copied down to and including the person on call, and pasted into a newly created sheet, displaying their corresponding start and finishing times. The worksheet looks like this, column A is hidden .........B..........C...........D............E.... ...........F...................G..............H .........MAIN................Monday...Tuesday...We dnesday...Thursday...Friday ..........Start....Finish...3 Apr...... 4 APR.........5.Apr.............6.Apr.........7 Apr 1.......7:00 15:00 TINA 2.......7:00 15:30 TRICIA.... SUE...........THERESE.......JACKIE.......ANNA 3.......7:30 16:00 JEANNE....ANNA .......FIONA............ANNA.........THERESE 4.......7:30 16:00 CHRIS.......................CHRIS 5.......7:30 15:00 .................................................. ........TRICIA 6................................................. ............................................... 7.......Level 5............ 8.......9:00 18:00....Jackie.......John..........ag Jeff...........ag James 9......10:00 20:30 ....Carrie........................................ ............................. 10................................................ .................................................. ... 11.....Transport.................................. ........................................... 12 8:30 23:00 Harry...........................Peter............. .... 13................................................ .......................................... 7........CALL................james.....stuart..... ....aimee 8................................................. ............................ 9.......Rdo.......Jess 10.....Lsl.........carol and I want the output to look like this Tuesday 4 APR 7:00 15:30 SUE 7:30 16:00 JEANNE 7:30 16:00 CHRIS 7:30 15:00 Level 5............ 9:00 18:00 Jackie 10:00 20:30 Carrie Transport. 8:30 23:00 Harry CALL................james Rows are added at anytime, and taken away, so a simple select is not enough. What do you suggest? Your help is greatly appreciated !!!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select a range of data dependant on the users input ie dates | Excel Discussion (Misc queries) | |||
| sheet protection - only selected range to be able to select/input data | Excel Worksheet Functions | |||
| Select cell from range based on input in excel xp | Excel Discussion (Misc queries) | |||
| Copy cells into another workbook with an input box to select the file | Excel Programming | |||
| CODE to select range based on User Input or Value of Input Field | Excel Programming | |||
Threaded Mode
