consolidation

Alright, so I basically have two problem in one post: 1. Translating this VBA code. This copies the data of different sheets to one summary sheet. If Sheet.Name <> Me.Name Then If sheet name If Sheet.Cells(Rows.Count, 1).End(xlUp).Row <> 1 Then...

Hello! I am updating a payroll document that we use for the company that I work for. Right now, we have multiple documents that we "carry" numbers around to suit the needs of different departments. I would like a more efficient system where I only have to enter the numbers once, and they...

I have a excel workbook containing around 500 sheets. Each sheet contains some financial data about a particular firm. I want to consolidate data in the following manner for a particular ratio say PE. It should look particularly like this FOR SAY Adjusted PE Firm Mar-13...

Good day guys! Can you please help me on this? Here are the parts of my project and its code. My project is to consolidate data from text file(.txt) *note that i can select multiple text file, in which 1 text file = 1 sheet *What is happening is that it is opening a new workbook *How...

My VBA/macro writing is a little rusty and I need to consolidate multiple rows into one row and then delete the old rows. My vehicle table has 1 row per bus per month. What I am trying to do is change the file so it contains only one row per bus with the monthly data in new columns. The...

I'm experiencing weird behavior with a pivot table. My file contains a Summary worksheet and 4 other worksheets. Each of the other tabs contains one table, named, with 5 columns of data. The summary sheet should take the text from the first column and the number from the second column of each...

Hi, I am working on a marco and have a few kinks I need to work through. So far I am able to copy all the sheets I want to into one sheet. I am not trying to copy only certain columns from those sheets as well as apply an autofilter to copy only to rows that are "Active". here is my code...

Hi, I apologize for the vague subject as i was unsure about what to do, i have lots and lots of data in single column, which is as follow Menu item Name menu item price menu description all three variable are in the single column and one above each other and i have a very long column about 5000...

Hello All Excel Gurus I am not an expert of Macros or VBA, but I think there can be a macro based solution to my problem for sure. I have to prepare a report every month in which I have to open around 100 spreadsheets which all have exactly same format and worksheets inside them. And go to a...

Hi I have 10 sheets and 1 master. Each of the 10 sheets represents a set of activity from one particular client which is being compared against our bookings for the day for accuracy and completeness (a rec..). If data matches, our reference is added to column B of each sheet. If there is a...

Hello, I have the following code: Sub Merge2MultiSheets() Dim wbDst As Workbook Dim wbSrc As Workbook Dim wsSrc As Worksheet Dim MyPath As String Dim strFilename As String Dim LastRow As Long Dim wsht As Worksheet Dim i As Integer Application.DisplayAlerts = False...

Hi, I'm trying to consolidate from multiple files into a different file, but I'm having some trouble. Here is a simplified example of what I want; File1.xlsx Col1 Col2 Col3 111a 111b 111c 222a 222b 222c File2.xlsx Col1 Col2 Col3 666a 666b 666c 777a 777b 777c...

Hi, all! I am having issues consolidating 5 worksheets into one summary sheet. My problem is that I only wish to bring over the rows which have a value in column BE. I only actually require data from columns C:F and BE for the summary. One more possible problem is that there are "roll-up"...

Hi All, I'm quite experienced with Excel, but I'm just diving into Access, and despite having read a lot about it, I have no one to really guide me directly, so forgive the silly question. I have a large database on an Excel worksheet, organized properly in columns. I'm moving it into Access...

Hi, Quick question - I was using the Consolidation function in my excel sheets, and was wondering is there a way I can remove consolidation from a sheet. Normal totals are easy to remove, as I can just delete them, however consolidation with links cant just be deleted. Would really...

I have some data on multiple sheets (same format) and I need to consolidate it on one sheet , need to explore an option other than pivot table.On summary sheet data must be in order i.e without blank space.

I am looking for an Excel Template for a property investment company that can help with the consolidation process. Can anyone help:)

I am using excel 2007 and have worked out how to consolidate and link data however how do I consolidate alpha text as i only seem able to consolidate nmeric data may thnaks Rameses

****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 12">****** name="Originator" content="Microsoft Word 12"><link rel="File-List"...

I am so frustrated as I'm not a programmer and I've had an issue at work that I can't seem to resolve. They gave the project to me because the "expert in everything data programming guru" left and took everything with him. I just happen to have some decent excel skills so I'm the interim choice...