Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA to insert a row with -999.99
I have a file that needs to go into my application but all the data is
grouped together. My application will recognize it is moved on to a new data set when it see's -999.99, and the application is smart enough to say hey this an entirely new data different from the data above it. Here is generic example of what I have: 23 95.6 10003 23 80 650 23 2 897 49 600 10000 49 23 11 Here is what I would like to have: 23 95.6 10003 23 80 650 23 2 897 -999.99 -999.99 -999.99 49 600 10000 49 23 11 So whenever the value changes in column A to a new value I need it to insert a new row of data that have the values of -999.99. Thank you for the help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot insert worksheet in exel - not available in insert menu | Excel Worksheet Functions | |||
insert row / insert column command buttons | Excel Worksheet Functions | |||
How can I insert a date with an icon (calendar) insert | Excel Discussion (Misc queries) | |||
Can I auto insert a worksheet when I insert a value in a cell. | Excel Worksheet Functions | |||
Insert Next? Or insert a variable number of records...how? | Excel Discussion (Misc queries) |