I have the following data and would like some VBA Code to run down the Rows and based on the number in Column D, Delete the Cells (and Shift Data to the Left) in Columns E to I based on the number in Column D. For example,
In Row 1, to delete Cells F1:I1, as the value is 1; Value retained = "Item1"
In Row 2, to delete Cells in E2 then Cells F2:I2; Value retained = "Item2"
In Row 3, to delete Cells in E3:F3 then Cells F3:I3; Value retained = "Item3"
In Row 4, to delete Cells in F4:I4; and so on ... Value retained = "Item1"
At the end I want only one of the items in Columns E:I in each of the Rows, with the number oin Column D determining which of the Columns Data is retained.
Max number of Columns holding data to be retained is 5, hence looking in Columns E:I, although this may be a variable.
Any assistance is much appreciated.
Thanks
Allen
-- removed inline image ---
<colgroup><col><col><col><col><col span="5"></colgroup><tbody>
</tbody>
In Row 1, to delete Cells F1:I1, as the value is 1; Value retained = "Item1"
In Row 2, to delete Cells in E2 then Cells F2:I2; Value retained = "Item2"
In Row 3, to delete Cells in E3:F3 then Cells F3:I3; Value retained = "Item3"
In Row 4, to delete Cells in F4:I4; and so on ... Value retained = "Item1"
At the end I want only one of the items in Columns E:I in each of the Rows, with the number oin Column D determining which of the Columns Data is retained.
Max number of Columns holding data to be retained is 5, hence looking in Columns E:I, although this may be a variable.
Any assistance is much appreciated.
Thanks
Allen
-- removed inline image ---
<colgroup><col><col><col><col><col span="5"></colgroup><tbody>
</tbody>
