Write a macro on VBA. Part of the macro is already ready.

Databases & SQL, Desktop Apps — incorrectly specified categories?

6 USD

Client's review of cooperation with freelancer

Write a macro on VBA. Part of the macro is already ready.

6 USD

Excellent execution, understood the task and managed in the shortest time possible.

5.0

Valery Chik

Reciprocal Feedback

14 August 2020

Freelancer's review of cooperation with Valery Chik

Write a macro on VBA. Part of the macro is already ready.

6 USD

Valery responds to questions very quickly, gives quality and complete comments on the questions. Working with Valery is easy and pleasant. I recommend it.

5.0

Profile deleted

Reciprocal Feedback

14 August 2020

Project translated automatically. Log in or register, to view the original I have data in the form of columns - the coefficient, time, date and letter (to which the coefficient is attributed).There is a macro that extract the data for one day when you enter the date and time for which the interval requires the data.The essence of the macro - The date from and before (e.g. the beginning of 12.07.2020 and the end of 26.07.2020) and the time permitted the beginning of 09:00 and the end of 09:01.It sets out the coefficient that must be there for that time.(for example2 and above), but if it is possible to do the falling menu where you can choose, 2 and above, 3 and above, 4 and above, etc.It would be cool.Because they can be different 2,01 and 2,02 and 2,34, 4,94, so in order to not insert the exact coff in the manual, then the possibility to choose the minimum coff and came out of it.On the left of the column will be bets for a certain time and the date where the 2+ coff was for that minute.And with the right in the column will already be the next day on the same parameters but separately.This is how the macros should look: 13 numbers are net in the list because there was no 2x+ over the time interval: and 26 numbers of net data in the overall table for this time In principle, a part of the macro is already there (what is looking for 1 day, you can take it as the basis) There, in fact, you need to add only the end date to be present at this time coeff 2 and above and the check date of the day separately.If something is not clear in the face, I can explain it more clearly.

Proposals 3 Rejected 2

Melkon Yesayan

0 0

Projects -
Rating -
Rating 242

Budget: 500 UAH Deadline: 3 days

Good day .
I want to offer a work option - a program on Delphi,
It will also work much faster than the VBA macros.
With this program you can process any number of files.
The program opens Excel files, read information from them,
performing the appropriate comparisons, bringing the result to the same
or a new Excel file.
I work with Excel tables without any problems (including formulas, colors, date, time, etc.).
So imports from Excel are implemented in the program for the General
I am a representative of the Nokia company in Armenia, and the conclusion (in Excel) is used as
Alternative method of reporting.
In the program you can enter the necessary dates and time of beginning and end.
The required coefficient (from N, to M, etc. to your judgment).
With respect, Mike