finding matching text (Excel 97)

Topic

New Reply

You will have to be a lot more specific. I am not sure what you want to check, what criterion, etc

Do you want to check, for example:
Cell A1 of each sheet and they must be identical on all sheets, then A2, A3, etc then
Or
Do you want to make sure that some type of “master list” contains all the NEW entries
Or
Something else?
Could you provide a sheet with couple examples of changes/the same entries and what you want to do with the info.

Steve

Reply | Quote

Replies

Please help! I have a worksheet that gets updated every month. How do i tell excel to find all the text that does not match. Example. Headings are “Name” in A1 and “Address” in B1. Every month a new name is added or the address is changed. Example in January the names and address may be John-MT,Mary-ND,Ken-SD. In February it may change to John-MT,Tom-TX,Ken-OK. I want to tell excel to look in sheet 1 then look in sheet 2 and tell me which names and address changed or stayed the same.

Reply | Quote

Steve thanks for checking my problem. I have updated the information to make it hopefully more understandable. A list for all new or changed entries is what i’m looking for. In my example John-MT is the only name that stayed the same. What we do now is make a print out of the new and old list. One person reads off the names and address while the other person Marks any changes, then we make a new worksheet and we have to type in all the updates or changes that were made. It takes about 4 days to do this.

Reply | Quote

Buckshot,
I have attached a workbook that shows one way of doing what I think you want. It involves inserting two columns on each sheet. The first column has formulas that add the strings together from col A and col B (Matt and TX becomes MattTX). The cells containing these formulas is assigned a range name (JanList on sheet JAN and FebList on sheet FEB). The second column has a formula that determines if the combined string exists in the named range on the other sheet.
Then all you have to do is sort the data (on sheet FEB) based on the column that indicates if it is a new name or an existing name and copy the desired rows to the new sheet.
I am sure there is a way to do this with VBA but the process I laid out could be done manually in less than 10 minutes.

Chuck

Reply | Quote

Thank you very much. It works great. You saved me alot of time

Reply | Quote

I am assuming that there is more to your data than just 2 columns which means that we can’t give too much example code.

You could combine ALL the rows together then use an advanced filter to extract out a list of the unique entries

To get “modifications” I assume that you have some ID or something to demonstrate that they are identical “people” but that have moved. You could add a column to look for “unique” on the code using match, for example, to find NEWER entries. Then you could use an AUTOFILTER to get list just the OLD ones and delete them.

This could be done manually or with a macro, though we would need a lot more info to help in writing a macro.

Steve

Reply | Quote