How to create a program from excel?

M

mUchenik2017-04-03 13:38:30

Programming

mUchenik, 2017-04-03 13:38:30

All the best!
Friends, tell me how to create a program from Excel.
Now I have a file with formulas, and everything I need ...
But I would like to make a program from excel so that I don’t have to prepare a new file every year, and the program itself somehow stores data for years so that it would display reports .
How to do it? Can anyone suggest some tutorial on this topic?
If it is strongly exaggerated, then you want something similar to 1C accounting, but this comparison is greatly exaggerated.

Reply

Answer the question

In order to leave comments, you need to log in

4 answer(s)

A

Alexander, 2017-04-03
@NeiroNx

You can split the data into sheets and make one sheet with a report in which, having written the year, it will be included in the links in the formulas and the data for calculations will be taken from the sheet corresponding to the year.

K

Konstantin Nagibovich, 2017-04-03
@nki

So can do it in 1C?

T

Timur, 2017-04-03
Saifulmulukov @TiersWar

I think you need to work with macros and variables.
office-guru.ru/excel
www.msoffice-nm.ru
www.excel-vba.ru
www.planetaexcel.ru

M

mUchenik, 2017-04-03
@mUchenik

The table does not seem to be complicated...
It calculates the margin for each transaction, displays the total margin, calculates the RFP depending on the margin, keeps a simple record of applications.
For example, here is a link to the file itself https://yadi.sk/i/HoJWm3eO3Gbfcc for a clearer understanding.
In 1C, I don’t want to poke this data ...
Now, as you can see from the file, it’s not very convenient to work with it ... You need to rewind, insert the date, etc.