| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
enter opposite number one row below
Can someone help me on this.
lets say i have column O row 1 150 row 2 row 3 92 row 4 row 5 70 row 6 how can i create a macro that goes to column O, enters the value of the cell above in this case 150, one row below having opposite sign -150, insert a row below, and continue the same procedure. In this case, making 92 as -92 one row below and insert a new row, and so on. Thanks a lot. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| enter a number if equal to another number | Excel Discussion (Misc queries) | |||
| Why am I getting ### when I enter an accting number and hit enter | New Users to Excel | |||
| when I enter a number, only ###### shows? | Excel Worksheet Functions | |||
| Always enter number as a decimal <1 | Excel Discussion (Misc queries) | |||
| enter 2 values in opposite corners of a cell | Excel Discussion (Misc queries) | |||
Threaded Mode
