Hi,

I have 2 tables. Table 1 "in" is in sheet 1 and Table 2 "out" is in sheet 2. I want to create month wise and personwise in and out details.
Pls let me know how i can combine this in and out in a single chart for easy representation.

Table 1 In Jul aug sep
Person1 10 10 10
Person2 20 20 20
Person3 30 30 30

Table 2 Out Jul aug sep
Person1 7 8 9
Person2 12 16 19
Person3 24 26 27

Note

Person and month will be common in bothe tables only count varies across months