Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding data to one olumn to another
I have two columns of data column a is always the same coloum b get
filled out every week with numerical data for instance data1 10 data2 9 data3 6 data4 4 at the end of the week i want to add the totals in column b to another sheet but every time add the current weeks data to that what has already been done i.e running total data1 23 data2 78 data3 56 anyone got any ideas this is stumping me Johny |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding data to one olumn to another
For i = 2 To Cells(Rows.Count,"A").End(xlUp).Row
FindRow=0 On Error Resume Next FindRow = Application.Match(Cellws(i,"A").Value On Error Goto 0 If FindRow = 0 Then FindRow = Worksheets("Sheet2").Range("A1").End(xlDown).Row + 1 Worksheets(("Sheet2").Cells(FindRow,"A").Value = Cells(i, "A").Value End If Worksheets(("Sheet2").Cells(FindRow,"B").Value = _ Worksheets(("Sheet2").Cells(FindRow,"B").Value + Cells(i, "B").Value Next i -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) wrote in message ... I have two columns of data column a is always the same coloum b get filled out every week with numerical data for instance data1 10 data2 9 data3 6 data4 4 at the end of the week i want to add the totals in column b to another sheet but every time add the current weeks data to that what has already been done i.e running total data1 23 data2 78 data3 56 anyone got any ideas this is stumping me Johny |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding multiple data fields from time based data. | Excel Discussion (Misc queries) | |||
Adding data to existing data that has a unique number in column | Excel Discussion (Misc queries) | |||
adding data to existing data and replacing old one in excel? | Excel Programming | |||
Adding data to celss but keeping the remaining data intact. | Excel Discussion (Misc queries) | |||
Importing data, then adding data to the new spreadsheet.. a conund | Excel Discussion (Misc queries) |