Find Jobs
Hire Freelancers

Excel Spreadsheet with search function enabling a summary sheet to be created

£20-250 GBP

Closed
Posted about 6 years ago

£20-250 GBP

Paid on delivery
We have an excel list of clients with various data fields (no more than 8). We would like to make this a secure spreadsheet, but that can provide a summary sheet so a team member can search anonymized information on other clients i.e limits purchased for companies in the same industry and revenue classification. The client information page needs to be password protected and only visible using that password.
Project ID: 16666008

About the project

42 proposals
Remote project
Active 6 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
42 freelancers are bidding on average £96 GBP for this job
User Avatar
Hello Sir, Thank you for this opportunity. My name is Jay and I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Please initiate a chat so we can discuss on this. Thanks, Jay
£200 GBP in 3 days
5.0 (779 reviews)
8.6
8.6
User Avatar
Dear Employer, I understand that you wan to search and add summary sheet to be created and managed. I have more than 5 years of experience in Excel Kindly ping me for more discussion.
£250 GBP in 3 days
4.9 (349 reviews)
8.0
8.0
User Avatar
Hello there !!! I have completely reviewed your requirement, and thi can be done using few VBA codes and formulas with desired pattern and also for maintaining its privacy it can locked. Please share more details so that we can discuss further about the fields. Looking forward to your reply Thanks Adam
£28 GBP in 3 days
4.8 (112 reviews)
7.7
7.7
User Avatar
Greetings!! We are expert in MS tools with very high proficiency in Excel and we have created various such Excel spreadsheet with Same requirement as of yours. Also we can create desired drop-down menus arranged as per your clients and revenue with proper privacy and security. Please reply to my bid so that can assist you in better way Thanks Brad
£27 GBP in 2 days
4.8 (302 reviews)
7.6
7.6
User Avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fourteen excel vba projects in the past seventy days. I have already worked on similar projects in which locking the data, providing access to limited data were performed. Willing to take up your project. Thank you, Regards.
£150 GBP in 3 days
5.0 (126 reviews)
6.5
6.5
User Avatar
I am an Excel expert. The task at hand can be accomplished using VBA and Pivot tables. Feel free to contact me for details.
£50 GBP in 2 days
4.9 (157 reviews)
6.4
6.4
User Avatar
I am an technical business analyst with 15 years professional experience with Excel and VBA (as well as Access and SQL Server), and I would love the opportunity to chat with you further about your project. The biggest issue is Excel security is quite fallible - while measures can be put in place to protect data, most can be subverted by a savvy user (e.g. the data sheet could be hidden and the workbook structure password protected, but a user can still refer to a hidden sheet with a formula. So say the sensitive information was in cell A1 of sheet 1, we can hide an protect this sheet but a user could still enter the formula =Sheet1!A1 on another sheet and have the data returned). There are ways to protect this further (e.g. hide the formulae in the sheet so users are unable to determine the name of the hidden sheet and therefore can't utilise it in a referencing formula), but these still aren't perfect. This means some consideration should be given to how secure you need this protection to be, and whether the approach should / can be varied or if you can live with this level of protection. I would love to chat with you further about your project to see whether this can be delivered in Excel to your requirements, or to discuss other options!
£222 GBP in 3 days
5.0 (30 reviews)
5.3
5.3
User Avatar
Greetings! I am an expert in Microsoft excel/ Data entry. I would love to have the opportunity to discuss your project with you. I feel I am best fit to complete your project. I have 10 years of experience of particular field. I have recently complete similar project. Thank you for your time and consideration Ram Dadhich
£55 GBP in 3 days
5.0 (19 reviews)
5.0
5.0
User Avatar
Hello sir ! How are you >>> Sir i can done your task as per your requirements e.g Excel Spreadsheet , please talk to me for start work, regards
£20 GBP in 3 days
4.4 (59 reviews)
5.1
5.1
User Avatar
Hello I am here to assist u in this project I am an ACCA U.K member currently working in finance dept of a leading airline of the world I have more than 4 Years of accountancy and finance experience and have great skill and experience in Forecasting and financial Planning Can assist you with high regards. Plz share more info to proceed in project. And we can discuss more details in chat Thanks in anticipation Looking forward for this projext positively
£28 GBP in 3 days
5.0 (23 reviews)
4.2
4.2
User Avatar
i can do this, Please review my profile and inbox me. i have good command over ms excel especially pivot table, charts, advance formulas etc. Thanks
£90 GBP in 3 days
4.9 (27 reviews)
4.1
4.1
User Avatar
Have created several similar files and happy to send you a sample to let you judge for yourself, but the site does not allow attachments unless you send me a Private Message first. DO that, and I can provide the sample that extracts all records matching a Sector or Revenue limit, but without revealing the clients. Can work under a Confidentiality and Non-Disclosure Agreement if required, and start as soon as you pay the fee into the site and send me your current file.. I designed dashboards, reports and interactive spreadsheets and managed databases for twenty years at a leading multinational. Now work from home in the Midlands, so communications will be straightforward. Active across five freelance sites with good reviews from international clients who have utilised my expertise in VBA Coding, Formulae and Conditional Formatting, Hope you find this of interest and look forward to hearing from you. Midlander
£55 GBP in 1 day
4.6 (11 reviews)
4.5
4.5
User Avatar
Hi, I come from a corporate background, and I understand the need to create China walls around critical information. I have encountered many situations in the past where I had to create such segregated information databases. Hence a simple locking of your excel sheet will not be sufficient. Fortunately the newer version of excel allow additional fail-safes to be built in to protect your underlying data. e.g you can not only hide a sheet, but you can also [veryhide] it. A very hidden sheet, needs a macro to execute and unhide those sheets, Making it tougher for unauthorized access. There are a couple of more such tricks which can 1> Stop unauthorized access 2>Help deter unauthorized access 3> track unauthorized access While also ensuring that required data is visible to those who need it. Your project needs someone who can not only understand your requirement, but also preempt your security needs, and I believe I am the right person. I have over 10 years of experience working with companies like A.C. Nielsen, Pratt and Whitney, Accenture, Volvo.. So I can be a great asset, not only for this requirement, but also future requirements. As with any good service, there is a cost associated. So has mine. Ofcourse you can try the £20 bidders, and hopefully not waste your time, or you can chat up with me, and I will be happy to address any concerns or queries you might have. Regards Amin
£250 GBP in 3 days
4.9 (6 reviews)
4.3
4.3
User Avatar
A proposal has not yet been provided
£100 GBP in 2 days
5.0 (7 reviews)
3.8
3.8
User Avatar
Hi, i would like to complete this task in a maximum of two days. i can use VBA Skills as well to enhance the capabilities of the summary sheet. Tough i am new to freelancer, i will make sure to give u fully functional Excel,i have 9 years of experience i dealing with excels. so please be rest assured about the quality if the deliverable Thanks Moaviya
£111 GBP in 2 days
5.0 (5 reviews)
3.5
3.5
User Avatar
I am very professional in excel. I have read all your information very carefully and I think I can sold this by advanced technique i excel and VBA. just send me sample file and discuss with me more detail. thanks
£55 GBP in 2 days
2.9 (3 reviews)
1.8
1.8
User Avatar
I have 8+ years of experience with Advanced excel, VBA. Can complete the required sheet in max 2-3 days. Looking forward to hear from you
£150 GBP in 3 days
3.6 (2 reviews)
1.4
1.4
User Avatar
Dear Boss, I am full-time Data Entry and Web Research Expert. After seeing Your job description, I am highly interested to assist You. Could please give me a chance. Thank You!
£20 GBP in 3 days
5.0 (3 reviews)
0.0
0.0
User Avatar
apprehension and experience about Excel. Have successfully closed many projects by fulfilling every requirement from client's end.
£261 GBP in 8 days
0.0 (0 reviews)
0.0
0.0
User Avatar
For me, my hardship, sacrifices , my dedication , and my experiences makes me the best candidate for this project. The way I'm pursuing myself to do all my best to fulfill what are things that could be my burden.
£150 GBP in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
United Kingdom
0.0
0
Member since Apr 10, 2018

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.