VBA code to Copy/Insert + Delete rows by criteria

[lico13]

Hi,

I need your help in writing VBA codes that will enable adding/deleting rows to an Excel table full with records and formulas, by simple criterias:

1) Adding row - Copy entire row (the model row) with formulas that is located in a constant row (row 8) and insert this paste row to a new selected row. The insertion place of the paste row will be set by typing '1' in column A next to the destination row.

2) Deleting row - Deleting a selected row by indicating '0' in column A next to the row that need to be deleted.

Will be glad to have simple as possible codes since my knowledge in VBA is poor...

Thanks in advance

[Kenneth Hobs]

Welcome to the forum! See my solution at your cross-post: http://www.excelforum.com/showthread.php?t=1166826

[lico13]

Thanks!