Do you have a video for this? I do all my estimates on an Excel spreadsheet. The cells that the address goes in is the same for all my saved estimates. I would like to collect the addresses from all my estimates and place it in one file for mailing. Can you help with this?
Hi, This is great to use but I need little help with the code as my data has few missing count of files names can I skip them in the loop. E.g.: The file name is "Search Query Week 6.xlsx" , then Week 7 and 8 is missing then "Search Query Week 9.xlsx" it's one thing i want to know how to jump if the file is not exist. Another thing is my file name ends with 6 to 35, hence should I use "i" as shown in the video or need to do some changes with the code. These 2 queries. I must say the video was very useful. Thanks a lot for this.
Hi, your video is so helpful to me. But I stuck at one point in raw files after the header I have one black row and after that blank row I have data.. will you please tell me how to edit the code in this condition.. please guide. That will solve my entire problem
Thanks for such video tutorials. Can you please describe how to set file location if details are not be same eg . Dpr -1,2,3... And second thing how to use columnoffset if there is column are not fixed in order.
Can we just take particular data from each file? If yes, how we can do that? (For example in this example, we just need column A and column D, can we do that?
This is really a very helpful video. Although I have a doubt, unlike your case(Day1,2,3), what if the different files is not sequential like(Day 2,29,40)
Thank you for this video and it was really helpful. I am trying to achieve the same thing but instead of pasting everything in first sheet of master file, I want separate sheets of each excel data in the master file. How can I do that? Any help will be appreciated.
I m dealing with network alarms on daily basis. Getting data in 23 files for different zone. Need to append the data in single sheet for doing further analysis.
In the video you had showed the combining of 5 different files, but what if you had an unknown number of files to combine? e.g. one week is 4 files, the next week is 5 files, the following week is 6 files etc. How do you modify the code for the "For i = 1 To 5 Step 1" part?
Hello. I recreated your Excel VBA to Combine Multiple Workbooks example shown here and I am receiving a Run-time error '1004': It's look for a file entitled "Day0.xlsx" but that file does not exist. Do you have any suggestion to fix this? Thanks
This is very helpful, since I am very new to VBA, quite difficult to understand. would it be possible to explain how we have defined the each excel by step by step.
hello sir thank you for this valuable lesson , but how can we precise automatically the path of the files and how can we import wokbooks with multiple sheets
thank you for the video. I have a question for Printer object and Printers object. is any Reference library required to install in the Tool->Reference before we can use Pinter and Printers object? I run below code, and get error "object is required" for line "For Each prt In Printers". Sub ListPrinters() Dim prt As Printer For Each prt In Printers Debug.Print Prt.deviceName Next prt End Sub
Hi Sir, Could you please help me on VBA code for below scenario..I have a folder which is having multiple files, in that few files having 15 columns of headers and few of files having more than 32 columns of headers,, so if file has 15 columns of headers need to copy as it is and paste into consolidated file, if file has 32 columns of headers need select required columns (up to 15 columns which are having same in 15 columns file but header name will be slight different ..example: if header name in 15 columns of the file has "Subject" but in different file header will be "SubjectID")which was align in between the headers, and paste into same consolidated file next available empty rows,, Thank you so much in advance...
Hey there... These codes are very useful. However, is there a possibility that you can tell me how to set up the code or what changes to make in this code shown in the video, if the file names are completely different.
I am not that expert in vba hence didn't understood the full code, will encourage you to take time and explain the code (make the audience understand about the code) instead of just reading what you about to type
Dear Sir, Good Job !! i have a similar file, some invoices (same format) sheets in one excel file and i want to add one more sheet like report, specific cells data should be transfer from all invoices to this report sheet. please refer to me any of your video to know about the vba or shall I write to your email. please advise
Thanks. Very helpfull. But how to pull data if the 1 or 2 workbooks are open? Is it necessary to close all the workbooks before running this program. What is the solution if the file is open? I have a situation where I can't close all the files. Please help.
you can use workbooks("name of workbook").worksheets("name of sheet"). ........this is how, you can be specific to any workbook or any worksheets. Let me know if it helps.
Sir its really help in consolidating data to master sheet. however it will be great if you can explain code in with some description to understand for e.g. me.range couldn't figure out what does it mean.
Hi Sir i have followed the same coding as u did and made some of the changes like I have 15 file to merge and all those 15 files were in csv format so I have applied changes wherever required, but I am getting Run time error-9. Subscript out of range. When I have clicked on debug it highlighted the line - With wb.Sheets("Sheet"). Kindly help me in this scenario.
Error-9 occurs, when excel doesn't find the object. As you are saying that error line is "With wb.Sheets("Sheet") then you should check if sheet name is correct and wb object is declared. Without looking at complete code, I can not say much, but I would suggest to research on error 9.
I need that my file is shared on a network. All can update but i don't want that. I made an excel file with dashboard which is updated by different persons on network and all have their different file. Now i want that when they generate their report some particular information from their excel file should be appended in my file on network.
This was excellent, thank you for sharing! It worked wonderfully and was easy to understand. I have a question: How do I merge into the master spreadsheet ONLY the rows of data where columns 23 or 24 are not null. I don't know how to make this modification to your vba script, please advise and thanks again!
Tq sir, how to combine worksheets of same structure which are in different folder with unique folder name as 2546-repo, 6756-repo,.... and so on pl give VBA code
Hi sir and thank you for the video explanation. On my case I want to be able to select the file to be copied. How can I adapt your code so a Dialogbox will open and I can select the file I need. The files to be copied are in “.csv” format. Thanks a lot.
You can use getopenfilename function........and store file name in a string and use it as per requirement........code is Dim filename As String filename = Application.GetOpenFilename()
Please use the following link. It has series of tutorials of excel vba programming from starting to advance. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-MwvQWpzuLLk.html
what if I have multiple workbooks with different file names. Each workbook has a sheet with different sheet names as well. My goal is to extract results from these sheets. The range also varies and I wanted to copy and paste them on the target sheet as values.
Good Morning Sir, please help, on how to transfer Data from multiple excel workbooks if all the workbooks are having different name for example instead of Day1 & Day2 it may be Prashant & Vijay than how to consolidate that all files into one Master File with easy VBA Code
I can not say anything without looking at your code. You can check your code carefully and compare it with my code..........or send me your file. I can look at your code. but only, when I will get time.
Hi sir, I want to consolidate file if sheet name is different in each file, like file one has sheet name as India_Country, 2nd file has sheet name as China_Country, country is there in all file sheet name, then how to consolidate? Please help!!
Hello. Thanks for watching...in that case you can use sheet number instead of sheet names...and run loop for total number of sheets with code like worksheets.count...try it..if you face challenge, send me your file with detail at exceldestination@gmail.com, I will try to respond.
@@ExcelDestination hello sir, i want to make a dependent drop-down list in which if I select something in Column A then drop down will activate in column B and it should be non editable, but if Column A is blank then drop down shouldn't activate in Column B and the cell should be editable. Is it possible? Thank you, i am trying this since so long buy unable to do, please help. It's really very urgent for me.
Hi sir, I have consolidate sheets in different folders with different names ,how can I take all sheets data ..that script should work for all projects in every project sheet name is different