merging

I am trying to create a spreadsheet that will contain the list of all athletes at our school. Other sheets (Tabs at the bottom) are to have each sport and those athletes that participate in that sport. As I add a new student (athlete) to the master list, I want them to add or delete from the...

hi i see lots of posts about merging but could find none that really address my problem. im trying to organize a 10k+ name donor data base list that has names of donors, with how much they have donated, every year in yearly increments starting from 2006..... the problem is that excel displays...

Hello all, I'm a novice VBA user and I'm having some issues merging data. I'm trying to merge data from several sheets into one master sheets and I've run into some issues. I've borrowed some code from Ron de Bruin, however the code does not work for shares documents as his code deleted and...

The first set is 8045 rows with headers: Campus|District. The second set is 1040 rows with headers: District|City. I need to add the corresponding City to the first data set to end up with: Campus|District|City. I'm not very familiar with VBA or for loops but I think that's the route I need...

Hi This is my first post on this forum, I couldn't find the answer elsewhere, that's why I decided to post it here: I would like to combine multiple rows with the same id, into one. Eg. -------------------------------------------------------------------------------------------- ID (movie...

Hello, I'll keep it as simple as possible... This is what I have <TABLE style="WIDTH: 304pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=405 border=0><COLGROUP><COL style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 3108" width=85><COL style="WIDTH: 48pt" span=5...

Hi Friends, Could Anyone Help This Issue. I am having an Excel Spreadsheet which has the values as follows A1 = 1000 B1 = C1 = D1 = (B1, C1, D1 are Nil Values) I have Merged all these four Cells so that it displays only 1000 in the range A1:D1 But what is the problem now is If I am...

Hey There!<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I’m new to the forum and am having a tough time.. I’m pretty proficient in Access, but Excel is a little foreign to me. I have a table that contains simliar (but not duplicate) rows. Is there a...

Hey please can anyone help me, I need to merge like over 3000 entries into one document... I have two excel documents with different information in each but want to merge it together... For example - " l " will be used as a column. Document one has... 1 l 15 2 l 20 6 l 25 7 l 30 Document...

Does anyone know the best way to merge data from a stocklist stored in an Excel workbook, there are two workbooks, one is the main database of about 20,000 lines, then there is a monthly 400 or 500 line 'Updates and new additions' sheet stored in a different workbook created by the shop stock...

I have a spreadsheet with 15,130 entries which relate to clients and their fund holdings. Quite a lot of the clients have different fund holdings in the same policy and are shown as a seperate row on the sheet. Is there a way consolidating the rows thta have the same plan numbers and putting...

Hi! I am trying to streamline the product overview making it easier to view the sales of three different departments in one overview file. How it works today is that a responsible person in each of the departments adds information to an excel file consisting of columns such as order number...