Forum Discussion
George Brickfield
Nov 25, 2017Copper Contributor
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
- Haytham AmairahSilver Contributor
Kindly clarify what's your goal is?
Where you want to insert that row?
- George BrickfieldCopper 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
- Haytham AmairahSilver Contributor
Do you want it like this?