Macro to replace a row with SUM formulas.

  • Thread starter Thread starter amorrison2006
  • Start date Start date
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
 
Are you able to help me do this?

It would be very helpful.

Thanks

Andrea
 
You must log in or register to reply here.

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
Transfer array element offset value to a matched value 3
Excel 2003: macro to add data to next empty row 3
Find a value in a sheet and replace it with another value if it matches 8
Mid column sum formulas with varied ranges to sum 17
Modify working code to expand the output. 5
Insert Row also adds formulas and moves cursor 2

Back
Top