| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom function for vlookup
I have a master file which I regularly use to get data by way of vlookup.
Each time I use vlookup, i have to open the master file and type the formula. Is there a short way to get the data without typing full vlookup formula? I thought one option as custom function. Is there any other option? I am doing it may be 80-90times a day, so a shortcut will save lots of time. Pl guide. Regards, Madiya |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Custom function for vlookup
On Saturday, May 12, 2012 3:43:05 PM UTC+5:30, Madiya wrote:
I have a master file which I regularly use to get data by way of vlookup. Each time I use vlookup, i have to open the master file and type the formula. Is there a short way to get the data without typing full vlookup formula? I thought one option as custom function. Is there any other option? I am doing it may be 80-90times a day, so a shortcut will save lots of time. Pl guide. Regards, Madiya Write a custom function in a module in the personal.xlsb file. You can access it from the VB editor. Your function should access your master workbook.. For that you will have to store that in a particular location. Next time you open some file then this custom function will be available to you. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Custom function for vlookup
Thanks for reply.
Is there any other way by way of formulas or using names etc? Regards, Madiya On Saturday, May 12, 2012 7:12:21 PM UTC+5:30, Subrata wrote: On Saturday, May 12, 2012 3:43:05 PM UTC+5:30, Madiya wrote: I have a master file which I regularly use to get data by way of vlookup. Each time I use vlookup, i have to open the master file and type the formula. Is there a short way to get the data without typing full vlookup formula? I thought one option as custom function. Is there any other option? I am doing it may be 80-90times a day, so a shortcut will save lots of time. Pl guide. Regards, Madiya Write a custom function in a module in the personal.xlsb file. You can access it from the VB editor. Your function should access your master workbook. For that you will have to store that in a particular location. Next time you open some file then this custom function will be available to you. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Custom function for vlookup
On Saturday, May 12, 2012 5:13:05 AM UTC-5, Madiya wrote:
I have a master file which I regularly use to get data by way of vlookup. Each time I use vlookup, i have to open the master file and type the formula. Is there a short way to get the data without typing full vlookup formula? I thought one option as custom function. Is there any other option? I am doing it may be 80-90times a day, so a shortcut will save lots of time. Pl guide. Regards, Madiya A bit more detail would be helpful. If the formlula is in the master file and is looking up in a slave file then wouldn't the master file be open??? You may send your file with a slave to dguillett1 @gmail.com if desired. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Custom function for vlookup
Don,
Thanks a ton. I am sending my xl file in mail to you with same subject as this post. Regards, Madiya On Saturday, 12 May 2012 18:00:46 UTC+5:30, Don Guillett wrote: On Saturday, May 12, 2012 5:13:05 AM UTC-5, Madiya wrote: I have a master file which I regularly use to get data by way of vlookup. Each time I use vlookup, i have to open the master file and type the formula. Is there a short way to get the data without typing full vlookup formula? I thought one option as custom function. Is there any other option? I am doing it may be 80-90times a day, so a shortcut will save lots of time. Pl guide. Regards, Madiya A bit more detail would be helpful. If the formlula is in the master file and is looking up in a slave file then wouldn't the master file be open??? You may send your file with a slave to dguillett1 @gmail.com if desired. On Saturday, 12 May 2012 18:00:46 UTC+5:30, Don Guillett wrote: On Saturday, May 12, 2012 5:13:05 AM UTC-5, Madiya wrote: I have a master file which I regularly use to get data by way of vlookup. Each time I use vlookup, i have to open the master file and type the formula. Is there a short way to get the data without typing full vlookup formula? I thought one option as custom function. Is there any other option? I am doing it may be 80-90times a day, so a shortcut will save lots of time. Pl guide. Regards, Madiya A bit more detail would be helpful. If the formlula is in the master file and is looking up in a slave file then wouldn't the master file be open??? You may send your file with a slave to dguillett1 @gmail.com if desired. On Saturday, 12 May 2012 18:00:46 UTC+5:30, Don Guillett wrote: On Saturday, May 12, 2012 5:13:05 AM UTC-5, Madiya wrote: I have a master file which I regularly use to get data by way of vlookup. Each time I use vlookup, i have to open the master file and type the formula. Is there a short way to get the data without typing full vlookup formula? I thought one option as custom function. Is there any other option? I am doing it may be 80-90times a day, so a shortcut will save lots of time. Pl guide. Regards, Madiya A bit more detail would be helpful. If the formlula is in the master file and is looking up in a slave file then wouldn't the master file be open??? You may send your file with a slave to dguillett1 @gmail.com if desired. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Custom function for vlookup
Don,
Thanks a ton. I am sending my both xl files to you on mail with same subject as this post. Regards, Madiya On Saturday, 12 May 2012 15:43:05 UTC+5:30, Madiya wrote: I have a master file which I regularly use to get data by way of vlookup. Each time I use vlookup, i have to open the master file and type the formula. Is there a short way to get the data without typing full vlookup formula? I thought one option as custom function. Is there any other option? I am doing it may be 80-90times a day, so a shortcut will save lots of time. Pl guide. Regards, Madiya |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Custom function for vlookup
On Saturday, May 12, 2012 5:13:05 AM UTC-5, Madiya wrote:
I have a master file which I regularly use to get data by way of vlookup. Each time I use vlookup, i have to open the master file and type the formula. Is there a short way to get the data without typing full vlookup formula? I thought one option as custom function. Is there any other option? I am doing it may be 80-90times a day, so a shortcut will save lots of time. Pl guide. Regards, Madiya Didn't get it. |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Custom function for vlookup
Mail was sent to dguillett1 without " and"
Now again sent to dguillett without " now" Hope you will get it now. Regards, Madiya. |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Custom function for vlookup
On Saturday, May 12, 2012 5:13:05 AM UTC-5, Madiya wrote:
I have a master file which I regularly use to get data by way of vlookup. Each time I use vlookup, i have to open the master file and type the formula. Is there a short way to get the data without typing full vlookup formula? I thought one option as custom function. Is there any other option? I am doing it may be 80-90times a day, so a shortcut will save lots of time. Pl guide. Regards, Madiya NO spaces |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Custom function for vlookup
Yes. sent without spaces.
Is there any other way to provide you both the files? Regards, Madiya |
|
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Custom function for vlookup
On Saturday, May 12, 2012 5:13:05 AM UTC-5, Madiya wrote:
I have a master file which I regularly use to get data by way of vlookup. Each time I use vlookup, i have to open the master file and type the formula. Is there a short way to get the data without typing full vlookup formula? I thought one option as custom function. Is there any other option? I am doing it may be 80-90times a day, so a shortcut will save lots of time. Pl guide. Regards, Madiya This is my email address On Saturday, May 12, 2012 5:13:05 AM UTC-5, Madiya wrote: I have a master file which I regularly use to get data by way of vlookup. Each time I use vlookup, i have to open the master file and type the formula. Is there a short way to get the data without typing full vlookup formula? I thought one option as custom function. Is there any other option? I am doing it may be 80-90times a day, so a shortcut will save lots of time. Pl guide. Regards, Madiya |
|
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Custom function for vlookup
I have sent the mail again.
Pl help. Regards, Madiya On Sunday, May 20, 2012 5:58:04 PM UTC+5:30, Don Guillett wrote: On Saturday, May 12, 2012 5:13:05 AM UTC-5, Madiya wrote: I have a master file which I regularly use to get data by way of vlookup. Each time I use vlookup, i have to open the master file and type the formula. Is there a short way to get the data without typing full vlookup formula? I thought one option as custom function. Is there any other option? I am doing it may be 80-90times a day, so a shortcut will save lots of time. Pl guide. Regards, Madiya This is my email address dguillett1 @gmail.com On Saturday, May 12, 2012 5:13:05 AM UTC-5, Madiya wrote: I have a master file which I regularly use to get data by way of vlookup. Each time I use vlookup, i have to open the master file and type the formula. Is there a short way to get the data without typing full vlookup formula? I thought one option as custom function. Is there any other option? I am doing it may be 80-90times a day, so a shortcut will save lots of time. Pl guide. Regards, Madiya |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom Vlookup Function | Excel Programming | |||
| using vlookup in a custom function | Excel Programming | |||
| Possible -- a custom format on text, similar to a VLOOKUP() function? | Excel Programming | |||
| Custom function to simplify vlookup formula | Excel Programming | |||
| Custom Function VLookup | Excel Discussion (Misc queries) | |||
Hybrid Mode
