Closed

Adding VBA functions to an XL Sheet to improve usability

We have a requirement to enhance two existing spreadsheet systems used by our organisation.

One is a simple project planning tool, the other presents a statistical model to end users.

Tasks include;

Hiding and unhiding columns and sheets based on check boxes/entered ranges

Providing a large "undo" function to reset areas of the spreadsheet to default settings

Converting some lengthy cell-based functions into more readable VBA functions

We are seeking someone who is good with VB, and experienced in manipulating the excel object model. Strong logic/mathematical skills will also be necessary.

You will need to be based in London and able to visit our offices occasionally during normal working hours.

Skills: Excel, Visual Basic

See more: vba with, skills improve, planning an, project object model, in vba, end vba, adding hours, xl, vba excel, usability, statistical model, excel vba, excel 2011 vba, excel vba tasks, sheet excel visual basic, improve functions, vba function, vba tasks, vba excel 2011, simple planning excel, excel vba spreadsheet, vba 2011, check sheet, cell excel vba, vba sheet

About the Employer:
( 0 reviews ) Southampton, United Kingdom

Project ID: #1106541

30 freelancers are bidding on average £949 for this job

bharanisrihari

Hello, Excel VBA expert here. Please check PM for details. Thanks!

£750 GBP in 7 days
(64 Reviews)
6.4
vserv

Have lots of experience using Excel since 1999 for analysis of data and generation of reports for management, etc. Please see your messages. Thanks

£750 GBP in 10 days
(70 Reviews)
5.9
Krusche

Hi, we have the required skills both from the Excel/VBA point view as well as mathematical/statistical expertise (including econometric regression analysis). Occasional traveling to London is possible.

£750 GBP in 4 days
(30 Reviews)
5.6
fedalal2

Hi, I have more 10 years in MS Excel and Office automation, so I'm realy GURU in this. I can help you with this project. Best Regards, Alex

£800 GBP in 5 days
(32 Reviews)
5.5
gshiels

Please see PM

£1000 GBP in 4 days
(11 Reviews)
5.1
UmarMahmood

Please see PM for more details.

£750 GBP in 10 days
(24 Reviews)
4.4
telemarketing555

Hi, please check your PM. Thank you.

£1500 GBP in 30 days
(26 Reviews)
4.4
LIMEXS

Please, Check my PM.

£750 GBP in 0 days
(8 Reviews)
3.4
spalmer1

Dear Benguin, Thank you for posting on Freelancer. Pardon me, I acknowledge that the request is for someone within London but the seven hour time difference compared to the eastern US has the potential of making th More

£800 GBP in 15 days
(1 Review)
2.5
ExcelVBAVeteran

Hi, i am based in Sutton (near Wimbledon) and therefore easy to commute to your office for me. I can only come occassionally though (once a week). I work in a Surrey based company and my role includes Excel VBA develop More

£1500 GBP in 20 days
(3 Reviews)
2.5
meganath03021977

I well knowledge of VBA and XL

£750 GBP in 15 days
(0 Reviews)
0.0
NikitaS

Interested in that project and ready to start right now.

£750 GBP in 6 days
(0 Reviews)
0.0
DawnPrabhat

Hi I am an expert in Excel and VBA Programming in Excel. I am interested to do your project. I have handled many projects involving data manipulation and rearranging. However, I am new to this website and looking to gr More

£750 GBP in 7 days
(0 Reviews)
0.0
myProject2011

hai, I have worked with excel VBA for a few year, I am very passionate about excel and confident about my excel knowledge. Waiting for your response. could I get the detail of your project first?.Thank you. Regard More

£999 GBP in 10 days
(0 Reviews)
0.0
lukesaenz2053

Experienced excel consultant. Proficient in spreadsheet modeling, VBA, and creative design. References available upon request. Thanks.

£850 GBP in 8 days
(0 Reviews)
0.0
baranwalr

Hi, We have a team of chemical engineers and commerce graduate with expertise in developing applications using Excel and Excel VBA. We provide financial, statistical, engineering and technical tools developed on More

£750 GBP in 15 days
(0 Reviews)
0.0
ExcelVisi

This project is well within my capability. I have many years of VBA experience, mainly in Excel VBA, and have build serious, fully automated VBA applications (25,000+ lines of code). I have done this sort of work many More

£1000 GBP in 20 days
(0 Reviews)
0.0
tdhaene

This job is perfect for me. It's the type of work I do every day. Mathematical (financial) models are no problem for me. I have experience in implementing Heston models. Since it's not possible for me to visit your of More

£1000 GBP in 10 days
(0 Reviews)
0.0
henrybarlatier

My extensive financial experience in the Microsoft suite of products such as Excel, Access, Outlook, PowerPoint and Word in front ends GUI, back-end VBA code and SQL calls, and work-flow Client-Server connectivity is u More

£1432 GBP in 10 days
(0 Reviews)
0.0
higgoboss

Please see may PM

£1250 GBP in 7 days
(0 Reviews)
0.0