Copying rows with specific text in cell K2

Hi!

I have this 2 sheets, 1 sheet with raw data (Sheet1) and another sheet is called Downtime. I'm trying to alter the code below but I got an error. This code should act as what Filter function would do, yet I'm not allowed to do Filter in this sheet hence I'm trying to build this code.

The code should do:
1. Detect specified text by user in Downtime sheet, in cell K2 (a drop-down list)
2. From the text selected, code will go through column A in Sheet1 to find the text
3. The code will then have to copy rows of column A which has the text, until column G
4. The data will then be pasted to the same column but starting from row 2

Please Login or Register  to view this content.

Can someone help me to alter my code? Thanks in advance!

Hi, all

Here's an example of the file. The raw data or Sheet1 will have data up to 1000++ rows.

Originally Posted by sintek

Pasted to which sheet...always overwriting row 2 or below old copied info

Always overwriting row2, meaning every time the option from the dropdown list is selected, and the code runs, the page will change its data.

P/s: I could not do filter as it will affect my other program, which is to copy paste table from Excel to PowerPoint slides.

Found the real culprit. Thanks a lot, Sintek. You helped me a lot today