automatic data input

I'm still new to VBA, Took a long break and started studying C++, so now I'm all confused as to how to get this done in VBA. So here is an image of the file. I have my bills located on the same sheet Starting at B76:D100, B76,C76, and D76 are titles Date, Item, Amount The Date is a formula.. As...

Hi all, I am trying to figure out if there is a possibility to find a solution to the following example: Let’s say that we have a table with input data including words and numbers. In that case that I need is for following up engineering cases. The problem is when you added a new case and it...

Hi, I am trying to automatically import all text files (csv type) from a given folder. My code to pick the folder and loop through the files is working but the code (which was recorded during Get External Data) that is supposed to drop the data in my workbook is throwing an error: Run-time...

Hello everyone! First time posting on this page after using it many times. I have a challenging form I was trying to create but I'm not to sure where to start. I know what i would like for it to do but just don't know how to get it there. I approached my university professor who insisted Excel...

Here is what I am trying to do, If I have a document named Test.xls on my G:\ Drive and on my masterlog, that is also on the G:\ Drive, I have the name of that document listed in A1(Test) I would like to have a formula that would say IF(G:\folder**** = A1 then populate B2 from Test.xls in...