Macroman

Hey nevermind, I found the edited and it works great, thank you Terry!

Can you upload the fix? Thanks!

Thank you terry!

Terry, I tried the sample macro you provided and it works for the entry on line 1, but not line 2 or 3 any thoughts? Do you think it'll be better to use a csv file? Thanks

Terry, I tried the sample macro you provided and it works for the entry on line 1, but not line 2 or 3 any thoughts?

Thanks all, I will give these methods a try!

It's a text file, hasn't much been made yet as I'm trying to figure out how to snag those details. CSV would be better to organize in my opinion if that's doable. I'm currently using macro express pro I basically want two columns one with names and one with the numeric user id, and the same with an acronym macro which has two columns of text. I'm just at home so I don't have access to the macro but I believe it would need a redesign based off what Cory was saying

It's basically as such Column 1 Column 2 12345 Smith, John 44921 Jones, Mike etc. there is about 40 of these also with acronyms, same thing Column 1 with the acronym Column 2 with the explanation

I had tried using that, but it didn't seem to work. No rush but if you could elaborate in the future, that'd be great!

I'm also not married to the idea of using a text file, if it's possible to snag the information from column 1 and column 2 csv that would probably be more ideal.

So i'm trying to make this macro look up a user id number from the text file and display the name associated to it. If the number doesn't exist, it works correctly. If it finds the number it displays the whole file. Any ideas on how to make it just display the person that is associated to it? Also I want to do the same with acronyms, will the same method still work I appreciate the help Thanks