Hi all,
My code below allows me to enter active cell contents to D3 (which I use for search/lookup) but I believe there's a lot of repetition and takes 8 seconds to process. Is there a way to paste clicked cell value straight to cell D3?
Also, I want to amend the range from B37:B1000 to the...