.Excel VBA

£20-250 GBP

En curso

Publicado

hace más de 10 años

£20-250 GBP

Pagado a la entrega

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

ID del proyecto: 4904690

Información sobre el proyecto

10 propuestas

Proyecto remoto

Activo hace 11 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

Adjudicado a:

@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 en 0 día

5,0

(59 comentarios)

5,4

10 freelancers están ofertando un promedio de £81 GBP por este trabajo

@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 en 0 día

4,9

(326 comentarios)

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 en 1 día

4,9

(250 comentarios)

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 en 3 días

5,0

(58 comentarios)

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 en 3 días

5,0

(3 comentarios)

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 en 3 días

5,0

(2 comentarios)

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 en 1 día

4,6

(1 comentario)

1,5

@swarm22

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

£222 GBP en 10 días

0,0

(1 comentario)

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 en 3 días