I need a macro to insert an entire row with a specific heading.
But first it needs to search in the B column for a specific word that I list, and then insert a row with a heading that i specify. Also, in the A column it needs to insert a "+" or "-" based on my specification. This is for a budget and i would like to have a form inside the excel sheet to fill out with a button to create/delete these rows.
i.e.
+ xxx
- rent
+ loan
+ xxx
- rent
+ loan
needs to then look like
\/\/\/\/
+ xxx
- rent
+ new entry
+ loan
+ xxx
- rent
+ new entry
+ loan
Help much appreciate!
But first it needs to search in the B column for a specific word that I list, and then insert a row with a heading that i specify. Also, in the A column it needs to insert a "+" or "-" based on my specification. This is for a budget and i would like to have a form inside the excel sheet to fill out with a button to create/delete these rows.
i.e.
+ xxx
- rent
+ loan
+ xxx
- rent
+ loan
needs to then look like
\/\/\/\/
+ xxx
- rent
+ new entry
+ loan
+ xxx
- rent
+ new entry
+ loan
Help much appreciate!