Modify Excel Macros/Visual Basic calculations sheet

En curso Publicado hace 7 años Pagado a la entrega
En curso Pagado a la entrega

We have an Excel Sheet which we use for calculating things.

We need added in/modified:

- When we press calculate the lines that it calculates out are numbered.

- A reset button that resets four values. 50,50,65,16

This next one is not as straight forward and is a little tricky.

The current line values that it produces is like this.

1 0.00 165.60 165.60

2 165.60 165.60 331.20

3 331.20 165.60 496.80

4 496.80 165.60 662.40

5 662.40 165.60 828.00

6 828.00 165.60 993.60

7 993.60 165.60 1159.20

8 1159.20 165.60 1324.80

We need the ability to punch in 2,2,2 into a cell on the sheet, which then when the macro is working out the line calculations it adds on another column and calculates an extra value which is just dividing a cell by two before adding the cell on. (minor modification to the current calculation)

1 0.00 165.60 165.60

2 165.60 165.60 331.20

3 331.20 165.60 496.80 464.30

4 496.80 165.60 662.40

5 662.40 165.60 828.00

6 828.00 165.60 993.60 961.1

7 993.60 165.60 1159.20

8 1159.20 165.60 1324.80

Need this sorted today within the next few hours, if you can't sort it today in the next few hours don't bother bidding.

Excel Arquitectura de software Visual Basic

Nº del proyecto: #13499699

Sobre el proyecto

4 propuestas Proyecto remoto Activo hace 7 años

4 freelancers están ofertando un promedio de $33 por este trabajo

satishtl

- Can get the Excel fixed to arrange as per the 4 values requried. - Get completed in next few hours. - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the m Más

$30 AUD en 1 día
(42 comentarios)
5.3
prabakarm23

I have 7 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I Más

$50 AUD en 1 día
(56 comentarios)
4.9
lcramsay2

Hi! My name is Lee and I would love to get started on your project for you! I am a graduate with a Masters degree in Aeronautical Engineering so you can be sure that I have plenty of experience with Excel, I don't thin Más

$25 AUD en 1 día
(0 comentarios)
0.0