| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to add row in same worksheet based on 2 fields not having a
I have 6 columns of data and an unspecified number of rows. If a row has a
number that is not 0 in both columns 5 & 6 then I need to insert a row below that row and copy all the data from the original row. Then I need to put a 0 in the original row column 5 and put a 0 in the inserted row column 6. e.g. SPX OCT 2008 900 0 400(this row would be left alone) but SPX OCT 2008 1000 -200 300(this row would need the macro applied to it). Is this possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to hide worksheet based upon text in the name | Excel Discussion (Misc queries) | |||
| Macro to open worksheet based on name in cell | Excel Discussion (Misc queries) | |||
| macro to copy specific fields to another worksheet | Excel Programming | |||
| Calculated Fields Based on Running Total Fields? | Excel Programming | |||
| Calculated Fields Based on Running Total Fields? | Excel Programming | |||
Threaded Mode
