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

 

[Joe4]

Re-posted here: http://www.mrexcel.com/forum/excel-...delete-rows-columns-criteria.html#post4709031

In the future, please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #12 here: Forum Rules).

If you do not receive any replies within 24 hours, you are allowed to "bump" your post back up to the top by replying back it yourself.