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.