Insert a new row below text and formatting Macro issue

Hi All

I'm having difficulty with a particular macro and wondered if anyone can help.

The workbook has 2 tabs
1) NEW
2) RATES

The 'NEW' tab has 5 blue buttons along the top (Labour, Plant, Materials, Other, OHP) that should each have the following function -

1) Find the word associated with the button

2) Insert a row BELOW this word
-Problem 1 - This function doesn't seem to work properly, it finds the word but then when i insert the row below, the code just picks up on the actual row number.
-Problem 2 - When i insert the row the format is different as Col A to E should be merged.

3) In this new cell below the correct word I insert a list from the 'RATES' tab

4) A VLOOKUP then adds the appropriate rate for this item and a few other bits.


The main issue i'm having is that when recording my macro the code picks up on the specific row i choose (i.e. Row 11, Row 12) instead of the one under the right word for the button pressed. Therefore if i have already inserted rows on the sheet, the new line comes under the wrong category.

It might be easier to look through it and i'll try to answer any question.

I've only added the Labour and Plant macro at present (CODE below). If you press the Plant button once and the Labour button once the rows are added into the right place. Then if you press Plant button again the row is in the wrong place.

Really appreciate any help.

David
(A newby here and to Macros)

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

Please Login or Register  to view this content.