RickFreeson
New Member
- Joined
- Jan 23, 2018
- Messages
- 1
I have a situation that I cannot find an answer to no matter how hard I search. So I am turning to you good people. 
I have data that is appended as new rows to a table. Because of other technicalities, this data comes in jumbled and out of order.
Is it possible to have this table automatically update another table where I have the layout the way I need for the rest of the workbook to work?
Data in:
Table1
Cat1 Cat2 Cat3 Cat4 (Header)
abc cbd hij lmn (data)
Copied to the correct places in table2 automatically:
Table2
Cat1 Cat1a Cat1b Cat2 Cat3 Cat3a Cat3b Cat4 (Header)
abc 123 456 cbd hij 789 123 lmn (data)
Can a table feed another table on a different worksheet?
Thanks in advance.
Rick

I have data that is appended as new rows to a table. Because of other technicalities, this data comes in jumbled and out of order.
Is it possible to have this table automatically update another table where I have the layout the way I need for the rest of the workbook to work?
Data in:
Table1
Cat1 Cat2 Cat3 Cat4 (Header)
abc cbd hij lmn (data)
Copied to the correct places in table2 automatically:
Table2
Cat1 Cat1a Cat1b Cat2 Cat3 Cat3a Cat3b Cat4 (Header)
abc 123 456 cbd hij 789 123 lmn (data)
Can a table feed another table on a different worksheet?
Thanks in advance.
Rick