I will convert your excel sheet into a folder organizer

Argentina

I speak English, Russian, Spanish

4 orders completed

Digital Business Solutions and AI Visuals

I provide practical solutions for businesses in data management, visual content, and documentation. I set up custom Excel & Google Sheets for calculations, data processing, and automation (VBA/Apps S...
About this Gig

Excel Sheet as Folder Organizer a practical Document Control assistant for setting up directories for a new project.

I deliver an Excel VBA macro that reads your folder structure from the Index sheet (Level 1Level 10) and creates the same folder tree inside a root directory you select. This helps document control and project teams quickly build a consistent project structure for FEED / DD / transmittals, incoming/outgoing, vendor docs, etc.

How it works

  • You fill the folder levels in the Index sheet (one folder name per cell).
  • Run the macro and choose the root folder in a dialog.
  • The tool creates all required folders/subfolders.
  • For each row, it writes a status in Index column L: Created successfully or Error (language depends on your setting).
  • UI language is taken from Manual!B3: EN / ES / RU (any other value defaults to EN).

Reliability

  • Repeated level combinations are treated as the same directory (no duplicates).
  • If a row contains invalid characters or the path becomes too long, the macro does not stop it marks that row as Error and continues. (Optional: technical details can be logged to a Log sheet.)

Note: VBA macros run in desktop Excel on Windows with macros enabled.

Platform:

Excel

Development technology:

VBA

Excel

Expertise:

Formatting

Fixing

Pivot tables

Formulas

Functions

My Portfolio