Excel VBA Expert needed - formula only

Closed Posted 6 years ago Paid on delivery
Closed Paid on delivery

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!

Excel Excel VBA

Project ID: #15618967

About the project

22 proposals Remote project Active 6 years ago

22 freelancers are bidding on average $37 for this job

schoudhary1553

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 More

$60 USD in 1 day
(328 Reviews)
7.9
bytessolution

A proposal has not yet been provided

$50 USD in 1 day
(162 Reviews)
7.0
avinav606lx

Hi there, Ping me to start , I can do this quickly. Thanks Aman

$30 USD in 1 day
(163 Reviews)
6.4
osmemon

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 More

$30 USD in 1 day
(33 Reviews)
5.6
prabakarm23

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

$30 USD in 2 days
(49 Reviews)
4.6
AhmedHassan1122

Excel VBA and Formula Expert Relevant Skills and Experience Excel Proposed Milestones $25 USD - Full Price

$25 USD in 1 day
(16 Reviews)
4.4
nelumindralal

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 More

$30 USD in 2 days
(25 Reviews)
4.3
chintuag

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 More

$26 USD in 1 day
(11 Reviews)
4.0
mikhailkozalski

I am good at this part. Relevant Skills and Experience Excel,Excel VBA Proposed Milestones $55 USD - discuss

$55 USD in 1 day
(7 Reviews)
3.7
Maheshpatel107

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 More

$30 USD in 1 day
(10 Reviews)
3.0
AnilTitusJacob

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 More

$30 USD in 2 days
(4 Reviews)
2.8
vl16vaidya

A proposal has not yet been provided

$30 USD in 1 day
(5 Reviews)
2.7
Jagannathpatra90

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 More

$20 USD in 0 days
(1 Review)
1.0
salahuddinmamun

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 More

$15 USD in 1 day
(0 Reviews)
0.0
myGISguy

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 More

$30 USD in 5 days
(0 Reviews)
0.0
kuldipgusani99

A proposal has not yet been provided

$30 USD in 2 days
(0 Reviews)
0.0
itsriteshbhatt

A proposal has not yet been provided

$27 USD in 10 days
(0 Reviews)
0.0