Forum Discussion

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

format test 1.xlsx11 KB

Macros & VBA

Need Help Maro

George Brickfield

Copper Contributor

Nov 26, 2017

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 Amairah

Silver Contributor

Nov 26, 2017

Do you want it like this?

George Brickfield
Copper Contributor
Dec 03, 2017
Yes - exactly - thanks
- Haytham Amairah
  Silver Contributor
  Dec 04, 2017
  To automate this strange task we need a code associated with an event so that the code does not trigger unless a certain range of cells is changed!
  
  To my knowledge, an event of this kind is not found in Visual Basic for Applications (VBA) which is the Excel scripting language.
  
  I don't think I can help you.
  Sorry about that.
  
  However, you can ask some VBA experts such as:
  
  https://www.youtube.com/channel/UCXbicpVq_ALWG4ijPKsR7ZQ
  
  https://www.youtube.com/user/ExcelCampus/featured
  
  http://spreadsheetpage.com/
  
  Someone might be able to help you in some way.