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

Haytham Amairah

Silver Contributor

Nov 25, 2017

Kindly clarify what's your goal is?

Where you want to insert that row?

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.