Question about Microsoft Excel for PC

1 Answer

Merging problem merge two excel sheets with same columns with sum

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

    Governor:

    An expert whose answer got voted for 20 times.

  • Expert
  • 152 Answers

Use the Help function in excel and search for "Consolidate". This will show you how to consolidate data from multiple worksheets into one worksheet.

Posted on Mar 19, 2009

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Merge 2 columns with 550 cells each all at once?


Merging Columns In Excel Now that we've clarified what merging columns actually means, we can explore how to do it. The first step is to perform the merge for the first cells. Let's go back to our first example and suppose that we are merging column A that contains first names with column B that contains second names. We'll put the merged columns into column C. To merge cell A1 with cell B1 we woul type the following into cell C1:=A1&" "&B1


paste this into C1 (or where needed)
=A1&" "&B1

Jun 15, 2010 | Microsoft Office Excel 2007

1 Answer

When I try to merge my excel document with 250


Hi deloisr

It looks like you have chosen the wrong data file. Probably an earlier version of your data still present in some folder.
Check these
Do you have column headings for every column?
Make sure which folder contain the file? What exactly is the name?
When you are in the Microsoft word, make sure you select the correct data file for your mail merge. If you have selected the correct data file, when you attempt to insert the merge fields, there is no way, it give wrong field names.
The only reason you get the erong field names is because you have the wrong excel file for your data. Fix this problem first, then the rest will sort themselves out.
Have a good day.
luciana44

Nov 09, 2009 | Microsoft Computers & Internet

1 Answer

Unable to complete merge process.


Make sure you have closed the "data source" your excel file before trying to merge. This has been throwing different errors but not allowing the merge process to continue.

Is your Excel data in various worksheets or in the same worksheet - And does your Excel source data contain headers in the first row. Once you have selected this from the range you will

At what stage are you failing in the merge now?

May 15, 2009 | Microsoft Office Professional 2007 Full...

1 Answer

In one of my excel files, I found that the Merge Icon is Inactive, In tried all moods and options, but the Icon is still inactive, I also tried the ''format painter'' to make cells merged but it not...


This can be caused by the worksheet being protected. Check on the Review tab in the Changes group and see if the Protect Sheet or Unprotect Sheet icon is visible. If the Unprotect sheet icon is visible, then the sheet is protected and that would cause the merge cells icon to be inactive.

Apr 22, 2009 | Microsoft Excel 2003 (06503995)

1 Answer

Dear Sir, In case there are atleast 80 files or more having same format containing datas in columns in each file with different figures, I want to merge all file in a single sheet in one shot. Kindly...


Hi,

If the column names and orders are same across files, then you can directly use the MS Excel's import data function, this will do your job.

Alternatively, if you want to do it manually, import each file in separate excel worksheet using data import wizard or simple copy paste of data (in latter case you have to use Text-to-Col feature of excel), and then manually append all figures (copy-paste in one go) to any external excel sheet.

Then finally, export/save as that external sheet to any filename of your choice.

Hope this helps.

Thanks.

Mar 24, 2009 | Microsoft Excel for PC

1 Answer

Merge two excel sheets with same columns with sum.


Please give some data for sample to solve your query..

Sunil Charate
9763710696

Feb 19, 2009 | Microsoft Computers & Internet

1 Answer

Excel merge to word office 2007


Hi,

This might be an issue with the way you have your field set up.
Right-click on your field and select TOGGLE FIELD CODES until you can see the word "mergefield".

Assuming the name of your field is "mydatefield" , the code below should give you the required format.

{ MERGEFIELD mydatefield \@"DD/MM/YYYY" \*Mergeformat }

Good luck...

Jan 16, 2009 | Microsoft Office Professional 2007 Full...

1 Answer

Merging Data in 2 Separate Excel Workbooks


If the First Name and Last name are equal to both work sheets, I will just sort them by First Name and Last name and copy the results into a separate work sheet. If the names are different you will have to use Access: This can be easily done with Access and SQL, just import both work books into different tables to access and use the create query wizard, play with the results until you will get the result you want. Access will also solve the duplicate problem easily. Very important: You will have to use join properties: Read help about join properties and understand how this works... Afterward you can export it back to Excel or use Copy/Paste. If you can't use Access and have only Excel: You will have to use Vlookup on various fields until you will get the result you want. Its a hard work but in the end you will get the same result as access. Let me know what happend Daniel

Aug 20, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Excel for PC Logo

Related Topics:

143 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2635 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18333 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...