Add macro to run clear sheet

[Geoff.D]

Hi All,

I am looking to have the macro adjusted on the Inventory Pick List sheet with the clear pick list button to only clear the list with an N in Column Q titled Backorder.

When you click the clear list button it clears the whole sheet. (This is what the button is meant to do).
This is an Excel template so I'm not a 100% where the visual basic sheet is.

I have attached the workbook.

Thanks in advance Geoff.

[JieJenn]

Not a big fan of Excel table, but if you press Alt + F11 keys together, the VBA window editor should show up and from there you can revise the VBA code.

Give this VBA code a try

Please Login or Register  to view this content.

[Geoff.D]

Awesome works perfectly!!!!