Macro to replace a row with SUM formulas.
 

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

Macro to replace a row with SUM formulas.
 

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

Macro to replace a row with SUM formulas.
 

Are you able to help me do this?

It would be very helpful.

Thanks

Andrea

Don Guillett wrote:
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

Macro to replace a row with SUM formulas.
 

row 1 title
row 2 =sum(a3:a300)copy to the right

--
Don Guillett
SalesAid Software

wrote in message
oups.com...
Are you able to help me do this?

It would be very helpful.

Thanks

Andrea

Don Guillett wrote:
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