Find Jobs
Hire Freelancers

Excel VBA / Pivot Table programmer

£20-250 GBP

Teljesítve
Kiadva ekkor: majdnem 3 évvel ezelőtt

£20-250 GBP

Teljesítéskor fizetve
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
Projektazonosító: 29886752

A projektről

8 ajánlat
Távolról teljesíthető projekt
Aktiválva: 3 évvel ezelőtt

Szeretne pénzt keresni?

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet
Kapja meg fizetését a munkáért
Vázolja ajánlatát
Ingyen regisztrálhat és adhat árajánlatot munkákra
Neki odaítélve:
Felhasználó avatár
£0 GBP 1 napon belül
5,0 (223 értékelés)
6,8
6,8
8 szabadúszó adott átlagosan £150 GBP összegű árajánlatot erre a munkára
Felhasználó avatár
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 3 napon belül
5,0 (243 értékelés)
8,1
8,1
Felhasználó avatár
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 1 napon belül
5,0 (33 értékelés)
4,6
4,6
Felhasználó avatár
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 1 napon belül
4,8 (18 értékelés)
3,7
3,7
Felhasználó avatár
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 5 napon belül
0,0 (0 értékelés)
0,0
0,0

Az ügyfélről

UNITED KINGDOM zászlója
Edinburgh, United Kingdom
0,0
0
Fizetési mód hitelesítve
Tagság kezdete: ápr. 15, 2021

Ügyfél-hitelesítés

Köszönjük! E-mailben elküldtük a linket, melyen átveheti ajándék egyenlegét.
E-mailje elküldése során valami hiba történt. Kérjük, próbálja újra.
Regisztrált Felhasználók Összes Közzétett Munka
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Előnézet betöltése
Hozzáférést adott a helymeghatározáshoz.
Belépési munkamenete lejárt, és kijelentkeztettük. Kérjük, lépjen be újra.