I will convert your excel sheet into a folder organizer

Argentina

I speak English, Russian, Spanish

3 orders completed

Experienced project engineer with over 13 years in the oil and gas industry. Specializing in pipeline system design, industrial facilities, and project management. Strong proficiency in Excel, includi...
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