Good Afternoon All This is my first post on the forum so please excuse me if my descriptions are not exact in the beginning!
I have a table with 4 columns. I need to write code that will set off changes to columns 2,3 & 4 when data in column 1 is changed and this must work by row i.e. only to make these changes to row 1 when the data in the cell in column 1 row 1 is changed but I need the code to work in every row of the table without having to write separate code for each line. I think loop function may be the answer but I'm having trouble identifying the right vba code to reference the cells in the table the way I want and then applying the right loop function. My table is dynamic in rows and not columns but guessing loop function takes this into account.
I have spent a great deal of time researching this but can't seem to get the start I need so any help will be very much appreciated.
Thanks in advance G