ExcelBanter - matching data in 2 worksheets

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - matching data in 2 worksheets (https://www.excelbanter.com/excel-worksheet-functions/252604-matching-data-2-worksheets.html)

tabylee via OfficeKB.com

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

Bernard Liengme[_2_]

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

tabylee via OfficeKB.com

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

John[_22_]

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

All times are GMT +1. The time now is 04:27 AM.