lico13
12-18-2016, 01:19 AM
Hi,
Can you please help? I need it urgently.
I need a VBA code solution for copy+insert / delete rows & columns by criteria (attached an example Excel file):
When type "1" in column A next to a certain row and press the macro button, row 8 (the example row) will be copied entirely and
INSERTED above the selected row.
When type "0" in column A next to the selected row and press the macro button, the selected row will be entirely deleted.
If it's OK, I would like to add another request:
When pressing the 2nd macro button, 3 columns with previous month dates will be deleted entirely (at the left)
and at the same time 3 columns with new month dates will be added with all formulas in them (at the right).
*** Note that I need these 2 macros for multiple sheets with identical table structure so I think it will be best to write the codes just once and put macro buttons to the same macros.
Thanks in advance :)
Can you please help? I need it urgently.
I need a VBA code solution for copy+insert / delete rows & columns by criteria (attached an example Excel file):
When type "1" in column A next to a certain row and press the macro button, row 8 (the example row) will be copied entirely and
INSERTED above the selected row.
When type "0" in column A next to the selected row and press the macro button, the selected row will be entirely deleted.
If it's OK, I would like to add another request:
When pressing the 2nd macro button, 3 columns with previous month dates will be deleted entirely (at the left)
and at the same time 3 columns with new month dates will be added with all formulas in them (at the right).
*** Note that I need these 2 macros for multiple sheets with identical table structure so I think it will be best to write the codes just once and put macro buttons to the same macros.
Thanks in advance :)