multiple excel files

Hi, I've been looking for a solution to my problem for quite some time and am nearly there. The script I have compiles all workbook sheets in a directory into one workbook. Unfortunately the data I have (over 200 workbooks) has a few extra rows at the start of each sheet I need to get rid of for...

Hello all, I'm new to the forum and to VBA in general, I was hoping to get some assistance as I'm a complete novice. I have a folder on a Network drive that we house multiple .xlsm files in. The files itself are all the same and very basic. B2:B4 have title fields and C2:C19 have data fields...

I have two excel files that run macros upon opening. I have an additional "dummy" excel file with the following codes: Private Sub Workbook_Open() If InStr(1, ThisWorkbook.Name, "NoRun") > 0 Then Range("C6").Select 'Do nothing so the macro won't run...

Hi, I want to change 1048575 cells with a series of digits starting with one in 1000 documents so that document 1 starts with 1 and the last one is 1048575000 column B. Answers are greatly appreciated. Kat

Essentially, we have one master Excel sheet for forecasting. There are 6 account managers that fill in their incoming and projected work in their own spreadsheets, all in the same format/columns and information. We need the master spreadsheet to gather data from the other excel documents for...

Hi, i'm still REALLY novice in this field and needs your help to solve my problem. i want to create system that can search and open 1 excel file from multiple excel file.Since there are too many excel file, i create a database(using excel) which list all the excel file and sorting it by...

I need to create a file that when I click on a combo button, this macro command will: 1. search in the specified folder 2. open a source file 3. copy the data it needs 4. paste the data into the original file 5. close the source file. I need to be able to name the file directory on the...