Hi All,
I have 1 master sheet in which I need to apply vlookup function in multiple sheets and from 3 different files(All files are located in same folder).
Below are the headings for which I am applying vlookup function :-
3G 'TRANS_TYPEIP to IP Swap StatusIntervention DateIP to IP commentIP Operation Status
1) Master file name: IP to IP swap Master File
2) File from which I need to apply lookup are :-
i) 3G_network_info : sheet name "3G_network_info" column reference : "U"
ii) IP to IP swap - followup file : sheet Name="Sheet1" Column reference : "AE" , "G", "AF"
iii) IP Operation : Sheet name ="3G Planning" Column reference : "I"
if anyone can suggest a VBA macro solution ?, currently every time I need to open the master file and applying the same vlookup function in multiple sheets from multiple workbooks.
I am attaching the sample file too.
https://onedrive.live.com/redir?resid=393CD98CEE2A349F!140&authkey=!AODnLDb1RVeliUs&ithint=file,xlsb
Thanks in advance for your valuable suggestions and feedback.
Regards,
Rajender
I have 1 master sheet in which I need to apply vlookup function in multiple sheets and from 3 different files(All files are located in same folder).
Below are the headings for which I am applying vlookup function :-
3G 'TRANS_TYPEIP to IP Swap StatusIntervention DateIP to IP commentIP Operation Status
1) Master file name: IP to IP swap Master File
2) File from which I need to apply lookup are :-
i) 3G_network_info : sheet name "3G_network_info" column reference : "U"
ii) IP to IP swap - followup file : sheet Name="Sheet1" Column reference : "AE" , "G", "AF"
iii) IP Operation : Sheet name ="3G Planning" Column reference : "I"
if anyone can suggest a VBA macro solution ?, currently every time I need to open the master file and applying the same vlookup function in multiple sheets from multiple workbooks.
I am attaching the sample file too.
https://onedrive.live.com/redir?resid=393CD98CEE2A349F!140&authkey=!AODnLDb1RVeliUs&ithint=file,xlsb
Thanks in advance for your valuable suggestions and feedback.
Regards,
Rajender