Hi.
I'm an extreme novice at VBA, so any help would be greatly appreciated.
I have a workbook containing 50 sheets of data for my friend's business. She just told me that certain items are not available on certain configurations.
Essentially, items with an Interior of GUS or 3R (column G) are only available if the Configuration (Column I) is = to Double Panel.
Therefore, I search the data in a given range. If Column G = GUS or 3R and Column I is not equal to Double, then I need to clear the data from the cells (for example in the sample sheet that I'm attaching, A26:M26) and shift the cells underneath up.
I can't shift the entire row up because I have information in other columns to the right that I need to stay in place.
Is this possible with a Macro? If not, at a minimum, would a nested if formula work to clear the data from columns L & M and then I can manually move the cells up?
Thanks in advance for any suggestions. See attached example.
Bookmarks