Copy and Paste cells if cell contains keyword


Hi all,

Need some help with a VBA copy and paste question

Currently i have file names in column C starting at C14 and hyperlinks associated with the file in Column H starting at H14 in worksheet "File Manager"

I want to be able to place a key word in sheet "Search" in cell B14 that when a search command button is clicked on the "search" sheet, it searches for file names in "file manager" column C starting at C14 containing the keyword and all files along with associated hyper links are copied and pasted to the "search" worksheet, file names in Column C starting at C21 and Hyperlinks in column P staring at P21

Any help would be much appriciated.



Selected Answer

you may be able to perform task without vba by using Data Filter then putting your text in the search.  Sometimes simple can work....I'm not sure of your exact situation, but give it a try


Answer the Question

You must create an account to use the forum. Create an Account or Login