Hi,
I have a table which a client is populating with information. The first column contains key information to identify the line of data. The summarized output will be in a second table designed to be more clean and printable than the data input table but the first column needs to correspond to the first column of the data entry table and it needs to autopopulate/update when rows are added or deleted from the input table. Below is a simplified idea of what I am trying to do. Any suggestions on how best to do this? I am fairly new to VBA and tend to use it only as a last resort especially for files that I know people other than myself will be using it and might break it, but if that is the only way I will use VBA.
Input Table
ID1 Input1 Info1
ID2 Input2 Info2
ID3 Input3 Info3
.... ... ...
Output Table
ID1 Output1 Text
ID2 Output2 Text
ID3 Output3 Text
.... ... ...
I have a table which a client is populating with information. The first column contains key information to identify the line of data. The summarized output will be in a second table designed to be more clean and printable than the data input table but the first column needs to correspond to the first column of the data entry table and it needs to autopopulate/update when rows are added or deleted from the input table. Below is a simplified idea of what I am trying to do. Any suggestions on how best to do this? I am fairly new to VBA and tend to use it only as a last resort especially for files that I know people other than myself will be using it and might break it, but if that is the only way I will use VBA.
Input Table
ID1 Input1 Info1
ID2 Input2 Info2
ID3 Input3 Info3
.... ... ...
Output Table
ID1 Output1 Text
ID2 Output2 Text
ID3 Output3 Text
.... ... ...
