Hello everyone,
I would like to do the following:
- double click on a cell in column H (starting from cell H14 and down) inserts a row below, copied from another sheet (hidden sheet with data)
- double click on a cell in column I (starting from cell I15 and down) deletes this row.
This will apply for a several section on the sheet, but insert or delete cells will be always in columns H & I. Also, top row after section title ("Section A", "Section B") will only have cell H active, so the top row couldn't be deleted.
The whole sheet will be shifting down and up, so the row numbers won't be constant (even the top rows after each section title).
Thanks so much!
PS: I tried creating shapes with macros, but with help of MrExcel was only able to figure out how to insert/delete row based on active cell. Hence, trying double-click. Thanks so much!
I would like to do the following:
- double click on a cell in column H (starting from cell H14 and down) inserts a row below, copied from another sheet (hidden sheet with data)
- double click on a cell in column I (starting from cell I15 and down) deletes this row.
This will apply for a several section on the sheet, but insert or delete cells will be always in columns H & I. Also, top row after section title ("Section A", "Section B") will only have cell H active, so the top row couldn't be deleted.
The whole sheet will be shifting down and up, so the row numbers won't be constant (even the top rows after each section title).
Thanks so much!
PS: I tried creating shapes with macros, but with help of MrExcel was only able to figure out how to insert/delete row based on active cell. Hence, trying double-click. Thanks so much!
