Find Jobs
Hire Freelancers

Excel VBA / Pivot Table programmer

£20-250 GBP

Completed
Posted about 3 years ago

£20-250 GBP

Paid on delivery
Hi, i am an architect looking to hire a programmer to improve the usability of a giant & unweildy spreadsheet I use for writing building specifications. What I currently have, and how I use it: The spreadsheet is split into 20-30 tabs for each 'Work Section', and within each section, there are many (sometimes hundreds) of 'Clauses', which are grouped rows of info. All, some or none of these clauses might be applicable to a particular project. Seperate to excel I use BIM software for the drawings, which can easily generate me an excel list of all the applicable clauses used on the drawings. Currently, I take the 'applicable clauses list', then edit down a master office specification for each project by trawling through, hiding the tabs/sections I dont need, then hiding the clauses i dont want to appear in the final project spec. The output is generally a pdf or a4 printed document that gets sent out to third parties for costing. The problem: The issue i have is that manually hiding groups by going through the spreadsheet is time-consuming, and fragile - in that you might accidently unhide everything whilst looking for a hidden clause, and need to restart the whole process. Because the whole group is hidden, including its heading, it can be difficult to 'find' a clause that has been hidden by accident - often leading to the error noted above. What I need: Some method whereby I have a list of all clauses(groups), with some kind of checkbox to strike out the non-applicable clauses. That checklist should then automatically hide the relevant clause(group) from the document, leading to a print document that only contains the relevant info. I've back engineered a few VBA codes to do things like create a contents page and such, and know my way around excel a bit - so i've got a basic idea on what can be done - but am in no way a programmer - hence my appeal to a specialist in this feild! If you think this might be possible using VBA or another method, please get in touch with an idea of costing. Thanks in advance Euan
Project ID: 29886752

About the project

8 proposals
Remote project
Active 3 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
£0 GBP in 1 day
5.0 (223 reviews)
6.8
6.8
8 freelancers are bidding on average £150 GBP for this job
User Avatar
Dear Employer, I am an Excel expert and have delivered over 1000 projects since over a decade now. I have checked your project details and will ensure highly professional delivery. Kindly check my previous reviews here for your kind consideration: https://www.freelancer.com/u/asin1987 Hope to connect soon!! Thanks, Ashish
£250 GBP in 3 days
5.0 (243 reviews)
8.1
8.1
User Avatar
Greetings Thanks for checking my proposal. I have understood your project and can start your project immediately. I knew this problem and usually faced when sending to clients. I have many solutions for this. I can use power query to make new table only to show required information. No need to hide your original data. As it collect data from it and make new table. It is advance feature of Excel. I can use VBA also for it. We can discuss it further. I am full- time freelancer having job experience of more than two decades. It included more than decade of experience as Manager in Public Listed Companies. I have also developed many softwares in MS Access. It is my practice to do one project at a time therefore I would assist you full time according to your available time. You can check my scores and reviews Hoping for the positive reply from your side for a long-lasting working relationship. Regards
£50 GBP in 1 day
5.0 (33 reviews)
4.6
4.6
User Avatar
I can perfectly help you with that. I am a professional Data Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Google sheets & Excel (including VBA and Macro) to perform Data Analysis, Data Visualization, Financial Analysis, Financial Modeling and various types of Analysis, Automation and complex calculations. I will be happy to discuss in detail how I am highly suitable for this project. Thanks Jayant
£40 GBP in 1 day
4.8 (18 reviews)
3.7
3.7
User Avatar
Hlo sir..I read your project description..I have graduation degree in IT..and have high skills of ms office..I have been working on word excel ppt file conversion and typing for soo long... I will complete this project on accurate time with work effeciency. Thanks
£111 GBP in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Edinburgh, United Kingdom
0.0
0
Payment method verified
Member since Apr 15, 2021

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.