Hi,
I need help with reference to the below query.
I have one master data with almost 2L lines and it has multiple fields in it. below are the key things I am looking into.
1. linking the exls to access data base which will enable me to update the access on real time basis.
2. create report from the access by looking up between different exls files.. for example:- I have a field called LE in the master file and LE name in another exls file, now I want the name of the LE to be vlookup in access and produce final out put with LE name in access ( if I do this in exls directly my system hanging due to large data and multiple formulas). like this I have multiple files with multiple lookups.
Thanks and regards,
M.Mahesh
I need help with reference to the below query.
I have one master data with almost 2L lines and it has multiple fields in it. below are the key things I am looking into.
1. linking the exls to access data base which will enable me to update the access on real time basis.
2. create report from the access by looking up between different exls files.. for example:- I have a field called LE in the master file and LE name in another exls file, now I want the name of the LE to be vlookup in access and produce final out put with LE name in access ( if I do this in exls directly my system hanging due to large data and multiple formulas). like this I have multiple files with multiple lookups.
Thanks and regards,
M.Mahesh