oam
10-30-2017, 08:37 PM
I need a good way to delete a row after I do a search and find a tracking number in a column.
I have made a “Summary” worksheet where I can search for tracking numbers from the main data sheet containing over 20000 records. I enter the tracking number into a search formula on the Summary sheet and it finds the line number of the tracking number on the MainData sheet and it returns the row number. I need a way to take that row number or some other way to delete the entire row on the MainData sheet that tracking number is on.
Does anyone know of a way I can do this?
Thank you for any and all help.
I have made a “Summary” worksheet where I can search for tracking numbers from the main data sheet containing over 20000 records. I enter the tracking number into a search formula on the Summary sheet and it finds the line number of the tracking number on the MainData sheet and it returns the row number. I need a way to take that row number or some other way to delete the entire row on the MainData sheet that tracking number is on.
Does anyone know of a way I can do this?
Thank you for any and all help.