Search : in
By :

Merge Data From 2 excel sheets and add sales

Joce, on Sep 24, 2009 4:08:22 pm BST 
 Report this message to moderators

Hello,
I have information in 2 separate excel worksheets. Column a in both sheets contains an alphanumeric part number. Column B in sheet 2 contains sales info. Column a on both sheets are in different sequence. How can I match the part numbers on both sheets and then if the part numbers match, take the sales info from sheet 2 column B and inset into sheet a column b?

Configuration: Mac OS X
Firefox 3.5.3

Best answers for « Merge Data From 2 excel sheets and add sales » in :
Compare 2 excel sheet and combine uniq data Show
How to compare 2 excel sheet and combine uniq data? Show How to compare 2 excel sheet and combine uniq data? Issue Solution Note Issue I have 2 excel sheets , A and B. There are redundant data in both sheets as well as uniq. All i want is to combine both with no redundant records. (A+B...
Comparing and extracting data in Excel Show
Create an Attendance Report with Excel sheet ShowCreate an Attendance Report with Excel sheet Issue Solution Issue In the case you want to create an attendance report with Excel , here below you will find a nice example: Consider that your report will have the following...
Avoid duplicates in Excel ShowAvoid duplicates in Excel In order to avoid duplication when encoding in a column from an excel sheet: take the conditional format on the first cell under the headings (eg A2) choose the following formula:...
How to freeze a row in an excel sheet ShowHow to freeze a row in an excel sheet To freeze a line in an excel sheet, for example line 1: Select line 2. Go to menu Window and select Freeze panes.
Ask your question Reply
They need your help