merge multiple workbooks

I am attempting to merge multiple files from a folder into one workbook. So far I have been able to merge the data, but when I attempt to add the file name in last column of the the results I am getting an error message. I am really new to VBA and any help is greatly appreciated. The error...

Hi Guys, I have never posted before but I am hoping that someone will know how to knock this out. My admin is going crazy opening all these files and then cutting and pasting little snippets into one merged file! I have to believe a macro type VBA program can help here. We need a...

I have worked in excel for a number of years but have always done things the hard/long way I guess you could say. Looking for a little help with a fairly large task to save a bit of time and sanity. I have 4 years of data that I need to total and summarize. Within those 4 years I have 25...

Hi all, I am stuck and would really appreciate your help in this regard, and I thank you in advance!: I need to write an app in excel that will merge multiple excel workbooks into one workbook (this could possibly be a macro / or vba UserForm containing the process that reads the workbooks...

I have a number of staff recording there case notes on individual workbooks in their named folder. Labels along the top = Client ID (number) Date (date) Action (Text) Staff (Text) Basically they complete this everytime they work with a client to keep notes. I want to be able to merge each...

I'm trying to merge two Excel files and output a single, nicely formatted pdf or Word report that combines the two Excel spreadsheets. Could you please tell me if that is possible and if so, how? I'm looking to take the results of an online form (40% of the final report information), that...

Dear Excel Gurus I have tried looking up answers and never realized how difficult it would be to bring data from two worksheets into one- seemed simple when I took on the task. So here goes.....I am working with two worksheets that are different sizes (meaning unknow number of entries as it...

Using Excel 2003, I have a workbook with 7 worksheets each containing 160 rows plus a header, each worksheet has a key field (employee number) and several unique columns. Looking for an easy to understand solution to merge the columns from all the worksheets into a new sheet - once data is...

Hi, I am new at this and I am trying to figure out how to merge data from many excel 2007 workbooks (Win 7), in one folder, into one worksheet. Each workbook has 3 worksheets, all worksheets are protected by password (all have same password) all I need is the data from the first worksheet. The...