multiple files

Hi, I have a a folder with 100 csv files from specific Cells and paste them to a summary excel file. For example- from origin_file_1.csv to the dest_file.xlsm B7-->K2 B8-->L2 B10--> M2 from origin_file_2.csv to the dest_file.xlsm B7-->K3 B8-->L3 B10--> M3 and so forth. Thanks in...

Hello Gurus, I am working on an item, where I need to compare 2 excel sheet ranges, Say File1 Sheet1& File2 Sheet1 I am invoking File2 Sheet1 by File.Open Copying the respective range from file 1 & file 2 into Rng1 & Rng2 I am concatenating column values for each row in Rng1 & Rng2 & putting...

So I am trying to compare and match data from 2 workbooks in a folder at once. There is about 700 workbook files in the folder. For example: compare the cells in workbook 2 to workbook 1 and the cells in workbook 2 that are not in workbook 1, paste the cells and show the number of cells. The...

Hey, there! I am trying to merge about 400 excel files into one master file, which I have been able to successfully do. HOWEVER, I also want the first column to include all the file names corresponding to the data. Can anybody help with that? I am quite new to VBA and trying really hard to...

Hi Guys, I'm using below codes to remove password and save excel files without password. Can you help me modify the codes so I can use this for word files? =================== Sub RemovePassword() Dim xlBook As Workbook Dim strFilename As String Const fPath As String = "C:\My Folder"...

Hello everyone, I have multiple destination workbooks each one with a list of 100 symbols (one symbol per cell) in column A starting from cell A25. I have also file "Source.csv" with a list of 2000+ symbols in column B starting from B2. To copy and paste all 2000+ symbols in the column of a...

Hello all, I'm attempting to help a coworker automate part of her daily tasks. A PDF named in the same format is sent to different people about once per day. IE Person A gets his company's invoice, Person B gets his company's invoice...etc, etc. Invoices are all named in the same fashion -...

Hello all, I have no prior knowledge of VBA code, so please bear withme if this question has been answered before in some way or another. The context of the problem is that I have a relativelylarge (>100) number of .csv files which all follow the same format and the samethree rows need to...

Is it possible to setup conditional formatting on a field in one spreadsheet based on the value in a cell in a completely different workbook? here's my situation... I have one file (File1.xlsx) with a dashboard of red, yellow green formats via a dropdown list of R, Y and G I have a second file...

Hi everyone, I have folders for each of my students containing a spreadsheet with their performance. every week i have to open up each individual file and print out 2 specific sheets from each file, week x and week x progress report. it usually takes me all morning, but I was wondering if there...

I have over 200 excel files that have the same headers but different number of records for each. I need to calculate the median for column F for each file and then report that median (on one file if possible) for each file using the filename of said file. Is this something someone can help with...

Hello everyone, I'm in desperate need some some VBA help! I have a number of identical files saved in a folder which I basically need to combine into one report. The format of each file is as follows - <tbody> A B C D E F G H 1 Employee Name 2 Employee Grade...

Hello, I have a project that I'm hoping to get help with. I need to import multiple CSV files into specific Macro Enabled Workbook that already has uniquely named Worksheet tabs. I have code to do this for 1 CSV file into 1 worksheet tab. However I have 7 CSV files (always the same CSV file...

Any help is greatly appreciated. To simplify: -I have multiple files for 2016 say files A, B, C, D, E, F (each file is labeled with the year at the end ex. A 2016.xls) -I need to copy certain data (all on one worksheet) for the same files from 2015 (A 2015.xls, B 2015.xls, etc.) into the 2016...

How I can view and edit multiple files within a single tabbed window. I wants a tabbed user interface - as seen in web browsers such as Internet Explorer® 8, Firefox and Google Chrome. Note: I am using office 2013

I use to be able to have multiple excel workbooks, in the same session, open and could move them from one screen to another. Under this functionality i could move or copy sheets between workbooks. IT did something to my computer and now they tell me that this functionality is not possible...

I have a workbook that through VBA parses a worksheet into separate workbooks based upon the criteria in a specified column and then names and saves the different workbooks. No problem, this macro works great. I then have another macro that sets each workbook a password from an assigned list...

Hi guys, I am trying to split an excel file with over 100 000 rows into different files based on the values in column A. In this case cases A2-A62 have value "1", cases A63-A89 "2", .., cases A120 569-A120601 "120". Row "1" includes headers for the columns. I am not very experienced with...

Dear all, I am trying to consolidate multiple excel files with different sheets to one file that was initial file that was split into several files. So I have multiple files that contains part of the file and I would like to collect the feedback from that in the Initial master file. My logic...

Hi guys, I want to store data in 1 worksheet from multiple .txt files. Also, I want the first cell to contain the file name not the file path (if possible) so I can link it to the graphs later on. There is also AT MOST 7 columns in the data while the number of rows is variable and the first...