[VBA]I would like to write a programme to find and copy data from the other workbook

J

jovie

Board Regular
Joined
Nov 13, 2015
Messages
68
Hi I am very new of VBA, and I want to write a programme to search keywords and lead to a database I set up, and then copy the data from the worksheet. However I just can't figure the programme. Anyone can help me?
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
You must log in or register to reply here.

Similar threads

T
  • Question Question
How do I write Code for an API key call using Blank Query on legacy Excel/Mac
Replies
1
Views
132
Ron de Bruin
Ron de Bruin
B
  • Solved
VBA Copy Destination:= Finding First Empty cell/row
Replies
8
Views
613
Joe4
Joe4
M
  • Question Question
VBA Code to copy rows by date from one tab to another / repeat based on new date
Replies
3
Views
627
kevin9999
K
A
  • Question Question
Open, Copy data and Close a workbook based on the names of the tabs in my active workbook
Replies
2
Views
465
Aurore87
A
O
  • Question Question
How to sort table with VBA?
Replies
1
Views
158
Fluff
Fluff

Forum statistics

Threads
1,226,735
Messages
6,192,733
Members
453,752
Latest member
Austin2222

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