If I have a formulas that pulls from another excel file

[muzzy]

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.

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

 

[par60056]

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.

 

[muzzy]

So I can use that code as a VBA??

 

[par60056]

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.