Delete data leave data macro.

  • Morning.

    Is this feasible? After I have posted my data into the spreadsheet . To have a macro run that deletes all lines of data that are not specified references. The references would be in a single column. E.G. customer codes. I only want the data to so with these refs and want the rest deleted. All lines. Then refresh the spreadsheet.

    I have tried the basic recording of macros and researched online but it seems to be a unique request.

    any guidanceor help is appreciated thanks

  • It would be easier to help if you could attach a copy of your file with a detailed explanation of what you want to do using a few examples from your data and referring to specific cells and worksheets.

    You can say "THANK YOU" for help received by clicking the "Like" icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!