Forum Discussion

George Brickfield's avatar
George Brickfield
Copper Contributor
Nov 25, 2017

Hello - trying to create macro to insert rows in a table based on a change in values in the table.

Hello,

 I have a table of data (sample attached) I would like to create macro such that when the value in column A changes (e.g. the date), a row is inserted in the table.  

Thanks

    • George Brickfield's avatar
      George Brickfield
      Copper Contributor

      Id like to insert rows when the data in specific columns change.  e.g. when the date changes Id like to insert row between the last row with date of day1 & first row of day2

Resources