Alter Code to Copy & Paste from a Drop down listl to a Specified Range

Hello All,

Tried altering this Code to do the following but my knowledge is still limited with VBA so could someone give me a hand and alter this code to:

Look at the Combined Data Tab in Column "C: for a specific Word that will be located on Sheet1 Cell "C20" then "copy & paste" including all Source Font to Sheet1 starting at A23

Please Login or Register  to view this content.

Thanks Again
Aeneren

AlphaFrog,

Thanks for your reply but i forgot to mention there is already code present and i think what i have and yours are causing an error ??

This is the WB i have been using for the testing


Aeneren

Ok, got the following code to work, Had to change couple things but it does work now.

It looks at Cell "B42" and pulls all Lines from "Combined Data" with the Key word from "B42"

It Pastes the information onto "Main Gear" starting in Cell "B44"

Now the Problem the Main Gear Tab is set up little different and im wondering if there is a way to skip a Column when it paste onto Main Gear

So paste in Column B, D:R (skiping Column "C")or
Clear the contents from "C44" and the Column "C" information it just pasted, and as the information it copy's could be 2 lines or 20 plus some how know how far to clear down.

Please Login or Register  to view this content.

Aeneren

AlphaFrog,

Thank you, works like a charm

Reputation Added

Aeneren