ShawnMichael
06-11-2014, 10:10 AM
Hi there !
Hope you all fine :) Trying to get my head around but couldn't figure it out :(
Well, I have 2 tables, Table 1 and Table 2, which are updated regularly.
Table 1
Date
Present
Class
Teacher
01/01/2014
1
General Science
John Little
Table 2
Date
Present
Class
Teacher
01/01/2014
2
Political Science
Armanda Smith
After every class, both tables are updated by adding a new row. Now I need a Table 3, which will auto-update and combine the data from both tables like this:
Table 3
Date
Present
Class
Teacher
01/01/2014
1
General Science
John Little
01/01/2014
2
Political Science
Armanda Smith
If we add new row to either table (T1 orT2), rows in T3 will be updated and take the data from those tables and add to the existing data in T3 in the next empty row, either using formulas or VBA.
I hope I have explained it well and I would appreciate your help in this regard.
Regards
Hope you all fine :) Trying to get my head around but couldn't figure it out :(
Well, I have 2 tables, Table 1 and Table 2, which are updated regularly.
Table 1
Date
Present
Class
Teacher
01/01/2014
1
General Science
John Little
Table 2
Date
Present
Class
Teacher
01/01/2014
2
Political Science
Armanda Smith
After every class, both tables are updated by adding a new row. Now I need a Table 3, which will auto-update and combine the data from both tables like this:
Table 3
Date
Present
Class
Teacher
01/01/2014
1
General Science
John Little
01/01/2014
2
Political Science
Armanda Smith
If we add new row to either table (T1 orT2), rows in T3 will be updated and take the data from those tables and add to the existing data in T3 in the next empty row, either using formulas or VBA.
I hope I have explained it well and I would appreciate your help in this regard.
Regards