L
Legacy 447442
Guest
Hello all,
I am looking to automate a repetitive process, i have tried multiple times to get something to work with no success.
Problem:
I would like to automate the process of copying any rows from multiple worksheets that contain the word "ESCALATED" in a column into a new Worksheet named "Escalated".
Workbook Setup:
I have a Workbook that has worksheets named the days of the week.
The worksheets have multiple Columns with headings in Row 5.
The first Row that contains the data that i wish it to search from is in Row 6.
The term "ESCALATED" will only appear in Column "E"
End Result:
The term i wish it to search for is "ESCALATED" that will only appear in column "E" on multiple worksheets.
I then want the rows that contain the term "ESCALATED" in Column "E" to be copied to the worksheet named "Escalated"
I am looking to automate a repetitive process, i have tried multiple times to get something to work with no success.
Problem:
I would like to automate the process of copying any rows from multiple worksheets that contain the word "ESCALATED" in a column into a new Worksheet named "Escalated".
Workbook Setup:
I have a Workbook that has worksheets named the days of the week.
The worksheets have multiple Columns with headings in Row 5.
The first Row that contains the data that i wish it to search from is in Row 6.
The term "ESCALATED" will only appear in Column "E"
End Result:
The term i wish it to search for is "ESCALATED" that will only appear in column "E" on multiple worksheets.
I then want the rows that contain the term "ESCALATED" in Column "E" to be copied to the worksheet named "Escalated"
