Results 1 to 3 of 3

Adding Owner Name Based on Account Code in Column A

Threaded View

  1. #1
    Registered User
    Join Date
    08-31-2013
    Location
    Seattle
    MS-Off Ver
    Excel 2013
    Posts
    2

    Adding Owner Name Based on Account Code in Column A

    This is a copy of part of my long Financial Repor list in which I have to manually type in the name of the owners on top of each account in column B. It looks like below samples

    I want a macro that automatically insert the owner names on top of each account number on column B based on account code in column A. It looks like this: If 40 on Column A, insert Taylor on the top of Column B, if 50, insert Brandon; if 60 insert Duval and so on….Then I will continue finish your macro until reaching the end of my record.

    Thank you for your help! Tango

    A B C
    Taylor
    40 12.14 7/1/2013
    40 5.16 7/5/2013
    40 8.43 7/12/2013
    25.73


    Brandon
    50 6.12 7/1/2013
    50 8.19 7/5/2013
    50 125 7/12/2013
    139.31


    Duval
    60 5.78 7/1/2013
    60 6.45 7/5/2013
    60 5.12 7/12/2013
    17.35

    Carlos
    80 11.11 7/1/2013
    80 31.16 7/5/2013
    80 48.12 7/12/2013
    80 134 7/18/2013
    80 45.32 7/20/2013
    269.71
    Last edited by t.tango; 08-31-2013 at 02:13 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to censor account numbers based on how many characters are in the account number
    By Mcorydon in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-25-2013, 01:06 PM
  2. [SOLVED] Adding Values from One Column Based on Criteria in another column
    By andymc80 in forum Excel General
    Replies: 1
    Last Post: 01-30-2013, 09:29 AM
  3. Replies: 3
    Last Post: 04-19-2012, 10:45 AM
  4. VBA code for raw data + account code + dept id
    By mingali in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-06-2010, 07:29 PM
  5. adding values of a column based on another column content
    By gideong in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-16-2009, 11:53 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1