VBA - Vlookup returning entire column

B

Bradzo

New Member
Joined
Nov 15, 2017
Messages
11
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.
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
Sort by date Sort by votes
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?
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question Question
VBA code to determine InDesign Layout
Replies
6
Views
442
Akuini
Akuini
J
  • Solved
Something New or Something Old
Replies
3
Views
137
Fluff
Fluff
E
  • Solved
Performance issue using a combination of dropdowns & lookups
Replies
9
Views
616
Akuini
Akuini
U
  • Question Question
When a value is detected in a cell, a VBA code or function will insert a new row with specific values and functions already in each cell
Replies
0
Views
323
ubergreen
U
E
  • Question Question
Update Item Description Based On Accessories Ordered With It
Replies
1
Views
240
SanjayGMusafir
SanjayGMusafir

Forum statistics

Threads
1,223,900
Messages
6,175,276
Members
452,629
Latest member
SahilPolekar

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top