Modify and existing VBA excel macro
- or -
Post a project like this2283
$$
- Posted:
- Proposals: 2
- Remote
- #1805150
- Awarded
Description
Experience Level: Intermediate
Estimated project duration: 1 day or less
The Excel program is used for estimating with the ability to add infinite worksheets based on project size. The original developer which is no longer available wrote a VBA macro "Sheet8.SumMaterial"s that gathers material data and quantity from each work sheet between worksheet "A" and "B" and performs a consolidation of like materials. I have expanded the program and now populate materials on a 2nd location on each sheet that I want consolidated with the other materials. The new materials are located in cells AB101 thru AC1500. After materials are consolidated the macro "Sheet8.SortMatSumData" places the consolidated materials on the "MatSumData" worksheet.
The project I'm needing is adding the new material locations to the materials already consolidated with "Sheet8.SumMaterials".
The project I'm needing is adding the new material locations to the materials already consolidated with "Sheet8.SumMaterials".
Lee S.
100% (2)Projects Completed
2
Freelancers worked with
1
Projects awarded
50%
Last project
12 Dec 2017
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hello Sir,In your attached file ,there are 20 sheet.I can,t understand the main work.Can your clearly tell me what to do?Then I will bid.
547170
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies