Create macro to insert rows relative to the value

[ofranco]

Hello,

I'm pleading for help and any help would be greatly appreciated. I'm searching for answer to my problem for over a week. This is the last hope. Here is assingment I've got:

I'm trying to create funcy expense report where button exist to insert rows. I know how to assign macros to button but need macro code. I need to be able to click on button and see message that's asking user # of rows to insert. The tricky part is where I need rows to be inserted.

Here is example:
A1 - Travel Expenses
A2 - auto rental
A3 - meals
A4 - taxi
A5 - gas
A6 - Auto Expenses

I have data validation (from A2:A5) and need that rows to be copied before Auto Expeses and inserted cleared off from filled data (in this example w/o word "Gas") before Auto Expenses. As AutoExpenses shift down I would want macro to insert copied cells always above Auto Expenses cell.

I was able to find macro that inserts blank rows where active cell is located, but I'm still dummy in figuring out the code and modifying it to suite my need. Here is what i've got:

Please Login or Register  to view this content.

Your help is greatly appreciated!

Thank you in advance