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. |
All times are GMT +1. The time now is 06:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com