Lee L
Supporting Actor
- Joined
- Oct 26, 2000
- Messages
- 868
I need to search the data in several spreadsheets to find matches. They are basically Excel sheets with rows of names and numbers. I need to find a way, preferably automatic, to take the value from cell B1 on the first sheet for example and then compare it to the values in cells B1:B300 on another sheet, then value B2, B3, so on and so on. Then, for all the matches I would like to either return the corresponding values in Cell A1, 2, 3... into another sheet or maybe change the font color of A2:B2 to red or something so I can find the matches.
In looking through help it seems like the MATCH function is what I need but I'm not sure how to change the font or dump the value to another sheet based the location returned by MATCH. Also, I'm not too sure how to automate this in Excel. The last time I did any programming was PASCAL and FORTRAN in High School, 15 years ago.
In looking through help it seems like the MATCH function is what I need but I'm not sure how to change the font or dump the value to another sheet based the location returned by MATCH. Also, I'm not too sure how to automate this in Excel. The last time I did any programming was PASCAL and FORTRAN in High School, 15 years ago.