I have a 6 Column Table
With the First Column a automatic numbering format
So the first column farthest to the left is 4.1.1, 4.1.2, 4.1.3, ect ect
And the second column (Second from the left) is formatted such as "Ensure SXXXXX" (Where X is a number 1-9999)
I want to write a macro where if there is a value of "Ensure S" then add a Grey colored Merged Row spanning all 6 columns with the Value of "Step SXXXXX"
Is this possible?
Image attached
This is what I want the macro to do... Im ok at excel vba but I have no idea what to do here
|