Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Copy and Paste cells if cell contains keyword

0

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.

excel
MS Office Version: 2013
posted by: Daz1983 (rep: 6) on Wed Jul 12, 2017 at 3:53 am
Answer
Discuss

Answers

0
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

posted by: queue (rep: 467) on Wed Jul 12, 2017 at 9:15 am
Discuss


Answer the Question

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