Adding contents of two tables

JLR · #1 (**permalink**) 05-24-11, 03:58

I wish to use VBA to add the data from one table (C3:AK18 in Sheet1) to the data of another table (C3:AK18 in Sheet2). Both tables just contain numbers and the tables are obviously the same size. How do you create a button so that when it is clicked the data from the first table is automatically added to the data in the second table? I am a beginner when it comes to VBA.

Colin Legg · #2 (**permalink**) 05-24-11, 11:03

Hi,

Just to be clear, which of these results do you want?
Table 1 (example)

Code:

1    1
2    3

Table 2 (example)

Code:

0    1
2    3

Result (A) - Table 2

Code:

1    2
4    6

Result (B) - Table 2

Code:

JLR · #3 (**permalink**) 05-24-11, 11:09

I am hoping for the result you have called (A), thank you.

Colin Legg · #4 (**permalink**) 05-24-11, 14:35

Here's one way of many:

Code:

Sub Button1_Click()
 
    Sheet2.Range("TableB").Value = [Sheet1!TableA + Sheet2!TableB]
 
End Sub

JLR · #5 (**permalink**) 05-24-11, 14:45

Thank you, Colin.

Internet Services

Web Development

Digital Marketing

Consumer Tech