If I have a formulas that pulls from another excel file

muzzy

Active Member
Joined
Apr 8, 2014
Messages
333
If I have a formulas that pulls from another excel file. Is there a way I can get it to pull the info over using VB so it will only pull the info over when I need it to. I am pulling a roster over but the roster change every day so if I save the excel when I open it the next day that info will change. I need it to only change when I tell it to so then when I open it. will be the same info.

This is what I have for a formula.

Code:
=VLOOKUP(B3,'C:\Reporting\Roster\[Master Roster 05.16.2014(TTY).xls]Combined Roster'!$E$1:$M$65536,2,FALSE)
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
If you want to do it with VBA, then you could create a macro that pulls the values and puts them in the cells. then the cell values will only change if you run the macro.
 
Upvote 0
the line in the macro would be something like:

cells(4,1) = WorksheetFunction.VLOOKUP(B3,'C:\Reporting\Roster\[Master Roster 05.16.2014(TTY).xls]Combined Roster'!$E$1:$M$65536,2,FALSE)

The numbers after cells are the row and column to put the value in. So 4,1 is A4.
 
Upvote 0

Forum statistics

Threads
1,214,920
Messages
6,122,272
Members
449,075
Latest member
staticfluids

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