Powerful find word macro on spreadsheet

[deddy81]

Hi all,

Since i have totally zero knowledge about macro, can someone give me idea of my problem ?
i have one worksheet with many sheet with every sheet contain thousand material price. i want to have macro that every time i run it show dialog box to find/search material name and i type what im looking for and wooosah..it shows every material that contain word that i type that i looking for in the next blank sheet with its price in a row

thanks and sorry for my bad english

[martin_p]

Maybe you don't need macro at all. Are your material lists still growing? Could you merge your data into a single sheet? If it is possible, you can simply use Data > Filter.