User Forms to Search, Display and result

[Guido Geurs]

Would it help when I write a form for standardizing the data in the 3 columns?

[Guido Geurs]

Hello Sandy,
I'm back on this call and working on a tool for standardizing the data.
Do You still want it?

[sandy armstrong]

Yea that would be awesome!!! thanks SO much!!

[sandy armstrong]

I would love that... Thanks Guido that awesome...

[sandy armstrong]

Hey Guido I am going to Uplaod a search user form that im using Can i use that same one that you helped me with but with some modifiations and changes to fit this porpose or do i need to create something from scatch.

[Guido Geurs]

As promised, attached is a tool to standardize the data in the sheet.

PS:
There is a note of Bytes in which they ask to close a call once an answer is accepted as a solution for the call.
If you have an other question (even in the same project), please open an other call.

For this call: I must still look at your last question for the modification of the "search User form".
But if there is a problem with the "Standard" tool, please open an other call.

[Guido Geurs]

For your last question with the file "Bytes.zip" : there is no Userform2 in the VBA environment !?

Please if this is a new search form, place it in a new call (see previous answer)

[sandy armstrong]

Wow thanks Guido!!!! this is a great tool that we can use to Standardize new data. this is perfect!!!!!! thanks guido i really thank ful you could help me with this I knew we were going to run into troble if we didnt have everything standardize.

[Guido Geurs]

This is a new version of the tool.
- Easy to use
- The possibility to change more than one wrong data at once. (like: "#NY", "NY##", "Ny", "ny", ... to "NY")
- Save standards to file for later use.
-....

[sandy armstrong]

Hello, GUido thanks for this tool I was trying to use the user form that is used to add the PPO# but i keep getting an error on
ARRDUMP = Range("G2").Res ize(ROWlastREC, 2)- this line
But this is sooo cool Im in love with this! thanks soo much

[Guido Geurs]

I think we have to pick up the user-form "Search" again because I have seen that the code is NOT OK.
We have stopped to develop it because we had first to standardize the data and develop the tool for it = user form "standardiz e".
Now that we have standard data, we can continue with the user form "search".
I will pick it up as a next project.