Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merging two tables
Hi, I've got following problem:
I have to tables, one is copy of another one. aa ab ac ad ba bb bc bd ca cb cc cd da db dc dd I'm looping for each cell in table A and table B and summing up their values: For Each cellA In os.Cells For Each cellb In os.Cells result = cell.Value + cellb.Value ' address of cellResult cellResult.Value = wynik Next Next I don't know how to write a statement, which would create the table with results (moved cellResult address accordingly). In example given above i'll get 256 result, in real I'll have tables 11x11. Anyone helps? TIA Przemek |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging cells in Pivot tables | Excel Discussion (Misc queries) | |||
Merging data into pivot tables | Excel Discussion (Misc queries) | |||
Merging of pivot tables | Charts and Charting in Excel | |||
Merging 2 different pivot tables | Excel Worksheet Functions | |||
merging multiple pivot tables | Excel Worksheet Functions |