EXCEL VBA PROGRAM MODIFICATION

Completed Posted 1 year ago Paid on delivery
Completed Paid on delivery

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

Excel VBA Excel Macros Data Processing

Project ID: #34746631

About the project

15 proposals Remote project Active 1 year ago

Awarded to:

sambit2723

Dear sir/Mam, I hope you are doing well. I am very confident with VBA,EXCEL as 5 years of experience. I have gone through your project details. I can start working immediately and try to complete as soon as possibl More

₹600 INR in 2 days
(2 Reviews)
0.5

15 freelancers are bidding on average ₹1568 for this job

PERPETUAL0

Hello Sir , Iam excel expert level with top rating done projects before I can done this within short time also i can provide previous samples for make you understanding better about me and my skills. When do you need t More

₹4566 INR in 1 day
(156 Reviews)
5.9
ismail80196

Hi, I understand perfectly your requirements. I am ready to start right now. I have strong knowledge about EXCEL VBA PROGRAM MODIFICATION. I am ready to start work right now and can assure the best service from my end. More

₹2000 INR in 1 day
(6 Reviews)
3.2
vw1514518vw

Ready to fix the errors, correct and modify the macro to perform exactly as you described .....

₹4000 INR in 2 days
(3 Reviews)
2.7
Sochi4real

Hi! Pleased to meet you on this platform. I just read through your job details and I'm interested in taking a crack at configuring the macros to fit your desired requirements. Let's discuss further. Warm Regards. B More

₹1050 INR in 7 days
(2 Reviews)
1.4
excel4engineers

Thank for your detailed instructions. I checked the examples. I can do it today. The required two features will be provided.

₹1000 INR in 1 day
(2 Reviews)
1.7
suresh2580

Hi sir/ madam I am senior data analyst with advance excel and vba with automation for routine work. also, I can handle SQL, UiPath, please let me know I can help you further Thanks Regards Suresh M Data analyst

₹1050 INR in 7 days
(1 Review)
0.6
AsimMunir77

Hello, I am interested in your project and i can complete it within required time. I have appropriate experience in Microsoft Office Products(Word, Excel, PowerPoint, Visio, Project as well as VBA etc) of more than 10 More

₹1000 INR in 7 days
(1 Review)
0.6
officialankush77

I can feel the data as soon as possible before the time and delivered on time give the best from me

₹1050 INR in 4 days
(0 Reviews)
0.0
trhbehzade

Hi, I am an expert in Excel and VBA. I have done several projects in which I have done any task using programming in VBA. I can do it quickly and will provide you with quality and fast work. Can we discuss all your nee More

₹1050 INR in 7 days
(1 Review)
0.0
HammadMustafa303

My name is Hammad Mustafa . I completely my studies in intrmidiate in ICS . I am perfessional in this work .

₹1050 INR in 7 days
(0 Reviews)
0.0
Bwatter

Hello Client, I am available and ready to help you modify your macro enabled file(DUAL SHEET) designed to copy specific data from source files in a predefined folder sequentially and finally generate result files. I am More

₹1050 INR in 1 day
(0 Reviews)
0.0