Dear All,
i am new to VBA and really have no idea how to even start coding except for auomation of formatting in excel.
I am very sorry to ask this without any background code like may of you post to give a start... but i really have no idea how to start.
I do a lot of repeat Vlookup everymonth for about 45 excel tables... and it really takes a lot of my time to do this manually. I wonder if you can please help me with a solution whihc make my life simpler.
I have 45 customer tables for each city one. And i also have 45 different customer details files by each city. The scores and discount rates change everymonth based on savings and spends. I do a vlookup every month for each file and get the SCORE and DISCOUNT RATE into my base file. I have a master file which says from whihc file i need to copy for each file.
Is it possible that i open the MASTERFILE and run the vba code so that vba can open file one, say BOMBAYCUSTOMER201601 and then open the corresponding BOMBAYCUSTDETAILS201601 file, and vlookup the customer name and bring the column B and Column E into the BOMBAYCUSTOMER201601. Also, the number of records can keep varying...
I would be very grateful if someone can please help me with such a code. I have attatched sample files and master file. Many thanks in advance.
Best regards
Sonia
i am new to VBA and really have no idea how to even start coding except for auomation of formatting in excel.
I am very sorry to ask this without any background code like may of you post to give a start... but i really have no idea how to start.
I do a lot of repeat Vlookup everymonth for about 45 excel tables... and it really takes a lot of my time to do this manually. I wonder if you can please help me with a solution whihc make my life simpler.
I have 45 customer tables for each city one. And i also have 45 different customer details files by each city. The scores and discount rates change everymonth based on savings and spends. I do a vlookup every month for each file and get the SCORE and DISCOUNT RATE into my base file. I have a master file which says from whihc file i need to copy for each file.
Is it possible that i open the MASTERFILE and run the vba code so that vba can open file one, say BOMBAYCUSTOMER201601 and then open the corresponding BOMBAYCUSTDETAILS201601 file, and vlookup the customer name and bring the column B and Column E into the BOMBAYCUSTOMER201601. Also, the number of records can keep varying...
I would be very grateful if someone can please help me with such a code. I have attatched sample files and master file. Many thanks in advance.
Best regards
Sonia