Dear VBA Macro Experts,
Currently I am using a simple insert and delete macro from summary sheet, so when the source sheet, add a new line at the bottom, I'll click the Insert button from summary Sheet then drag from the above row to continue the formula that pick the value from the source sheet (I Attached the link of sample file)
My question is, what the correct VBA Macro that can make Auto insert into Summary sheet when I added new Row from source sheet, the summary sheet will auto insert and including the formula from above the line in the summary sheet (or maybe the Macro including to auto fill from the source)
I just confuse how to create the top and bottom gap to avoid auto insert overlapping (I mean, when I add a new row of the source sheet A, the summary from other source sheet not broken)
Thank you for the attention, Sorry If I can't delivered what I mean correctly since my English is not good enough
Currently I am using a simple insert and delete macro from summary sheet, so when the source sheet, add a new line at the bottom, I'll click the Insert button from summary Sheet then drag from the above row to continue the formula that pick the value from the source sheet (I Attached the link of sample file)
My question is, what the correct VBA Macro that can make Auto insert into Summary sheet when I added new Row from source sheet, the summary sheet will auto insert and including the formula from above the line in the summary sheet (or maybe the Macro including to auto fill from the source)
I just confuse how to create the top and bottom gap to avoid auto insert overlapping (I mean, when I add a new row of the source sheet A, the summary from other source sheet not broken)
Thank you for the attention, Sorry If I can't delivered what I mean correctly since my English is not good enough