Code Clean up for Excel VBA

$30-250 USD

In Progress

Posted

about 12 years ago

$30-250 USD

Paid on delivery

I have an Excel Spreadsheet with some VBA code that needs to be cleaned up. I have some automation and controls because many users share this workbook. I have buttons and user form to transfer data from one sheet to another and the buttons occassionally break down, which I need to fix. Also many cells are protected and the sheets are protected. However, when users exit the file, the ability to use the filters in the column headers is lost. I would like a code that guarantees that users can filter. Also, I would like to have the buttons to copy data based on the criteria of a certain column. Moreover, I want to stop users from being able to paste into the spreadsheet, because it ruins the integrity of my data. I also want to find someone that I can maintain a relationship with if I need help in the future. Please let me know if this sounds appropriate for you.

SQL

Visual Basic

Project ID: 1483479

About the project

8 proposals

Remote project

Active 12 yrs ago

Looking to make some money?

Email address

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:

@northwolves

Ready to start. See PMB please.

$60 USD in 1 day

5.0

(27 reviews)

4.5

8 freelancers are bidding on average $93 USD for this job

@danielgpratidya

Hi, I will check and fix them for you.

$50 USD in 2 days

5.0

(27 reviews)

4.5

@pyazlm

I have relevant experience in VBA.

$45 USD in 3 days

5.0

(14 reviews)

3.6

@junbest1986

Dear Sir, I am ready to work with you, please see PM

$35 USD in 0 day

2.3

(3 reviews)

3.4

@ITProgramming

Dear Sir or Madam, I have many years of experience in Excel VBA. This makes me sure that I can help you to fulfill the job. See PM for more information. Best wishes, ITProgramming

$150 USD in 5 days

0.0

(0 reviews)

0.0

@Cr41gw0r

Hi, I have over 5 years of vba experience and can complete your project to a high standard. I would be happy to have a longer working relationship with you if you find my work satisfactory. Please also see pm. Thank you.

$40 USD in 1 day

0.0

(0 reviews)

0.0

@pf2626

I have 10 years experience with macro development using VBA, .NET 3.5 and SQL. After reading your project description I feel I could improve your current macro and add functionality that you're looking for. I'm very detailed and professional based. I look forward to working with you.

$200 USD in 5 days

0.0

(0 reviews)

0.0

@BestFinServProv

Hi, I have 5+ years of experience working on similar projects in my organization, in automation and standardization of complex projects. I will be able to deliver you a fixed excel file, and may be some improvement ideas as well. Thanks

$150 USD in 3 days