| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
matching data in 2 worksheets
Hi,
We have started entering our membership in an Excel workbook of about 500 names with names, age, birthday, address, tel no., mobile nos. 2 of us were assigned to enter the data in the same worksheet. Unfortunately, my associate opened a wrong file ( not the updated ones) and entered about 50 names in a separate file and sorted the names. Is there a reconcile the 2 worksheets? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/201001/1 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
matching data in 2 worksheets
Copy and Paste from Wrong to Right and re-sort?
best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "tabylee via OfficeKB.com" <u56588@uwe wrote in message news:a1b63de5ac3b4@uwe... Hi, We have started entering our membership in an Excel workbook of about 500 names with names, age, birthday, address, tel no., mobile nos. 2 of us were assigned to enter the data in the same worksheet. Unfortunately, my associate opened a wrong file ( not the updated ones) and entered about 50 names in a separate file and sorted the names. Is there a reconcile the 2 worksheets? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/201001/1 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
matching data in 2 worksheets
hi,
kindly explain further. Bernard Liengme wrote: Copy and Paste from Wrong to Right and re-sort? best wishes Hi, [quoted text clipped - 8 lines] Is there a reconcile the 2 worksheets? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/201001/1 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
matching data in 2 worksheets
Hi
Check this link http://www.cpearson.com/excel/Duplicates.aspx HTH John "tabylee via OfficeKB.com" <u56588@uwe wrote in message news:a1b63de5ac3b4@uwe... Hi, We have started entering our membership in an Excel workbook of about 500 names with names, age, birthday, address, tel no., mobile nos. 2 of us were assigned to enter the data in the same worksheet. Unfortunately, my associate opened a wrong file ( not the updated ones) and entered about 50 names in a separate file and sorted the names. Is there a reconcile the 2 worksheets? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/201001/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matching data between Worksheets in different Workbooks | Excel Discussion (Misc queries) | |||
| matching data on two separate worksheets | Excel Discussion (Misc queries) | |||
| matching and pasting data between worksheets | Excel Discussion (Misc queries) | |||
| matching data to merge two worksheets | Excel Discussion (Misc queries) | |||
| Matching/merging data from two worksheets | Excel Worksheet Functions | |||
Linear Mode
