Hello. I am new to VBA and hope someone can help. I have searched many threads and can't find exactly what I need. I have two workbooks and I need:
- to search the second workbook for a specific line of text (ex. Total) in column F - it could be anywhere from rows 25 to 300.
- once it finds the correct row with 'Total', copy rows 9 to 18 from the first workbook then
- paste rows 9-18 in the second workbook three rows below 'Total'.
Thank you in advance for any assistance.
- to search the second workbook for a specific line of text (ex. Total) in column F - it could be anywhere from rows 25 to 300.
- once it finds the correct row with 'Total', copy rows 9 to 18 from the first workbook then
- paste rows 9-18 in the second workbook three rows below 'Total'.
Thank you in advance for any assistance.