merge data

Okay, so, I have a problem that has caused a bit of hair-pulling on my side, especially as all I have been able to Google results for is how to concatenate two cells with an ampersand: Basically, I have three columns, A, B and C. These columns will contain variable amounts of data, based on the...

Is there a way to merge data in cells vertically if the last cell in the merge always ends in a price? In this case I have thousands of entries as shown below, and I would like to end up with consolidated rows. 3, 4, and 5 as a single entry 7 and 8 as a single entry Leaving me (in this...

I have two sheets (Sheet1, Sheet2). Sheet1 has data from Column A to Column P. Sheet2 has a different set of data from Column A to Column G. Column A in both sheets is an ID#. What I'm looking to do is have a macro that if the ID# in sheet2 Column A matches an ID# in Sheet1 Column A, put...

Hi I am working on an annual planner and want to get dates to autofill in required cells (this bit works) the issue i am having is in compiling/merging the information for these lists. I have found ways of doing it for one column however i want to copy over the three columns from each range (I...

Good afternoon everybody, I would like to create in a Sheet named "Report" a compilation of data located in the Sheets "Sheet1" and "Sheet2" I already managed to obtain a list of active Sheets linked with hyperlink via a macro : result (in a sheet named "P.M.T" in cell A1) ...

Hi guys stuck with this, Basically i have a excell sheet with these values in only first 3 columns shown( actual table has 33 headers) <tbody> itemNumber Grouped or simple associated products 100.010UK _Group Grouped 100.010UK 100.012UK _Group Grouped 100.012UK 100.031UK _Group Grouped...

Hello I'm a bit of a noob and need some help! I have 2 property spreadsheets to combine, the both have roughly the same data but both have some missing compared to each other and most data has been changed/updated. So I wish to combine and update both into a master spreadsheet without creating...

Is there a formula for taking two cells and merging the data. Here's and example of what I want to do: A1="00000080" without quotes and B1="7652" without quotes. I want a formula that when I put the formula in C1 I want C1 to equal "000000807652" without quotes. Any help with this would be...

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...

Hi, I've been attempting to find a macro that would combine a number of similar workbooks into one large workbook. The files I'm dealing with are all .csv files with identical columns and headers. Let me also say, I have very little experience with these or code writing, so please be patient...

Hi, I've got to merge data from two worksheets into one, here are examples from both: sheet 1 Excel WorkbookEF4794ZZ23*4795*ZZ23014796*UA03014797*UA03024798*FAIRLE054799ZZ24*4800*ZZ24014801ZZ45*4802*ZZ45014803ZZ48*4804*ZZ48014805*GA5VS4806ZZ61*4807*ZZ61014808ZZ62*4809*ZZ6201Model_Structure...

I need to add two fields together to make a third field for example first name, last name to create a contact name. Then delete the duplicates. I don't want to just delete duplicates from last name as there are several records with one last name (Smith) and several people with the same first...

Been trying for hours to figure this out. I receive 2 daily reports (same format/headers, unique entry numbers) but the info may be updated and new rows of data added. Master sheet columns A to Z show the report data, but columns AA to AZ contain static data added manually corresponding to the...

I am doing a thank letter for donations I received I have a letter written and I have Excel spread sheet with the names of the donors and amounts and address now what I want to do is take that information from excel and put in word instead of copy and pasting them one by one. Is there any way I...

Hi, I am looking for some code help with finding duplicates and moving them to a new spreadsheet. I am looking for duplicates between Sheet 1 and Sheet 2 Col (A) "policy num". I would like the duplicates to be moved to a new sheet (Sheet 3). I would like the new sheet with the duplicates to...

Hello friends! I'm an Access newbie, after I realised that there were some things I could not bash out of Excel. I have two sheets I am merging with a query, Sheet A is the master, and Sheet B contains additional things to pad out the information in Sheet A. But Sheet B contains far less...

I have a data file of donors. The file has a list of each donor and their giving history listed individually. I need it all on the same row. For example, if John Smith gave State University 6 donations over 10 years. John Smith ID# 12345 is listed 6 times, taking up 6 rows. I need it so that...

Hi-- I have multiple school groups for one school name/contact -- how do I get them to merge into one doc. for each contact? The wizard just picks up each row and it creates a new doc. for each line... so a contact with 15 schools gets 15 docs.... this is what my excel doc looks like. <table...

Hoping someone can help with this complicated Macros. I need to Macro help - copy row, split data into multiple rows to create multiple entires for each row. I need to create a new row that copies model, type and size data and splits color code and quantity into separate rows. This is the...

Hello all, Hopefully someone can help me with this... I have two spreadsheets. The first one has all the schools in Los Angeles county in one column some accompanying data (class size, teacher:student ratio, etc.). The second spreadsheet is also a list of schools. Some of the schools are in...