multiple files

Hello, I have been running a report weekly using the below code in a module to pull all of the excel invoices I need into a query. My issue is that every week I have to rerun the report from scratch because if I just click run it will re-pull the same files I already have in it again. Is there...

I have 12 excel files that contain a column with dates. The dates occur multiple times. I need to count the number of occurances of each date on all 12 files. Is there a way to do this with a formula or array? Example, <tbody> Date column on file 1 6-1-2015 6-1-2015 6-3-2015...

I don't have much VBA knowledge, so it's been a struggle for me. I have this list of person information with six columns, viz., Serial No., First Name, Last Name, Age, Email and Contact number with around 800+ rows. I want this list to split up into different excel workbooks (.xls) with 30 lines...

Hi everyone, my first post here, have been reading a long time and found a lot of helpful threads though - Thanks everyone! But my new macro won't work as I want it to. Can you help a newbie out? Here's my problem: I have a folder with ~1000 xls-files. They are structured in the same way and...

I have gotten code from other threads and for the most part it works great. It is copying data from all excel files in a certain folder, then pasting them into one sheet. The issue I am having is when it is copying data to new sheet, it is not in order of file name. file name is in date format...

Hello, I would like your help with that matter. I have 400+ orders in excel files that share an identical layout. The lines represent product codes and the columns product colors. I need to summarize these files into one pivot table with the ability to determine the precentage of people that...

I have been researching the solution to this problem for several days with no results that match my problem. I am hoping it is possible and I have come here in hopes that someone will know. I am using Excel 2007 but have access to Excel 2010. My boss has been using an Excel sheet as a template...

Hello all, I have a MacBook Pro that is 3 years old that has undergone some physical damage (a few drops). A few months ago, I was working on two Excel worksheets (one had >850 rows and 3 columns and one had >12000 rows and 24 columns) and a Word document (around 60 pages long)...

Hi, I was trying to figure out a simpler way to create individual excel files for over 300 people in one shot. I have created an excel template and have a list of 300 people. Rather than one at a time, is there a way to do it in one shot? Thanks, Sunny

Good Morning! I am currently attempting to use an excel macro to allow me to send a list of files to one person. I have managed to create a dynamic list where one sheet of the workbook has the list of files and checkboxes, and as certain ones are selected they appear in a list on the 'front...

Hi, On my master file I have the following link: ='Server\...\Year 2013\Data 1307\[0713 Support File.xlsx}Data'!$B$2 and it produces a number for where it is linking to. In this case we will say 1. I have multiple (about 60) supporting files that link into the master file and I have to change...

My hobby business is race photography. We go out and shoot races and then upload them to our servers and then using an excel sheet with first name, last name, bib (race) number, and email address...we are able to upload this into the software to send out automated emails to each participant. A...

Hello Excel/VBA experts, I am very inexperienced in VBA and wanted to run an idea across you to see if you could provide input on feasibility or to improve upon it with capabilities I may not be aware of. (I already looked, but if you can find something similar to this in another thread, please...

Hi Excel experts, hope somebody is smarter than I am with this stuff: 1. Does anyone know of macro script that I can use to copy the SUMMARY worksheet from MASTER.xls into all the files in the folder "R:\Projects\Hospitals"? -I have a folder full of Excel workbooks. "R:\Projects\Hospitals"...

I work in research and I frequently need to process large amounts of data. Each data set is output into an excel spreadsheet and I have ~150 spreadsheets (formatted identically) that I now need to process. I recorded a macro to manipulate one of the data sheets, and I know how to use the same...

Hey Excel gurus, I have a tricky problem to solve. I'm doing data analysis, and I have a few dozen files, each of which have between 1 dozen and 4 dozen bar graphs. The graphs in each file were produced by a macro unique to that file. I want to go back and make changes that apply to every...

Hi, I currently have an excel file containing parts with a few characteristics : -----A----------B-----------C--------------D-------------E Part type----1rst letter----2nd letter----1rst number-----Name --Valve---------D------------V-------------0-----------DV0001...

I apologize if this has been answered, however I've spend a few hours trying to get something to work. I am using Excel 2010 and am trying to combine multiple files in separate subfolders into one workbook with each file name as a separate tab in a new workbook named the same as the subfolder...

Dear all, Here is what i did: 1. to avoid clutter or bulk files, i created recipes 1 to 20, separately. so i have 20 excel files 2. i created the 21st file which will consolidate the 20 files altogether, that is, using pivot. what i hope to achieve here is, i will make a central ordering...

I'm looking for an easy way to take a student's academic plan (for the next 2-4 years) and match the classes that they take with the semester they take it, and then do that for 175 other students and counting. The semesters will change depending on the students, but they all take the same...