consolidate worksheets

Hello. I am trying to use a macro and VBA to consolidate files by copying the first worksheets from multiple workbooks and pasting them into one worksheet. I Googled and found the code (below) and modified it to meet my needs. My code works successfully with smaller files. It automatically...

Hi! My problem is this: - a manager is emailing out spreadsheets weekly to her team for them to fill in their current workload. Design includes Name at B4, and completed information about workload in cells A11 to Hx (x depends, more/less rows are filled in each week) - team email back the...

Hello, I am trying to get the new worksheet I am adding to be placed after the last workbook. I want to replace the "Add" in the line: "Set Dest_Sh = ActiveWorkbook.Worksheets.Add." with "Add(After:=mainWB.Sheets(mainWB.Sheets.Count)). But, it is not working for me. Any thoughts...

Hi, I have a workbook with 365 worksheets with the following Column headers. In every worksheet data starts from first row to 85 row only. It is all identical in all the sheets. I want to consolidate into one single sheet. But it spread over multiple sheets when I copied a PDF and converted...

Hi Folks, So today I was thrown a curve ball on a project I'm working on. I Have 3 sheets of contacts from 3 different vendors which are all different sizes. These Sheets have very little overlap besides a few columns..."FULL NAME", "COMPANY NAME","ADDRESS LINE 1" and maybe a few other columns...

Hi, I have a workbook with several sheets. They all contain similar data in a identical column sequence. There are however different amounts of rows in each column in each worksheet. I have been able to write a macro summarizing all the sheet names in one "summary" sheet, listing them...

I have a Workbook with several hundred worksheets, which I need to merge/consolidate into a single worksheet. I found some code that I was able to slightly modify for my purposes and works perfect with the exception of some formatting of the data problems. I have a test version of my workbook...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> GOAL: Linking SharePoint to Excel, so that Excel will contain pivots. Multiple SharePoint tables have been linked to individual sheets in Excel. A macro was written to...

I have a macro that pulls in a tab called "Registration Form" from multiple other files and dumps it into my working file. I also have a "Control Panel" and "Master" tab in my working file. As a result, the tab names in my worksheet are as follows: Control Panel Master Registration Form...

Hi All, I have a one workbook with multiple sheets. And I wanted to combine these sheets into one sheet except for worksheets with sheet name "summary" and "data". My code is not working because it is still combining all the sheets even if the worksheets "summary" and "data" are hidden. Can...

Ok here is my dilema. I need to track progress for an annual certification program for my company. Each area has its own spreadsheet that is identical in setup. I want to create one pivot table for all the spreadsheets. 1) Do I merge/consolidate 19 worksheets into one worksheet and create from...

Hi, I have a problem I have been trying to solve for some time and wondered if anyone on here can help me. I have a workbook with several worksheets with the same format. The content of each worksheet is different, with some cells blank and others with text. I want to have a final 'summary'...

Can some please assist me with the following: I've tried a bunch of code which has somewhat helped but can't seem to get what I'm looking for. Note: Each Row specified is Actually its own sheet with the same header. Sheet1, Sheet2, Sheet3, Sheet4, & Sheet5 Expected Outcome: Name -...

I'm using a workbook containing a worksheet with same layout for each customer with their orders & delivery quantities by date and means of transport. I want to consolidate all the data from the different worksheets into one worksheet (Summary), where update has to be automatically by activating...

I have this script that will go through a folder in which the path is hardcoded into the macro and consolidate all of the .csv files into the .xls I am working with utilizing Excel 2007. Sub Consolidate() Dim fName As String, fPath As String, fPathDone As String, OldDir As String Dim LR As...

I have lists of investments categorized by years (e.g.: 2001.xls, 2002.xls, 2003.xls, etc). I need to pull certain data from those files to create the reports I need. Pivot Tables and the Consolidate function might be answer to my needs. Besides those functions, I think Array Formulas might also...

I tried to record a macro, but I'm sure I need a bit more help. Not a VB programmer/expert at all.. Anyway, I need the data from the following cells from ALL worksheets in a workbook (except one: Report worksheet). I also would like the data to be entered in a new row for each sheet (not...