copying rows

[ks6035]

Hi,
I have a large spreadsheet and sheet1 has several hundred rows that we are constantly adding to, I'm looking for a formula that if in column "J" we reference a specific word, it will automatically copy the entire row to Sheet2 in the same format.
I have searched several options and many of them show that I would need to use a script, if that's the case I'm hoping someone could give me a few step by step instructions on how to do this in the developer tab.
Thank you,
Kate

[mehmetcik]

Hi

The attached file has a sheet specific macro.

select sheet1.
Right click on the sheet name at the bottom of excel and select view code.

Please Login or Register  to view this content.

[newdoverman]

Here is a possible solution to copy rows that have a certain word in column J to Sheet2.

[ks6035]

Hi!
Thank you, that seemed to work, but when I tried to convert it into my usage it stopped working, I've attached a sample of my spreadsheet because I can't seem to set up the formulas you had to work in my set up. In the "Filed Under" category when it says KLT the entire row would move to Sheet2 -
Thank you!

Applicants Copy.xlsm

[newdoverman]

This is the converted version to your worksheet.