The user should be able to choose to create a single report (e.g. a report for the city of Warsaw) or in all reports from a given group (e.g. reports for all cities).

t does not matter how the application is executed in terms of the execution of individual elements in Excel or in VBA.

You do not have to do everything in VBA. You can do most of the work in Excel (prepare a report template, charts, statistics, pivot tables, etc.), and import text files with VBA, create a collective database, complete the data in the report template for individual cities and save reports in separate files.

I will provide further information and data once everything is discussed.

Proposals 7

Oleg M.

Winning proposal

109 0

Projects 105
Rating -
Rating 1 115

Budget: 1150 UAH Deadline: 3 days

Hello.
I am an expert in VBA macros for excel.
Write to me and provide a table with which to work.

Serhii D.

38 0

Projects 39
Rating -
Rating 1 134

Budget: 200 UAH Deadline: 1 day

Witam.

Chętnie podejmę się tego zlecenia. Jestem zaawansowanym użytkownikiem tego programu. Codziennie tworzę raporty dla zarządu dużej korporacji. Mogę wykonać takie raporty jak za pomocą Excel czy VBA tak i w Power BI.

Zapraszam do kontaktu w celu omówienia szczegółów. Jest możliwość wystawienia FV.

Pozdrawiam
Sergii

Aleksejs Kosinecs

0 0

Projects -
Rating -
Rating 178

Budget: 100000 RUB Deadline: 100 days

https://community.intersystems.com/post/multiexcel

Our excel-m-amplifier (“Shadow excel”) is implemented as parallel invisible spreadsheets inside Cache / IRIS InterSystems. There are also workbooks, worksheets, columns, rows, cells with formulas. Each main-excel sheet has a corresponding shadow-m-sheet. Each cell has a shadow cell. But formulas in the shadow cells are unusual - they are actually MUMPS commands. The m-worksheets are not two-dimensional, but multi-dimensional. The interface with users is not directly, but through “main excel”.

The possibilities of the shadow are orders of magnitude higher.