VBA - Vlookup returning entire column

[Bradzo]

Hi, please help I’m stuck. I have been trying to write this with no success.
I have two worksheets that I’m working from; Sheet1 will have a shop order reference number in cell C4. I would like to search Sheet2 Column C for the corresponding Shop order then proceed to copy the shop order and all other shop orders underneath in column C to Sheet1 starting at C7.
Help will be greatly appreciated, thanks Brad.

 

[gallen]

Hi Brad you give almost no info. What code do you have and what exactly happens now, and what exactly do you need to happen? Does the macro run on a button press or on the change event?