| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| The 'Look in' box for the 'Replace...' has only the 'Formulas' | Excel Discussion (Misc queries) | |||
| Replace Formulas with Values | Excel Programming | |||
| Using Find and Replace to replace " in a macro | Excel Programming | |||
| Excel Macro does not Replace text in formulas for several workshee | New Users to Excel | |||
| Search - replace NOT in formulas | Excel Worksheet Functions | |||
Hybrid Mode
