Hey Marc,
You are 100% correct! I didn't even noticed those slippery duplicates were there! ok Great, now both codes are functioning perfectly! Now only solving the issue from the other thread xD Thank you
Ok, I have tried to remove the range clear option and even after removing it and re-running the macro I am still getting some values omitted (same as before adding that line).
Also, I don't understand why column 6 would be empty if the range clear only goes through column 1-5(A:E)
Hey, thanks for the feedback Monty however, the reason I ask is because for some odd reason, if I try running another macro using as reference the new output it will behave oddly. My guess is because I am cut and pasting the output instead of having it go straight to where it should be. Any tips...
Hey Marc,
Since I am not very good at understanding these things I have attached a print screen of the locals screen along with the bugged line and maybe you can give me some tips from there if sending this to you via email is not possible... Sorry -.-
Hi guys,
I have attached a code that I tried to make along with some online help that would take all the data from multiple workbooks, copy all range, and paste it into my active workbook on "Jan17" tab shifted 6 columns down. Good thing is that it works, bad thing is that I am sure that it...
Hi Marc,
After much diagnosing it seems that whenever the code encounters the next file in the folder it bugs out on that same line claiming type mismatch even though I have verified that every sheet contains values on the same row therefore VA shouldn't be empty!
Marc,
Would you happen to have an email ID I can contact you with? I think it would be easier if I showed you with the real attachments but I didn't want it to publically post the documents -.-
Hi Marc,
the debugger is taking me to the line that says:
For R = 2 To UBound(VA)
Therefore this leads me to think that it might be due to the fact that not all the shipment #'s on the master can be found on the trackers. If that is the case then its fine since I did a random check from the...
Hey man,
Sorry to bother you again but I am getting a new error when implementing the code on my full scale project. I am getting:
"Run time error '13': Type Mismatch"
one of the source documents has like 10 tabs all with 1000+ lines so I am assuming its getting stuck on that one can you...
haha ofc -.-!
awesome man, thank you so much for your help man. I will donate some as promised once I am home, there is no way to donate to you particularly is there?
GREAT! IT WORK BEAUTIFULLY!!!
Thank you so MUCH!
One more question, if on the master tracker the Shipment number was in column C but on the source files the reference is still in column A, what would I have to adjust to make it work?
Sub Demo()
Dim SRC$, VA, R&, F$, oWb As Workbook, oWs As Worksheet
SRC = ThisWorkbook.Path & "C:\Users\me\Desktop\TEST\FFTEST\"
If Dir(SRC, vbDirectory) = "" Then Beep: Exit Sub
VA = [A1].CurrentRegion.Columns(1).Value
With...
Hi Marc,
Sorry took a while to respond. I am getting an error when I run it saying "Run time error 52: Bad file name or number" and the line the debugger highlights is this one:If Dir(SRC, vbDirectory) = "" Then
Hi Chihiro,
Thank you for the advice and I see how all the options you suggested would work however, since this is for a company I cannot purchase any add ons, also the workbooks inside the folder where the source data is located are being worked on by external parties therefore they might from...
ok Marc,
Thanks for your time and since its very late here tomorrow morning when I arrive at the office I will try to make one last crystal clear and complete explanation attaching all the files including one with the desired output.
Hi Marc,
I appreciate the quick response and as you can clearly tell I have no training/courses/previous knowledge with macros and have been trying to find online closely related things to what I need since I clearly don't know what I am doing... but at least im trying!
I saw the Range.Find...
Sub VlookMultipleWorkbooks()
Dim lookFor As Range
Dim srchRange As Range
Dim r1 As Range
Dim r2 As Range
Dim i As Range
Dim book1 As Workbook
Dim book2 As Workbook
Dim book3 As Workbook
Dim book2Name As String
book2Name = "FFTEST1.xlsx" 'modify to...
Hi Ninjas,
I have done all that I was asked to do and even attached sample files, I would really appreciate some help here... Sorry to keep following up on this but I REALLY need this.
Yesterday I took some time to design a few workbooks and perhaps that will help you get a better idea of what I am trying to do. Note the 3 attachments (2 that will be searched and the "master" workbook where I need the desired output).
Please save the 2 FFTEST files in 1 folder...
Hi Chihiro,
I thought that my explanation was detailed enough for any ninja to be able to make a simulation of what it is that I am asking for... 1 folder with 6 workbooks with more than 1 sheet with data, another folder with my master worksheet. Once I run the macro on the master workbook, it...
Hi Chihiro,
I cannot combine the documents as there is a reason for them to be separated into 6 different workbooks. As I mentioned on the previous post, all the workbooks are dynamic and being constantly updated by other parties as well.
Hi Narayan,
Thank you for responding and I will try to answer as much as possible:
It is hard for me to upload files as it involves many large excel files with confidential data so what I will try to do is to be as descriptive as possible:
I have 1 folder containing 6 workbooks with multiple...
Hi Ninjas,
I understand you all must be really busy but I really need help with this. I guess I just wanted to add 1 more condition also to the above scenario. if the vlookup could spit out the values from the 5th column to the 10th column on the active worksheet on column B through G would be...
Hope someone can help me,
I have spent many hours trying to come up with a vlookup macro function that would search for a chosen value on all the workbooks in a certain folder and give me the output. The issue is that on all those other workbooks they all have many sheets so the function would...