Automation for Lack of better description

**jwwc29** · 12-16-2016, 01:44 PM

I have a fairly complex spreadsheet that analyzes a member for wind loading. With the input of two variables, a member name and a wind speed/pressure, the spreadsheet calculates an allowable load. The member name accesses a table of physical and material properties associated with the member an inputs them to the spreadsheet. My question, is there a way to generate a table of allowable loads based on a member name vs wind load matrix automatically (some function I can define). Any help would be greatly appreciated.

**protonLeah** · 12-16-2016, 02:16 PM

(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)

Click Advanced next to Quick Post button at the bottom right of the editor box.
Scroll down until you see "Manage Attachments",
Click the "Choose" button at the upper left (upload from your computer).
Select your file, click "open", click "upload"
Once the upload is completed the file name will appear below the input boxes in this window.
Close the Attachment Manager window.
Click "Submit Reply"

Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!

**SPARKY347** · 12-16-2016, 09:01 PM

There's always a way. Post a workbook showing what you started with and what you expect to see and any formulas / dependents we need to make it happen.