No announcement yet.

Macros for selecting a suitable equipment configurations from sheets (files)

  • Filter
  • Time
  • Show
Clear All
new posts

  • Macros for selecting a suitable equipment configurations from sheets (files)


    Recently a task has been set:

    To make a VBA Macros that would allow end user to sort out equipment from sheets(files) by specifications,

    Lets say I have a store selling furniture for office and home. But the subcategories in each category are many and I want to be able to sort them out by material, color, type of paint, allergy indicators, origin of wood, and available certificates, etc.

    What I have:

    Individual Excel file fro each model, the general layout of the sheets is the same for every and each file. Files are relatively light, 2-4 A4 pages at most with very simple structure.

    What is needed:

    Independently sort files by a specific specification ( cell of the sheets/files)

    P.S. I have very little experience working with VBA and related tools, please, explain in detains if you favor me with your answer. Thanks you !

  • #2

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Did you debug your code first?
    FORUM RULES----->

    If someone has helped you, say "thank you" by clicking on the Like Button.