.Excel VBA

£20-250 GBP

In Progress

Posted

over 10 years ago

£20-250 GBP

Paid on delivery

In Excel 2013, create a macro that runs when certain cells change value, and executes a special paste action. I have started the attached worksheet (it is a sales order form, which gives the customer a cheaper price band the higher the overall order value is). However I am coming up against a circular reference issue which can only be solved if I move the autosum formula in G11 to H11 (so adjacent to G11) and hide it, then create a macro to execute a special paste - values only - from H11 to G11 every time a value is inputted into any cell in column F, thereby losing the circular reference. Can anyone create such a macro?

Excel

Project ID: 4904690

About the project

10 proposals

Remote project

Active 11 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:

@elMancha

Hello there. I've read your project description, analysed you [login to view URL] file and developed an excel formula capable of doing what you want without the circular reference problem. It isn't a macro like you asked but a formula so it will not pause to run and run instantly on cell value change. Please contact me for more details and printscreen. I would gladly appreciate this opportunity to work with you. Best regards, Bruno Martins

£24 GBP in 0 day

5.0

(59 reviews)

5.4

10 freelancers are bidding on average £81 GBP for this job

@Teloquence

Consider it done. Check my past reviews for your reference. I have done many such projects before and I can solve this circular reference issue. Eagerly waiting for your reply.

£48 GBP in 0 day

4.9

(326 reviews)

7.6

@zExcel

Hi, I looked at the file and read your comments. You're right the only way to get rrid of the circular reference is by using a macro to plug in values in the column G instead of formulas. I'll be happy to set up the macro for you and can start on it as soon as you get back you

£44 GBP in 1 day

4.9

(250 reviews)

7.6

@sswijaya

Hi, I can help you to create the macro. I have experience in Excel VBA and I would like to know more details about your requirements. Looking forward for your reply and your sample excel file to give better description about your project. Regards Susanto

£50 GBP in 3 days

5.0

(58 reviews)

6.4

@dcart

Hi I have been programming macro outside freelance and fully understand you requirement. If you considered my bid I am ready to help.

£38 GBP in 3 days

5.0

(3 reviews)

2.4

@urmate

contact me for a quick and perfect solution according to the requirements. Will deliver the work within 1-3 days. Thanks

£154 GBP in 3 days

5.0

(2 reviews)

1.7

@NhatAnhIT

I can do this for you, i work with excel VBA too many times so i have many experience in this field (refer to my profile). I will resolve your problem fast and best time. Give me your project. Looking for work with you soon.

£40 GBP in 1 day

4.6

(1 review)

1.5

@swarm22

Hi , I am Macro developer. I am able to develop such macro. Give quality , accurate and result oriented work.

£222 GBP in 10 days

0.0

(1 review)

0.0

@gdtechsolutions

Greeting, We are from GDtechsolutions. We have understood the work and would like to submit our proposal for the same. Why Us: - We have extensive experience in VBA scripting. - We have done similar projects in past. - We guarantee our work and will deliver best quality in your budget and time. Hope to hear from you soon. Thanks Support GDtechSolution.

£88 GBP in 3 days