Results 1 to 8 of 8

VB Code to create DICT

Threaded View

  1. 08-26-2017, 01:28 PM #1
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    VB Code to create DICT

    Hello:

    Please refer to attached file, sheet "Debit".
    Based on what is in column C, i need to get values in column D as below:

    If STREAM GEORGIA G BILL PAY 4001573008 then value in correcponsing cell in column D would be Utilities:Gas
    If FOODSERVICE VENDOR PAY 072691182550000 then value in correcponsing cell in column D would be Cost of Goods:USFoods

    etc

    Bascially i would need to create VB Dictionary i guess, not sure.
    Please help.


    Let me know if you have any questions.
    Thanks.

    Riz
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] "Store Value in DICT and Change Color if not exist"
    By daboho in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-05-2017, 06:56 AM
  2. write code to skip two tabs, create a tab, code, skip two tabs, create a tab, code, etc
    By elmasguapo in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-14-2015, 06:01 PM
  3. Script dict displaying one row instead of all applicable rows ?
    By leanne2011 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-02-2014, 02:58 PM
  4. [SOLVED] Help me fix attached code (create Outlook email then create calendar item)
    By Rerock in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-19-2013, 08:15 PM
  5. why how does this code create a new sheet after the last line of code...
    By tconnell1965 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-31-2013, 06:23 AM
  6. How to create a form to insert a hyerlink.VBA code to create a for
    By karthi in forum Excel General
    Replies: 0
    Last Post: 07-05-2006, 06:30 AM
  7. Create a newworksheet with VBA code and put VBA code in the new worksheet module
    By ceshelman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-15-2005, 12:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1