combine excel files

Hi Friends, I am struggling to search a piece of excel macro which can do the following steps for me : 1. I have individual excel sheets in 3 folders where the name of the file is the same and an unique identifier for example : 1_test1.xlsx in folder C:\Macro\test1; 1_test2.xlsx in folder...

HI, I was hoping someone might be able to help me. I'm looking for a macro that loops through workbooks saved in one folder and combine specific worksheets into one workbook (as separate tabs). The worksheets can either be called the same thing or be the 3rd, 4th and 5th worksheets in the...

Hello- I believe this is possible having searched other forums and threads, I just don't know where to start... I have multiple XLSX files that all have data on sheet 1 (name of sheet 1 may not always be that) that I would like merged into a new XLSX workbook where each of the other single...

I am new to Access and want to covert my database over from Excel where I am very confortable to Access. I have a problem with several fields in my tables though. I need to search one column of data and replace it with the correct data. Example: Column Depot has several misspellings that I need...

Dear esteemed posters, Simply put, I need a macro - I'm aware that there are many macro's out there which combine data from worksheets - but I have trouble making them fit my needs. All I want to do is combine identical data in identical structure from different identical workbooks, into an...

Using Excel 2007 - I have two workbooks with data, with one column in common, and need to combine the two. For example: </SPAN> and </SPAN> I need to copy the header to the other workbook, then find all duplicates between the "Number" columns, and where there are matches copy the row into...