Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert, Delete row and cell
A B C D E 1 Date Description Amount 2 01/05/09 ?????? 100 S 20 3 30 4 1. How can I use macro to insert rows whenever I input "S" in column D, I should be asked how many rows I would like to insert. 2. Delete any rows below the "S" when I delete "S" in column D. The number of row will be dependent on whether the cells in coulmn A are empty below the "S". In the above example row 3 and 4 would be deleted. Any data in column E onwards in the same row as the "S" will also need to be deleted. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert name - delete all | Excel Discussion (Misc queries) | |||
cut and delete a row then insert and copy | New Users to Excel | |||
delete every X row, insert everyY row | Excel Discussion (Misc queries) | |||
How can I insert and delete rows within a locked cell range column | Excel Worksheet Functions | |||
can't insert, delete or move pictures | Excel Discussion (Misc queries) |