Auto populating a key column in an output table based on a column from an input table


New Member
Oct 29, 2013

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
.... ... ...

Forum statistics

Latest member

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...