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 :)
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 :)