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