24FreelanceMercado freelance que nunca duerme
Cerrado

Write macros on VBA

304 vistas 0 respuestas#40422
Estado del proyecto
Closed
PresupuestoNegociable
FormatoProyecto únicosin prepago
PagoTransferencia bancaria
Respuestas aceptadasTerminadohasta 19.08.2024
Respuestas0promedio de categoría: 0,3
Vistas30445 en 14 días

Descripción del proyecto

Good afternoon. Services are required for a macro writing specialist. I need to write a macro on VBA. For me, the task is urgent and important and needs to be done today.
As the business manager explained for 15 minutes. (For him, maybe I don't know macros)
I have an excel file (I can’t send it anywhere) (only a photo)
I suggest the format of the work is as follows: I will show the monitor through the camera, you will tell what to write.
Or write so I can easily change the variables.
The bottom line: You need to write a macro that will unload data from the excel to the word.
There is a sheet of "Modules" in it a table where in column A codes (M1, M2, M3 ...) of blocks of business processes from another sheet /s are listed. The remaining columns in this table describe these blocks.
There is a sheet of 3 hours; it has a delimited scope of view on pages, at the moment the pages can be up to 8. They are all of the same range horizontally and vertically. Each page has its own serial number in the upper left corner (as an example of S0, S1...S8). On the page itself, a block diagram consisting of numbered blocks is drawn (description of which in the table on the sheet "Modules" is drawn).
It is necessary that the diagram of the business process is unloaded from the sheet specified by the user (for example, the sheet “3 hours”) and immediately below it a table describing those blocks that are drawn on the page (for example, S0), then the next diagram of the business process from the page S1 and the description. And so all the selected pages from the sheet "3 hours"
Such sheets as 3 hours several. (See 6 hours, 18 hours, etc.) will be added in the future.
How do I see the realization?
You need to create on sheet 1 an area where the user enters the name of the sheet (for example, 3 hours) and selects which pages from this sheet he wants to translate into a word (for example, S0 and S3).
Here the program must go to the sheet for 3 hours take the page S0 (range defined 67x48) move to the ward (no matter what format the table in the range or picture) determines which modules are used on this page (now thought out as follows: a cell with a bright yellow background (this is to determine that it is involved in the process). Goes to the sheet "Modules" takes all the necessary lines, builds its exel page and inserts it into the Word under our scheme.
It is the same for the S3.
Saves the word file (name is built depending on what the user entered for construction, from the example described above name "3 hours S0 S3).
Desarrollo de software Transferencia bancaria
24
Veinte · consejo

Cómo escribir una respuesta que sea seleccionada

  • Comienza con la tarea del cliente, no con una historia sobre ti mismo.
  • Incluye uno o dos trabajos similares de tu portafolio.
  • Nombra un precio y un plazo — y qué incluyen exactamente.
  • Haz una pregunta aclaratoria: inicia la conversación.

Respuestas 0

Los textos de respuesta son visibles solo para el cliente.

Misma categoría

Proyectos similares

Todos los proyectos en la categoría
Warehouse inventory app with barcode scanner

Warehouse inventory app with barcode scanner

Looking for a developer to build a mobile warehouse inventory app with barcode scanning, receiving, dispatch, stocktake and reports.

Desarrollo de software24.09.20260181
0respuestas
Website accessibility audit against WCAG

Website accessibility audit against WCAG

We need an independent WCAG accessibility audit of our website: keyboard, contrast, screen readers and a clear report with fixes.

Desarrollo de software24.09.20260177
0respuestas
Bueno saber
¿Cómo respondo a este proyecto?

Inicia sesión como freelancer, describe cómo resolverás la tarea, nombra tu precio y plazo. El cliente lee las respuestas y comienza un diálogo con las mejores.

¿Quién puede ver mi respuesta?

Solo el cliente que publicó el proyecto y tú. Otros freelancers no ven tu texto ni tu precio.

¿Dónde puedo encontrar trabajos similares?

Nuevos proyectos en “Desarrollo de software” aparecen todos los días. Todos los proyectos en la categoría

FOR CLIENTS · SAFE DEAL ESCROW

Need a similar project? Post your task for free in 30 seconds

Get competitive bids from verified freelancers and release payment only when you approve the work via Safe Deal.

Post a Task for Free →How Safe Deal Works
FOR FREELANCERS · PAYORA 1-CLICK

Pin your profile to the TOP of the category for $5 / week

Boost your profile and portfolio to #1 in the directory (1-click crypto & fiat checkout via Payora) to get 5× more direct orders.

Pin Profile to TOP ($5/wk)Top Up via Payora