Copy and Paste cells if cell contains keyword

Hi Daz_1983

Difficult without your scenario.....This might give you an idea...
If not, upload a sample workbook so that we can see what you are referring to....Actually in future make a point to always upload a sample workbook depicting a before/after scenario expected.

Please Login or Register  to view this content.

Here is the workbook that contains everything.
I have Put what I want to happen in red. The file manager sheet is where I want the data to come from.

Alrighty then.....
Lesson 1 and the most important lesson ever......never merge cells....It wreaks havoc....
the above code will work perfectly for you....I suggest re designing your Sheet1 without merged cells and we'll take it from there...


edited....But....If you really don't want to use this...

Please Login or Register  to view this content.

According to your new upload the Ranges to populate are no longer C21 & P21... it is F21 & G21
See attached amended.

Really...I suggest redesigning...No merging...No Column hides etc etc etc

Edited....Also...You have hundreds of page breaks which slows your workbook down....Corrected...See upload

as the data base its searching is constantly growing

The Dropdown will always have all available from database....No matter how big

results need to start from the next available row and continue without any gaps.

what do you mean by this...

and pasted to the "search" worksheet, file names in Column C starting at C21 and Hyperlinks in column P staring at P21

As per your requirement in initial post....
do you want the first search to be in Row 17 then the next row 18 etc etc etc


This code will solve ......Providing that all the cells till F16 are populated... Why not upload a file close to the exact file so that we can create the correct code cause thus far you have uploaded 2 diff files with different scenarios...And this will not allow us to assist correctly!!!!

Please Login or Register  to view this content.