I am comparing some information and entering data into cells (obviously). What I'm entering are category names and numbers for products. They have to be entered by hand in the format of "Parent Category|Category Number|Category Name". It's tedious and I would like to be able to speed it up.
What I'm hoping for is a macro or VB code that allows me to enter just the category number into the cell, realize what I wrote, and change it to the proper format with the correct names. For example, I would enter 100 and hit Enter, and it would automatically change that cell to "Toys|100|Puzzles". I understand I would have to enter in all of the different categories into the formula or whatever by hand, but doing it once for each is better than having to do it repeatedly for all of them.
Any ideas?