Otto M. - Data Matching
That makes sense.
I need help with this - I don't know anything about VBA. Is it used in a macro? Thanks - G "Otto Moehrbach" wrote in message ... Anything that you enter into any cell in the MATCH column will wipe out whatever formula or function or other entry that is already there. What you should do is enter your "matching" data into some other column and use VBA to look through all your data and put the matching data in the proper cells of the MATCH column. Post back if you think this would work for you and you need help with it. HTH Otto "Gilly" wrote in message et... Anything that you enter into any cell in the MATCH column will wipe out whatever formula or function or other entry that is already there. What you should do is enter your "matching" data into some other column and use VBA to look through all your data and put the matching data in the proper cells of the MATCH column. Post back if you think this would work for you and you need help with it. HTH Otto "Gilly" wrote in message et... I have a 3 columns of data: INFORMATION | TYPE | MATCH Jim Firstname Jack Firstname Tom Firstname Jones Lastname Smith Lastname Davis Lastname I have a list of data I need to enter into the MATCH column. I would like a function in the MATCH column that automatically matches the data I enter in the MATCH column with matching data in the INFORMATION column. For example, if I enter the following data into the MATCH column Jack Smith Davis The MATCH column function matches MATCH column data and INFORMATION column data: INFORMATION | TYPE | MATCH Jim Firstname Jack Firstname Jack Tom Firstname Jones Lastname Smith Lastname Smith Davis Lastname Davis I would really appreciate help with this Thanks - G |
All times are GMT +1. The time now is 04:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com