@@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.
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?
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.
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!
I did exactly the same. It does not work. The error message is "Autofill method of range class failed". Have you tested your code?
what is i do not want a range, i want to look up the whole sheet in the other spreadsheet. The range is dynamic?
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.
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/
Useful sir.. Thanks.
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
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.
How can I do a dynamic countifs or sumifs from closed workbooks?
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?
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/
what if it is excel macro in mac, how can I replace the "C:\"???
This link will help: www.macexcel.com/
@@Exceltrainingvideos thank you
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.
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 GET ERROR WHEN I RUN THIS CODE
Check your path carefully.
...............