Results 1 to 3 of 3

Thread: Excel

  1. #1
    New Member
    Join Date
    Feb 2015
    Location
    Mpumalanga
    Posts
    4
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Excel

    Hi There

    Click image for larger version. 

Name:	Data.png 
Views:	154 
Size:	11.4 KB 
ID:	5393Name:  ID Keys.jpg.png
Views: 246
Size:  2.6 KB

    On the first picture (Data) including the amount is the branch that I want to insert automatically.

    I have the Terminal ID's in one colunm and the Branch in another as you can see in picture 2 (ID Keys)

    This is a bank statement that I have to add each branch in every month.
    I do not want to type the branch in every time.

    Is there an easier way to insert the branch into my bankstatement?
    All this is on excel and I can insert colunms if I need to.

    Kind regards,
    Tanya

  2. #2
    Gold Member vieome's Avatar
    Join Date
    Apr 2012
    Location
    joburg
    Posts
    524
    Thanks
    57
    Thanked 159 Times in 118 Posts
    Blog Entries
    36
    You could use Vlookup in excel. Attached a small example



    Sheet 1 will be statement. Sheet 2 will be fixed with branch numbers and Terminal ID.
    Attached Files Attached Files

  3. #3
    New Member
    Join Date
    Feb 2015
    Location
    Mpumalanga
    Posts
    4
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Hi Vieome

    Wow, thank you so so much.
    You will never know how long I've been trying to do this.
    I just realized that I did not understand how the vlookup was working.
    Always struggled with it.

Similar Threads

  1. [Question] Excel Help please
    By greghsa in forum Technology Forum
    Replies: 16
    Last Post: 04-Aug-14, 02:24 PM
  2. Excel info needed
    By CLIVE-TRIANGLE in forum Technology Forum
    Replies: 5
    Last Post: 02-Jun-14, 01:20 PM
  3. Excel Drop down box
    By sterne.law@gmail.com in forum Technology Forum
    Replies: 8
    Last Post: 04-Oct-13, 01:09 PM
  4. SASOL & EXCEL in trouble
    By Sieg in forum General Business Forum
    Replies: 5
    Last Post: 21-Oct-08, 11:17 AM

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

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