EXCEL VBA PROGRAM MODIFICATION
Budget: ₹600 – ₹1,500 INR
I have uploaded here a macro enabled file(DUAL SHEET). It is designed to copy specific data from source files in a predefined folder sequentially and finally generate result files.
It is designed so that it selects specific data from a single sheet of first source file, copies the data to its own sheets and generates result file(having same data along with some formula based values), the result file being same name as source file. One by one all files from source folder is processed in this way.
However it has been designed to copy data from only one sheet of source file. Now it is required that data from two sheets of source files needs to be copied. The original vba has been modified by me to get the desired result. However it's showing some errors. Hence it needs correction.
Another feature needs to be added to same vba program, so that the all the data of result files needs to be copied and pasted as values only, on the same cells. It is required to get rid of unnecessary formula calculations and to reduce the size of result files.
Other two files uploaded are sample source files
It is designed so that it selects specific data from a single sheet of first source file, copies the data to its own sheets and generates result file(having same data along with some formula based values), the result file being same name as source file. One by one all files from source folder is processed in this way.
However it has been designed to copy data from only one sheet of source file. Now it is required that data from two sheets of source files needs to be copied. The original vba has been modified by me to get the desired result. However it's showing some errors. Hence it needs correction.
Another feature needs to be added to same vba program, so that the all the data of result files needs to be copied and pasted as values only, on the same cells. It is required to get rid of unnecessary formula calculations and to reduce the size of result files.
Other two files uploaded are sample source files