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.

Ставки 7

Oleg M.

Победившая ставка

109 0

Проекты 105
Оценка -
Рейтинг 1 115

Бюджет: 1150 UAH Срок: 3 дня

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

Сергій Д.

38 0

Проекты 39
Оценка -
Рейтинг 1 134

Бюджет: 200 UAH Срок: 1 день

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

Проекты -
Оценка -
Рейтинг 178

Бюджет: 100000 RUB Срок: 100 дней

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.