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!
26 freelance font une offre moyenne de $35 pour ce travail
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 Plus
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 Plus
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
"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 Plus
Excel VBA and Formula Expert Relevant Skills and Experience Excel Proposed Milestones $25 USD - Full Price
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 Plus
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 Plus
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 Plus
hey , i read your project description and i do your work of excel formula. thanks Relevant Skills and Experience Excel, Excel VBA Proposed Milestones $25 USD - milestone
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 Plus
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 Plus
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 Plus