Remote Data Mining And Management Job In Data Science And Analytics

Excel Scripting and data visualization

Find more Data Mining And Management remote jobs posted recently Worldwide

I have a requirement here. I have created an Excel sheet which works on some good amount of Data.. Now the Excel is ready and working.. My requirement is as below now:

1) There are too many repeated formulas being used in the Excel and hence I want to use VB Scripts to consolidate those formulas at one place.

2) That excel needs to be completely password Protected.. No One Should be able to View or copy any of the VB Scripts..

3) The password needs to have an Expiry Set when we protect the Excel.. Lets assume that I set a password for the Excel which should expire in 30 days or 60 days.. After that the user would not be able to open the Excel further.. Remember user cannot change the password also..

4) Excel will connected to external source for Data Feeds into the Excel at real time.

Now please understand that this is a self work and is completely my own Intellectual Property hence I wont be able to share the Excel sheet but I will share a small sample excel sheet which you will have to help me create the above things then then rest of the things I will do on my own.

I want to be very clear that this is not going to be a HUGE work as you can understand that you will only be working on the sample sheet hence I want some quick work here. This is urgent and hence needs to be delivered within no time.
About the recuiter
Member since Nov 11, 2022
Aanjana
from Ilfov, Romania

Skills & Expertise Required

Excel VBA JSON VBA 

Open for hiringApply before - Dec 14, 2024

Work from Anywhere

40 hrs / week

Hourly Type

Remote Job

$26.83

Cost

Offer to work on this project closes in 211 days!
Are you interested in this Opportunity?

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions

Similar Projects

Quick Excel/VBA fixes

Have a file with a few short pieces of code/formulas - need a few quick fixes. I will provide everything that you want through Toogit chat.

Extract data from the web into Excel

extract data from the web into Excel the web include exhibitor list with company name, email, website, contact person email, contact number.
need to use web scrape tools extract these data to excel and delete the duplicated pieces of information.

Quickbooks help needed

I need help with QuickBooks for very small business with less than 20 transactions per month. Need help to correct errors. Help could be remote via Team Viewer and telephone.

VBA Automate excel pivot tables + batch file

I have a text file automatically downloading to a folder.
I need to automate importing the text file from a folder, adding pivot tables, and dropping the completed excel into a folder.

BluePrism Finance Project - Need urgent help

I am looking for BluePrism developer who can help me with my current project. Need to finish this project in 15 days so i require help urgently. Application include Excel, SAP, Management web protal.

A clean and detailed SDD is prepared by...read more