Hi ! New here and looking for a little assistance if possible.
I have a spreadsheet and I'm trying to record / create a macro. I basically want to search a column (D) in a worksheet for a value (eg."gh76589") then copy that entire row to a new worksheet.
Ideally, I'd then like to be able to repeat that process for different values up to around 20 times - each time copying the entire row to the next available line on the new worksheet.
Am I asking too much or can anyone help ?
Thanks in advance.