combining data

I have a complex spreadsheet which uses data from several sources, including a Microsoft Form which employees revisit to update details of their training course, store number etc. over time. The main page of this spreadsheet uses Index/Match formulae to summarise info from the various...

Hi everyone, I'm new to this forum. I need some help with pivot tables: I'm trying to consolidate payments Ids together, specifically payments which have the same ID but different payments need to be combines and totalled into one. I done a head-start with pivot tables. I comparing and...

Good morning, I'm a VBA novice and having a hard time with my first major project. I've been researching solutions to copy all the data from multiple files (.XLS?) in a directory called "C:/allfiles/" to a newly created master report file. I need a solution that won't capture any additional...

Hi, Thank you for giving me the possibility of posting here my issue. I am a Surgeon, and I am doing a research project. My job is to perform a chart review and record patient's variables. Thus the structure of my excel files is pretty simple: patient identifier=rows and variables=columns. My...

Hello, I have turned to MrExcel numerous times in the past for solutions to various problems I've encountered and found the help to be excellent! Well, now I have something that I am struggling to find an adequate solution to. I hope that someone can help me out. So, I have 7 worksheets of "Top...

Hello everyone, I'm in desperate need some some VBA help! I have a number of identical files saved in a folder which I basically need to combine into one report. The format of each file is as follows - <tbody> A B C D E F G H 1 Employee Name 2 Employee Grade...

Should be simple, but I'm lost. I have 12 sheets, one for each month. Each sheet has one text field that gives the date, as in "JAN10", and a second money field that shows how much I paid to store1. I want to learn how to look at the yearly picture in two ways: one, as a graph plotting...

Hello, I have a report that generates based on InfoPath forms filled out and downloaded from SharePoint. In this report, there are 3 columns each for part numbers and part descriptions (Part 1 #, Part 1 Description, Part 2 #, Part 2 Description, Part 3 #, Part 3 Description). In the report...

Hi, I'm new to this forum so hope this hasn't been asked before. I have a large data set where I have rows that contain the same data on 2 columns. Let's call them ID number and Car Model. I only want to combine the rows IF ID + Car Make = ID + Car Make of another row (e.g. duplicate) AND the...

Hi there, I have 5 excel documents, each containing 1 worksheet that lists a set of information relating to a serial number like in the table below. In each of the documents the list of the serial numbers is the same, but the properties are different e.g. Document 1 contains property A, B, C...

I am working with a system that reports user data into two columns: Column A has the fields (9 total per record) and Column B has the corresponding user data. Column A looks like this: 1. Last Name: 2. First Name: 3. Middle Name: 4. Card Number: 5. Employee Ref: 6. Personal Details: 7...

Hi guys, I've made a couple of example tables to explain my problem (see tables below). I'm struggling with the following: I have two sheets. Sheet T1 and sheet T2. I want Excel to take the data from column C from sheet T2 and put it into column D of sheet T1 to form sheet T3. So Excel...

Hi Everyone, I was hoping someone could help with Excel task I have been struggling with the past few days. Here is the setup: 1) I have a 8 worksheets in one excel workbook that contain 15 different columns each. The worksheets are identical, but contain different data. (They are from data...

I have looked through the existing post and can not find exactly what I need. It maybe out there I just can't find it. My problem: I have 26 Excel Reports that come out everyday I save them to a folder on my Desktop and change the name to the same thing everyday "Report(1), Report(2)" etc...

I have been searching all over for most of the day on the best way to do this, but I am stumped. I have a worksheet of data in the workbook. It contains fields for "Project", "Month", "Drawings", and a bunch of other columns. I made a single pivot table from this worksheet that will count the...

Hi guys. I have Excel 2003. I am working on a problem. I have multiple sheets for various purposes of my customers with all various columns. However i require to have a master sheet which gives me the due dates customer wise in one place. i.e it selects the customer, the worksheet purpose (say...

I have two seperate files in excel and I need to keep both. One contains sheets that records the individual sales of each employee for all the time working in the company, the other one includes all the sales of the company (includes all employees) for each month, it has a tab for each month...

thanks for taking your time and trying to help out i would like book1 to be the results from book2 plus book3 <tbody> book1 b c d e f g l t </tbody> <tbody> book2 book3 b b c c g d l e t f </tbody>

Hi All, First of all, thanks to all of the posters here, you will never know how much help you are to all of us who need the assistance and guidance you provide.:) :) OK, on to the problem. I have a building survey project underway, I have created 2 workbooks, (Internal data & External data)...

I have several files with multiple worksheets. The first worksheet of each of the files contains up to 5 rows of data (rows 2 through 6) with info that needs consolidated into one worksheet of a separate file. (this new worksheet would then a master from which the data would be sorted several...