I have a spreadsheet containing around 20 worksheets.

I have been trying to find a macro that will lookup Column A in a named
worksheet, say testsheet10 and then find the words strings within
another sheet say testsheet1. If the words are found then I want macro
the format the row with a double underline border and upper single line
border. I would also like the macro to place sums in the cells
containing numbers within the formatted rows. This will allow me to
easily insert new rows with the values being updated. The range of the
sums will be upto the last blank cell.

I hope this is clear enough for someone to help.

Kind Regards

Andrea