PDA

View Full Version : VBA help



daggerol
10-16-2016, 04:30 AM
Good day,


I'm daggero, I'm an accountant in a small company that sells credits via text messaging.
I read that vba can make my daily report easier, unfortunately I don't have any knowledge about VBA

i have attached 2 files
1733517336

week report and masterfile

from what I've been doing eversince is that I look for matching numbers
from my week report file to my masterfile
once I find the matching number i then look for the correct date.
once I find the number and the correct date I copy the amount from the master file net column
and paste it on the week report file... I do this manually...

now I've been reading about vba for excel since yesterday and looking at sample codings or syntax... (I don't know what it's called), sorry.
but I still don't know what is what...
but I think i get the logic (please correct me if i'm wrong

"
Insert command button

find matching number from columnA week report file and masterfile
if a number match is found, find the matching date from B5,C5,D5,E5,F5
if date match is found copy value from column D masterfile.sheet1 in line with the number searched
and paste the copied value to columnB weekreport.mon inline with the number
else move to the next line until the end of numbers listed"

my problem is (if this is correct) how do write this using VBA language
thank you so much in advance I hope I can find help. I'm using office 2016 by the way