Is it possible in excel to take a Keyword and swap or associate it with a Category Description list somewhere
For example:
A01 Means A01: Cats
A02 Means A02: Dogs
If my application exports keywords "A01" only. Is there an automated way to match them up with the specific Description string "A01: Cats"?
Basically swapping Keywords for Full Descriptions, without manually doing it by hand?
As long as the descriptions (for all possible exported keywords) reside somewhere in the workbook, it is easily doable. Do they?
Perhaps it was the Noid who should have avoided me...
If you are satisfied with my solution click the small star icon on the left. Thanks
1. Make a copy of your workbook and run the following code on your copy (just in case)
2. With excel open, press ALT+F11 to open the Visual Basic Editor (VBE). From the "Insert" menu, select "Module".
3. Paste the code from above into the empty white space. Close the VBE.
4. From the developer tab, choose "Macros", select the Sub Name, and click "Run".
Yes the descriptions will be located in a separate sheet in the workbook. Just need a way to match keywords with descriptions, and swap themOriginally Posted by AlvaroSiza
Anyone know how to perform this in Excel?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks