pull info from another workbook using VBA

R

rcirone

Active Member
Joined
Mar 12, 2009
Messages
483
Office Version
  1. 365
Platform
  1. Windows
myworkbook tab (roster) c2:p2 down to c2000:p2000 I am trying to do a VBA to a button that I can click and it will put all the info I need from another workbook called (Master Roster) tab current roster con and from tab current Roster ORL. to myworkbook tab roster from c2:p2 on down. I am using excel 2007
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
You must log in or register to reply here.

Similar threads

B
  • Question
Copy a specific Worksheet from multiple Workbooks into one Workbook - one Worksheet
2
Replies
12
Views
1K
Logit
Logit
I
  • Question
Search for a tab in a Master workbook from another workbook, if it exists then skip it and if not, create or replace.
Replies
3
Views
202
ima2015
I
D
  • Solved
VBA Macro to consolidate all info on only selected tabs
Replies
2
Views
310
Dilligas915
D
K
  • Question
Need to create/source a macro/vba/program that auto populates info based on matching word criteria for community support agency
Replies
3
Views
456
Micron
M
V
  • Question
Looking to pull rows from one master sheet to another that will update both when information entered into the master
Replies
6
Views
900
Vertigobubba
V

Forum statistics

Threads
1,215,006
Messages
6,122,666
Members
449,091
Latest member
peppernaut

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