Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan
It's pretty easy either way, but if you're beginning, it may be simpler to copy a regular function to VBA editor, rather than doing it in VBA. Not sure the full benefits one way or other. Dan
I effin love you dude!! I'm new to VBA and I'm trying to impress my boss as no one at our company knows how to use Macro! This will make everyone's lives way easier and hopefully I can push for a raise!!!!! THANK YOU 1000 times!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Keep at it. VBA keeps the raises coming! It's so powerful when you are the only one who can automate everybody's workflow. POWERFUL! Thanks for the comment! Dan
Am following your great videos and practicing directly. My question is, what if formula is "=IF(B4>TODAY(),"Yes", "No")"? as am getting error on "". Thanks a lot
Hi Dan. For some reason I get a msg box "Run-time error '1004': Application-difined or object-defined error" My code is as follow: Sheets("HT").Select Range("B5").Value = "=VLOOKUP(A1,B2:E3,2,0)" The problem has existed across all of my computers for the last few days. I have made the same code before and it just do not work now. Another odd thing is that if I try to insert a "=" before my formula with a macro then it won't make the replacement if there is a "vlookup" or "if" word in the formula. So I insert a "=" in a formula with macro like: "D2+D3" it then works fine. In addition it wont replace anything in a formula if there is "vlookup" or "if". I hope for any kind of help. Thanks in advance.
Hi Dan, could you please help me out wid a macro to copy data frm one sheet to master sheet using criteria depending on the particular column name from my master sheet, search the column name in other excel and copy that data in that column frm that workbook to master workbook. note the particular required columns may contain spaces in between, hence I am finding it difficult to select data to the end of that column and paste it in master excel. thnks
I follow your videos by practicing directly on my excel workbook and i discovered that the first formulas on vlookup (desc, dadded...) didn't work now even if at the moment i wrote the macro by listening the correspondent videos , everything was alright!!!! I've tried to put application.volatile prior worsheetfunction , as recommended in a previous comments, but i did'nt work!!!! Please help!!! STEPHANE NTONGA from Lille area (FRANCE)
Hi, I was wandering if the vlookup in vba excel can read this. For example I want to look up this item 0-0, by typing this item 0. Could you give me an example for this. Thanks. karl
I'd be happy to look at your code. Have you tried downloading the file I'm sharing with everyone through Dropbox? I'll add the link to this description on this video. Try comparing the version I give away free with yours.
yes but you need to concatenate them using ampersands. It joins variables with strings of text together. for x = 2 to myLR myWs.cells(1,x) = "=vlookup(E6,pt_Table," & x & ",0)" next x etc
ExcelVbaIsFun That worked! Thanks. Now is it possible to push the data back into a table as a value once the data has been changed? I used your previous example to pull data from a table. I want to be able to update the data and then push the new data back into the table.
Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan
Hello, the video was interesting, now I have a question if I want to search in another worksheet, how do I do it?
Thank you! Great class.
Thx mate
I prefer to use this one as it is easier
Could you tell wt are the benefits of using method 1 or 2??
It's pretty easy either way, but if you're beginning, it may be simpler to copy a regular function to VBA editor, rather than doing it in VBA. Not sure the full benefits one way or other. Dan
I effin love you dude!! I'm new to VBA and I'm trying to impress my boss as no one at our company knows how to use Macro! This will make everyone's lives way easier and hopefully I can push for a raise!!!!! THANK YOU 1000 times!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Keep at it. VBA keeps the raises coming! It's so powerful when you are the only one who can automate everybody's workflow. POWERFUL! Thanks for the comment!
Dan
Am following your great videos and practicing directly. My question is, what if formula is "=IF(B4>TODAY(),"Yes", "No")"? as am getting error on "". Thanks a lot
Hi Redha, Can you share the full code or a sample workbook here: www.excelvbaisfun.com/ninja or here: www.excelvbaisfun.com/contact/ ?
Thanks
Dan
hi can u teach how to vlookup from external multiple workbooks from different folder location?it will be very much help full
Hi Dan.
For some reason I get a msg box "Run-time error '1004': Application-difined or object-defined error"
My code is as follow:
Sheets("HT").Select
Range("B5").Value = "=VLOOKUP(A1,B2:E3,2,0)"
The problem has existed across all of my computers for the last few days. I have made the same code before and it just do not work now. Another odd thing is that if I try to insert a "=" before my formula with a macro then it won't make the replacement if there is a "vlookup" or "if" word in the formula. So I insert a "=" in a formula with macro like: "D2+D3" it then works fine. In addition it wont replace anything in a formula if there is "vlookup" or "if".
I hope for any kind of help.
Thanks in advance.
Hi Dan, could you please help me out wid a macro to copy data frm one sheet to master sheet using criteria depending on the particular column name from my master sheet, search the column name in other excel and copy that data in that column frm that workbook to master workbook. note the particular required columns may contain spaces in between, hence I am finding it difficult to select data to the end of that column and paste it in master excel. thnks
Maybe you should had made a look up for the Prop Num as well, so the message would start with BA807 instead of ba807.
Thanks for some great videos.
Another great video!
Thank you very useful
I follow your videos by practicing directly on my excel workbook and i discovered that the first formulas on vlookup (desc, dadded...) didn't work now even if at the moment i wrote the macro by listening the correspondent videos , everything was alright!!!!
I've tried to put application.volatile prior worsheetfunction , as recommended in a previous comments, but i did'nt work!!!!
Please help!!!
STEPHANE NTONGA from Lille area (FRANCE)
Hi,
I was wandering if the vlookup in vba excel can read this. For example I want to look up this item 0-0, by typing this item 0. Could you give me an example for this. Thanks. karl
I'd be happy to look at your code. Have you tried downloading the file I'm sharing with everyone through Dropbox? I'll add the link to this description on this video. Try comparing the version I give away free with yours.
Cool, Stefyu, what's your question. We'll try to help.
Can you put a variable in the column section of the vlookup in vba? Like "=vlookup(E6,pt_Table,Column(X),0)" with X in a For loop in VBA?
yes but you need to concatenate them using ampersands. It joins variables with strings of text together.
for x = 2 to myLR
myWs.cells(1,x) = "=vlookup(E6,pt_Table," & x & ",0)"
next x
etc
ExcelVbaIsFun That worked! Thanks. Now is it possible to push the data back into a table as a value once the data has been changed? I used your previous example to pull data from a table. I want to be able to update the data and then push the new data back into the table.
it will be better even if external file closed vlookup macro able to do its job
Thanks you very much for your videos. They are truly great but i've a question.
STEPHANE NTONGA