I'm looking for help on creating a vba code to look up a value based on a cell on another sheet then clear certain cells from that row. Below is an example.
I would like to type a value in cell (A2) in the 'Find" worksheet. Then run VBA code that would search column A of the "Yards" worksheet for that value and then clear the contents of cells A through E only of that row. Each value in column A would be unique.
Many thanks.
I would like to type a value in cell (A2) in the 'Find" worksheet. Then run VBA code that would search column A of the "Yards" worksheet for that value and then clear the contents of cells A through E only of that row. Each value in column A would be unique.
Many thanks.