How to perform a Vlookup from a closed workbook in Excel using VBA. More details including VBA code available at this link: www.exceltrainingvideos.com/h...
Hi Sir, I've posted one question few months back. I haven't got a resolution yet. It would be great help if you could help me on that. I wanted to take screen shot of a userform before submitting the data and paste it on outlook 2016 mail body. Thanks in advance.
Sir, I want to use this method for invoicing to get description and prices for items from closed workbook but I am also getting N/A# for those items not included in my closed workbook. how to remove N/A# error here?
@@Exceltrainingvideos thank you. But this is not VBA, this is VBA creating a formula into a cell. I mean is there a way to use only VBA to put a value into a cell in this workbook. The value is found in a closed workbook with a specific search option, maybe like match.
@@ValmisFilm These VBA tutorials will guide: www.exceltrainingvideos.com/get-value-from-closed-workbook-with-vba/ www.exceltrainingvideos.com/how-to-perform-vlookup-from-closed-workbook/
@@Exceltrainingvideos Thank you. But that also is VBA to create a formula into a cell. I mean is there no way to use VBA only to extract data from a closed workbook? At this point yes, I am doing the same thing, I am adding formulas to cells to get data from closed workbooks. Which feels kind of a stupid thing to do... but there seems to be no other way.
Great sir but I have one Question if I want to get multiple value from closed workbook of one value Ex.suppose A200 this value have many match in closed work book Such as A200 have two results like Mouse Keyboard
@@Exceltrainingvideos sir i refer for look up value "b3" . This cell value also name of the close workbook . I want when i change "b3" value then vlookup those workbook every time dynemicly . My closed workbook destination folder same . I use indirect function with vlookup but only work when file open.
Hi Sir,
I've posted one question few months back. I haven't got a resolution yet. It would be great help if you could help me on that.
I wanted to take screen shot of a userform before submitting the data and paste it on outlook 2016 mail body.
Thanks in advance.
Thank you very much. This got me.past a sticking point in my usage. Much appreciated!
Glad it helped!
Excellent procedure. Thank you!
Glad it was helpful!
Useful sir.. Thanks.
How can I do a dynamic countifs or sumifs from closed workbooks?
what is i do not want a range, i want to look up the whole sheet in the other spreadsheet. The range is dynamic?
Hi Sir, how do I have a dynamic range instead?
thanks for your info but there is no table so its works. if there is some tables how it works?
Here is an example to guide: www.exceltrainingvideos.com/inventory-management-using-tables-in-single-excel-sheet/
Sir, I want to use this method for invoicing to get description and prices for items from closed workbook but I am also getting N/A# for those items not included in my closed workbook. how to remove N/A# error here?
Can you share the code here?
@@Exceltrainingvideos Sir, Any Solution?
hi, can you explain the R2C1 : R2C10 means?
R2C1 = Row 2 Column 1 = Range("A2")
R2C10= Row 2 Column 10 = Range("J2")
R2C1:R2C10=Range("A2:J2")
I did exactly the same. It does not work. The error message is "Autofill method of range class failed". Have you tested your code?
cool! But can you do this with VBA formulas? In this example, you create a formula into a cell. But can I use VBA only to get a result into some cell?
This VBA tutorial in MS Excel will guide: www.exceltrainingvideos.com/using-vlookup-with-indirect-function-in-vba/
@@Exceltrainingvideos thank you. But this is not VBA, this is VBA creating a formula into a cell. I mean is there a way to use only VBA to put a value into a cell in this workbook. The value is found in a closed workbook with a specific search option, maybe like match.
@@ValmisFilm These VBA tutorials will guide: www.exceltrainingvideos.com/get-value-from-closed-workbook-with-vba/
www.exceltrainingvideos.com/how-to-perform-vlookup-from-closed-workbook/
@@Exceltrainingvideos Thank you. But that also is VBA to create a formula into a cell. I mean is there no way to use VBA only to extract data from a closed workbook? At this point yes, I am doing the same thing, I am adding formulas to cells to get data from closed workbooks. Which feels kind of a stupid thing to do... but there seems to be no other way.
Thank you sir
useful videos
I request vba code how to find multiple lookup of the same case
This link will help: www.exceltrainingvideos.com/how-to-use-vlookup-to-get-multiple-values/
Or search www.exceltrainingvideos.com
Thanks
what if it is excel macro in mac, how can I replace the "C:\"???
This link will help: www.macexcel.com/
@@Exceltrainingvideos thank you
Great sir but I have one Question if I want to get multiple value from closed workbook of one value
Ex.suppose A200 this value have many match in closed work book
Such as A200 have two results like
Mouse
Keyboard
This link will help: www.exceltrainingvideos.com/how-to-get-multiple-values-from-closed-workbook-using-vba/
Sir how to perfrom this with dynemic workbook
Can you elaborate a bit more?
@@Exceltrainingvideos sir i refer for look up value "b3" . This cell value also name of the close workbook . I want when i change "b3" value then vlookup those workbook every time dynemicly . My closed workbook destination folder same . I use indirect function with vlookup but only work when file open.
i GET ERROR WHEN I RUN THIS CODE
Check your path carefully.
...............