Excel

[Tanya Kruger]

Hi There



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