Suggest the top row to sum all below

--
Don Guillett
SalesAid Software

wrote in message
oups.com...
Hi

Was wondering if this is possible to do via macro,

Have two worksheets.

Both have column A

If macro find the word in column A sheet 2 in column A sheet 1 then it
will replace the cells in columns B C D E F G H I & J with SUM formulas
upto the first blank cell it finds,

Can someone help me with this?

Thank you

Andrea