Hi,
I have a range of data from A1 to Y6000 with multiple worksheets.
But i would like to just delete the table (in cell range A1 to Y2) in multiple worksheets if the value of this range is Zero without affecting other data between A3 to Y6000.
Appreciate if i can have the vba code to delete the cells in A1 to Y2 if the cells at Row 2 is Zero with Row 1 is the header. Thanks.
Eg as per screenshot below : How to just delete G1, G2, I1 and I2 cells and move H1:H2 to G1:G2 and so on without affecting other data below such as without deleting A5 to K15?.
I have a range of data from A1 to Y6000 with multiple worksheets.
But i would like to just delete the table (in cell range A1 to Y2) in multiple worksheets if the value of this range is Zero without affecting other data between A3 to Y6000.
Appreciate if i can have the vba code to delete the cells in A1 to Y2 if the cells at Row 2 is Zero with Row 1 is the header. Thanks.
Eg as per screenshot below : How to just delete G1, G2, I1 and I2 cells and move H1:H2 to G1:G2 and so on without affecting other data below such as without deleting A5 to K15?.