Add 1 value from row to other column 1 row below

[jared.geli]

Hi guys I need help on adding a value from 1 row to other column 1 row below.
I know it's kinda confusing so here's what I want to do:

Column_A    Column_B    Column_C
1           25%         25%
2           15%         40%
3           25%         65%
4           35%         100%

So far I don't have a clue how to do it

[ddanbe]

We don't have a clue either.
Is it Excel? A DataGridView? From a database?
Do you already have some code? (This may be wrong code, doesn't matter)
Please let us know.

[jared.geli]

From column_b first row its value is 25%, column_c is equals to column b. 2nd row column_b is 15%, 2nd row column_c is equals to 40% because the 25% from first row column_c is added to 15% of 2nd row column_b. Sorry I'm confused myself too. And yes it is in Excel and it will be shown from DataGridView

[ryanjayson]

Are you using dataset? can you post your codes

[jared.geli]

so far all I can do is show the tables from Excel to DataGridView and yes I'm using Dataset in my codes not the item one

 Dim cmd As OleDbCommand = New OleDbCommand("SELECT * FROM [Sheet1$] Order By APM DESC", MyConnection)
        MyConnection.Open()
        Dim adpt = New OleDbDataAdapter(cmd)
        'Here one CommandBuilder object is required.
        'It will automatically generate DeleteCommand,UpdateCommand and InsertCommand for DataAdapter object
        Dim builder As OleDbCommandBuilder = New OleDbCommandBuilder(adpt)
        Dim DtSet2 = New DataSet()
        adpt.Fill(DtSet2, "Sheet1")
        DataGridView1.DataSource = DtSet2.Tables("Sheet1").DefaultView
        MyConnection.Close()