Macro to replace a row with SUM formulas.

A

amorrison2006

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code to do a simple clean of one column by copying and pasting(finding and replacing) phrases in adj 4
MACRO THAT BUILDS ON ANOTHER MACRO'S DATA 6
REPOST - CF, MACRO 2
Find a value in a sheet and replace it with another value if it matches 8
vlookup help 4
Modify working code to expand the output. 5
Loop returns only one value, does not loop & an assignment to columnhow-to problem. 26
Excel 2003: macro to add data to next empty row 3

Top