I am trying to create a history table that appends new data lines when specific data from my MySQL query changes. I have 7 values on one line that are being updated from a MySQL database in columns A-G. Header in row one and values in row 2. When Column C changes, I would like the values in row 2 to be appended to the history data in columns A to G starting at line 6 and appending a line below that anytime C2 changes, So it should do it automatically based on when the data in cell C2 changes, not require me to push a button to copy the data down because it needs to do this 24/7 so that we can look at it to see what time the values changed.
I thought the hard part would be getting the data from MySQL into my worksheet, but that turned out to be fairly easy (Considering I just started learning MySQL). I haven't been able to copy the values down automatically as static values in my history table.
Any help would be appreciated.
I thought the hard part would be getting the data from MySQL into my worksheet, but that turned out to be fairly easy (Considering I just started learning MySQL). I haven't been able to copy the values down automatically as static values in my history table.
Any help would be appreciated.