This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi,
I am completely new to Macro on Excel (I have never done one).
My problem is:
We create products daily, and each product has a sub-category and a department. We need to generate sizing based on the sub-category and the department and the fit.
See below example. Category (Column B) Department column E, and the fit column D currently via indext match the percentages per size in columns I-N to produce size data in columns S-U - however, this amount of index matches in the sheet per sub-category per fit is incredibly slow. Is there not a way with a macro that we can click a button e.g "Generate sizing" that can auto populate the size data without need for all the index matches in the sheet?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
I don't want to be rude, but a screenshot doesn't mean anything in this case and I don't have the time or desire to recreate it all.
Please upload a sample file anywhere and post the download link here.
Andreas.
Hi Andreas,
Attached screenshots are a better example.
Below showing the index-match formula.
Below showing where the data is stored:
Show us that file with the formulas you use. Then we can take a look where's the issue and make a suggestion.
Andreas.