Need VBA code for Copy+insert / Delete rows & columns by criteria

[lico13]

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

VBA Express Forum

 

[lico13]

Hi,

Still didn't get any response to my thread...

I already found a solution to my first question so I need a solution for the second one only:

Can you please help? I need it urgently.

I need a VBA code solution for add / delete columns by criteria (attached an example Excel file):

When pressing the 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

Here is a link to my post in other forum with the example file that I can't attach here...
VBA Express Forum