Hi,
Not got much knowledge of VBA, so thought i'd ask.
I have 2 workbooks, 1 has a report from my inbound dialler that shows numbers called and the disposition from one of our agents (sale, call back etc.), the other workbook is a download from Google Adwords that shows the calls made and keywords used. Both workbooks are from the same day.
I want to match the google report to the dialler report to tell me which keywords made which calls and the outcome of those calls. Preferably adding these to a daily table of keyword used and outcome.
Currently i'm using excel to do this but across 6 accounts on a daily basis, but it's taking a lot of time, will a VBA formulae be able to do this?
Thanks for the help
Not got much knowledge of VBA, so thought i'd ask.
I have 2 workbooks, 1 has a report from my inbound dialler that shows numbers called and the disposition from one of our agents (sale, call back etc.), the other workbook is a download from Google Adwords that shows the calls made and keywords used. Both workbooks are from the same day.
I want to match the google report to the dialler report to tell me which keywords made which calls and the outcome of those calls. Preferably adding these to a daily table of keyword used and outcome.
Currently i'm using excel to do this but across 6 accounts on a daily basis, but it's taking a lot of time, will a VBA formulae be able to do this?
Thanks for the help
Last edited by a moderator: