Combine Two Spreadsheets With Different Column Headings

 
=TRIM(E2)&Text(F2,"00")&Text(G2,"00")&Text(H2,"00000")

Ok, I am very very new so bear with me on this one. I have received several spreadsheets and would like to take the info from all of them and combine it into just one spreadsheet. Reason?: each spread sheet is the same format, but with different information. I want to be able to compare the data from same fields across diff spreadsheets and then if that data is the same to enter it onto the "master" spreadsheet. IF the data is not the same I would like it left blank so that I can see that I need to track down the right information IE: correct address.

Is there a certain process I should do? IE: combine the spread sheets and then convert that one master spreadsheet over to Access DB? My goal is to have one DB or spreadsheet that can be used. I would like to be able to querry the db maybe for all contracts expiering in the next qtr.... help any one??? or just ideas?

Ok, I am very very new so bear with me on this one. I have received several spreadsheets and would like to take the info from all of them and combine it into just one spreadsheet. Reason?: each spread sheet is the same format, but with different information. I want to be able to compare the data from same fields across diff spreadsheets and then if that data is the same to enter it onto the "master" spreadsheet. IF the data is not the same I would like it left blank so that I can see that I need to track down the right information IE: correct address.

Is there a certain process I should do? IE: combine the spread sheets and then convert that one master spreadsheet over to Access DB? My goal is to have one DB or spreadsheet that can be used. I would like to be able to querry the db maybe for all contracts expiering in the next qtr.... help any one??? or just ideas?

Is it possible to combine multiple spreadsheets into one. I have approximately 6 spreadsheets that have 11 columns in each spreadsheet. Some of the data is the same in each spreadsheets but other data is different. What I would like to do is maintain the data that is the same in each one, addiing only data that is different.

Thanks in advance,

Greg

Hi there this is my first post. I am trying to merge two spreadsheets one which just has predefined column headings and the other which is data received from clients in their format. I need to merge this to a new .csv file.

This would ideally be VB as I need others to run this without me being around.

Example sheets would be:

Open workbook1 from client

Col1, Col2, Col3, Col4,

I will then need to combine this with workbook2, this contains the headings, which would not be open at the time but will always be stored in a specific directory.

Then take the headings from Workbook2 and ensure Col1 from Workbook1 will go to Col3 of workbook2 and so on. Repeating this for many rows.

If you need further information please ask.

thanks for your help

Here is my query

Sheet A has got 30 columns
Sheet B has got same headings than Sheet A but in a different order.
Is it possible to combine both sheets without having to manipulate the order of the columns?
The code below combine 2 sheets that have got the same headings in the same order. Is the re away to modify it without adding lines of extra code to rearrange the columns?
[Code]
Sub Combine()
Dim J As Integer
On Error Resume Next
Sheets(1).Select
Worksheets.Add ' add a sheet in first place
Sheets(1).Name = "Combined"
' copy headings
Sheets(2).Activate
Range("A1").EntireRow.Select
Selection.Copy Destination:=Sheets(1).Range("A1")
' work through sheets
For J = 2 To Sheets.Count ' from sheet 2 to last sheet
Sheets(J).Activate ' make the sheet active
Range("A1").Select
Selection.CurrentRegion.Select ' select all cells in this sheets
' select all lines except title
Selection.Offset(1, 0).Resize(Selection.Rows.Count - 1).Select
' copy cells selected in the new sheet on last line
Selection.Copy Destination:=Sheets(1).Range("A65536").End(xlUp)(2)
Next
End Sub
[\code]

Hi,
sorry if this is a newbie question.
I have 2 spreadsheets each having one column of names and several columns of data for each name. Many of the names are the same, but the columns do not match exactly. I am trying to merge the two spreadsheets so that there is one column with all the names from both spreadsheets with the corresponding data for the names. However, I cant figure out how to make excel recognize the identical names and put all the data from both spreadsheets on the same row with that name.

Ex:
spreadsheet 1:
Steve 343 45 23
Paul 32 3 23
Frank 223 23 12

spreadsheet 2:
Tom 33 76 6
Steve 23 34 3
Paul 1 334 45

I would like to combine the data so that all the names are shown, but Steve and Paul are only shown once. There would be six columns of data, so I dont need that combined.

Does anyone know how to do this?
I appreciate your help.

Hi gurus,

I have a few spreadsheets I am using daily. One spreadsheet per customer (it contains up to 20 sheets, 1 sheet per product). All I need to do is to combine all those spreadsheets into one. But in that case it is very easy to get lost as you are handling huge amount of data. So, I made one spreadsheet (one sheet per customer with all products in it). I want to have a button for each product which would unhide the relevant to the product columns. I have made a very visual dummy example. It will tell you more.
Any help will be much apreciated.

Thanks a ton guys!

Hi all - I have a weekly task to combine 16 spreadsheets sent to me into one document.
Each workbook is identical containing the same format just different figures (weekly report)
Is there a quick way to combine these spreadsheets, so that rather than 16 .xls files they are one file with 16 tabs?
The current method of copy and paste works fine - but would be great if there is a process to speed this rather mundane weekly task!

Hi guys I need some assistance. I have two spreadsheets which I need to combine to provide the data in one table. The two spreadsheets must be combined based on the columns "EMIS NO" which are in both sheets and must contain all the information as provided in the various columns of the sheets. In the attachment it can be seen that the two sheets do not have the same number of rows as some of the information is not available. Can somebody help with a way of doing this? Is there a formula consisting of "IF" , "THEN" statements that can be used. I have tried a number of the functions but could not achieve the desired results.

Hi, I am still trying to get familiar with VBA. I have two spreadsheets with the same format and would like to have some VBA codes to automatically combine the two spreadsheet into one. Can some one point me to the right directon?

Thanks a lot!

I have a list of 1200 serial #'s of assets belonging to my company and I need assistance in combining four very large spreadsheets into one complete accurate spreadsheet. The three sheets include data about model, location, department, addresses, account numbers. etc., and were made by three different people, (sources). The problem is, some spreadsheets have missing or out of date information, different formats, different column headings, # of columns etc. Also they are all sorted differently, but most of the information is similar for each serial #. Example: There is a location associated with each serial# but some of the addresses don't match on each sheet. The sheet that is the most accurate and up to date is missing columns i need from the others such as account# or order#. How can i match the serial # with information from each sheet?

I need to develop one master sheet that contains the updated information for each serial number and was wondering what the easiest way to take all four sheets and combine them without updating each one seperately.

Thanks for the help!

I have two spreadsheets. They share data in four columns (first name, last name, title, company). One spreadsheet also has an ID number column, the other has a Business Type column.

The rows don't synch up (there are 32,000 rows), and the number of rows in each sheet is not an exact match. I need to combine these spreadsheets into a single document so that each row has all of the relevant data--I need to filter/match on first name, last name, title, and company, and then add the business type and the ID number all into a single spreadsheet.

Can anyone help? I'm totally new to macros, I've worked with formulas somewhat, and I don't have MS Access. Using Excel 2010.

Thanks!

Hi guys, hope you can help!

Essentially I have two spreadsheets, both with independent columns of data. However, both of them share a common column, row b. Row b contains the same type of data in each sheet, but one sheet has 1300 entries and the other 1600.

What I need to do is in a third spreadsheet, compare the two sheets together and where data is missing from sheet 1 that is present in sheet 2 and vice versa, get them to appear in sheet 3.

Does this make sense?!

Many thanks for your assistance.

Brian

I have two spreadsheets. They share data in four columns (first name, last name, title, company). One spreadsheet also has an ID number column, the other has a Business Type column.

The rows don't synch up (there are 32,000 rows). I need to combine these spreadsheets into a single document so that each row has all of the relevant data--I need to match on first name, last name, title, and company, and then add either the business type or the ID number based on the matches.

Can anyone help? I'm totally new to macros, I've worked with formulas, and I don't have MS Access.

Thanks!
Steve

I am so frustrated to combine several spreadsheets into all in one, and seperate all in one spreadsheet into several with the same header frenquently. Pls check the attached example excel spreadsheet., could anyone teach me how to program in vba to achieve the result as above?

Many thanks.

Which is better for this job: Access 2007 or Excel 2007
I have many spreadsheets some with two worksheets with nearly the same columns (essentially it says Windows COA in one column and Office COA in the equivalent column on the second worksheet) and some with one where there are nearly the same data ( although one header column on the one sheet. A) I want to automatically add a field saying the source spreadsheet name for each spreadsheet and a field for some spreadsheets as all the lines have already been checked. B) I want to combine the data so that I can parse from one name to the next easily to check what is listed on another online database.

I have seen several ways to do B) but is it better to do an equivalent task with Access 2007 or Excel 2007 as I have access to both- there maybe 36 files with 60 lines and 10 columns each to combine? and I would be happy to be directed to a thread referring to something like the A) task. This is just a working document. I haven't yet looked for the tools to this with Access.

Is there anyone here that can create what I think would be a simple macro for me? I will gladly pay for your assistance!
I have no idea how to do this or use macros, and trying to figure it out myself is getting very frustrating.

I use Excel X for Mac.

Every month I need to create several spreadsheets by pulling out several columns from spreadsheets I download. The spreadsheets I am downloading have columns A to EW.

I need to copy out of the spreadsheets the same columns each time, but it is VERY time consuming to go through each one and highlight each column I need to copy them and then paste into another sheet.

I would like some way that I simply can copy all of the columns I need without going through the entire spreadsheet highlighting each individual one. Then I can just paste it easily where I need to into the new spreadsheet.

The following columns are what I need to copy out:

D, F, G, I, K, L , P, S, V, W, Y, AB, AC, AI, AS, EU, EV, EW

Thank you so much for any assistance.
-Richard

Hi

I have a problem

I have 2 spreadsheets which I need to combine

both have various codes in column A and values in columns C TO F

some codes appear in 1 spreadsheet and not in the other

how do I combine these 2 into a third one which holds all the codes from both sheets and adds the values for the correct codes in cols C to F on sheet 3

at present I have tried vlookup but cannot work out how to get rid of na error when code appears on one sheet but not on the other however it does work if code appears on both sheets.


Thanks
ricky

Hi all,

I have a fairly complex spreadsheet (5k+ rows and 25+ columns) where I am trying to combine data from several different columns into a simpler format in order to populate a summary report I have to submit each month.

I've come up with a HUGE formula full of IF statments to try and combine the columns if certain criteria are met. I've gotten the single and double line entry formulas working correctly but when I try to combine data from several different rows, the formula becomes too much to manage.

I'm looking for suggestions on how to combine the data more efficiently. I'm open to any method that would work... VBA, adding more columns, formulas... anything.

I've created a very simplified example file with only the columns that affect the formulas I'm trying to figure out.

In the attached example, I need to combine data from orders from different companies. I need to combine model and serial numbers affected by the purchases based on the models ordered and the serial numbers that incorporated the changes from the production line (ie the specific serial numbers that incorporate your change are x, y, z).

The sheet "Example 1" will not be seen by anyone else in the company so I can manipulate the data any way I need to. The sheet "Summary Report" is the format in which I need to display the data and the format is pretty much set in stone.

Thank you in advance for your thoughts and please let me know if you have any questions...

Hi,

I have a bit of a complicated problem. I want to create a macro that goes into about 25 folders each day, sees if there is a new spreadsheet (that could have a slightly different name each time) and then goes into that spreadsheet and pulls out five different columns, puts that in a new master spreadsheet, and then closes it. (So now I would have the information from 25 different spreadsheets all in one master sheet) Is this even possible?

Thank you.