PDA

View Full Version : VBA code to Copy/Insert + Delete rows by criteria



lico13
12-15-2016, 12:49 AM
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
12-16-2016, 06:57 AM
Welcome to the forum! See my solution at your cross-post: http://www.excelforum.com/showthread.php?t=1166826

lico13
12-17-2016, 02:48 PM
Thanks!