hi, hopefull someone can help here I have a excel sheet which tracks payment accounts
Name A/C Number Amount per month Mar April May June July
P Roberts C001254 28.56 25.56 0 28.56 28.56 28.56
C Jones A00001 17.22 17.22 17.22 17.22 17.22 17.22
Currently we are manually inputing payments recieved each month from a .csv file recieved from our bank which contains the following info.
date description type amount
10/3 Benjamin D Skull C00001 CDT 28.45
10/3 Emma K Bick A00003 CDT 17.99
10/3 C Jones A00001 CDT 12.45
26/3 P Roberts C001254 CDT 8.21
this file is always called download.csv
I am trying to automaticly transfer data from download.csv to the main sheet and put the data in the right places is Vlookup the way to go?
Thanks in advance.