I have a zipped file of excel spreadsheets. My main spreadsheet gives me a list of assets to search for within the zipped file. I need to locate/open specific spreadsheets in the zipped file, apply a formula, and move that calculation into main spreadsheet.
I need a macro/VBA to open the zipped file and to transfer the calculation into the my main spreadsheet. I already know which macro/formula to use once the spreadsheet is open.
I just need help with the formulas. Thank you!
Bu iş için 24 freelancer ortalamada $37 teklif veriyor
Hello Sir, I have read your project requirement and i can deliver your project with 100% quality . please give me chance to work on your job. Relevant Skills and Experience I have more than 7 years of experience in E Daha Fazla
I have 7 years of experience in Excel and VBA with 100% client satisfaction history. I can share similar project done before being hired. See my profile for client reviews. Relevant Skills and Experience Excel VBA MBA Daha Fazla
"Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. Thank you very much for your opportunity to bid" Relevant Skills and Experienc Daha Fazla
I can make it successful, please contact me to discuss further Relevant Skills and Experience Worked on Excel and VBA for almost 7 years Proposed Milestones $30 USD - Result
Excel VBA and Formula Expert Relevant Skills and Experience Excel Proposed Milestones $25 USD - Full Price
Hi, I went through the description. This job is quiet similar to my recent projects and my experience. Today can start to do this. I am looking forward to hearing from you On time delivery is guaranteed. Open fo Daha Fazla
Dear Hiring Manager, As I understand, you need help with the formula in excel. I am an excel expert and have worked with complex formulas. Recently closed few projects which includes recursive formulas for calculatio Daha Fazla
I am good at this part. Relevant Skills and Experience Excel,Excel VBA Proposed Milestones $55 USD - discuss
I'm a Excel VBA Expert with a lot of experiences Relevant Skills and Experience Excel VBA Proposed Milestones $30 USD - Total
Ya, we can use VB logic to search and fund the right file. Then copying etc can be done easily as long as the criteria is clear in your mind Relevant Skills and Experience Degree in Computer Engineering. 15 plus yea Daha Fazla
Hello, I have read your requirements that to open spreadsheet from Zip file and apply formula, and get calculation to main spreadsheet, I can do it perfectly with satisfaction. Relevant Skills and Experience I have 4 Daha Fazla
Ready for the assignment. I'm doing this kind of work since 2010. I believe that this work best suits me and I meet your expectations with quality and on-time delivery. Relevant Skills and Experience Excel, VBA, Macro Daha Fazla
Task 1: Open zipped file and iterate through the excel workbooks within. Task 2: For each worksheet apply formula and extract required information. Task 3: Write extracted info back to parent file. Relevant Skills Daha Fazla
DearSir,I feel that I am the exact match for your requirements after thoroughly reviewing the job description and desired skills. Relevant Skills and Experience Excel,Excel VBA Proposed Milestones $15 USD - milestone Daha Fazla