| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cut and move rows to different worksheets
Hi everyone,
My problem is this; I have two worksheets (1 and 2) and on Sheet 1 I have data about 'work in hand'. What I would like to do is when the work data on any one row is marked as completed is simply hit a macro button that will cut the entire row and paste it to Sheet 2 on the next available row/cell (A1, B1 etc), return the user to sheet 1 and then delet the (now) blank row. Any ideas, please? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort rows and move borders with rows | New Users to Excel | |||
| How do I move up rows below blank rows in an address? | Excel Worksheet Functions | |||
| How do I move rows showing a specific field to other worksheets/. | Excel Discussion (Misc queries) | |||
| How do I move rows showing a specific field to other worksheets/. | Excel Discussion (Misc queries) | |||
| How do I move rows showing a specific field to other worksheets/. | Excel Discussion (Misc queries) | |||
Threaded Mode
