View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JBollinger1234
 
Posts: n/a
Default Generate 1-to-1 outputs for a list of inputs into a excel formula

I have a detailed workbook in excel that is using a series of approximately
50 formulas and lookup tables to generate a result based on a few inputs that
are fed into the formulas. While I understand, and consider myself to be
proficient with macros, I was wondering if there is any way that I could
create a list of several hundred input parameters that would be fed into the
equations and have excel organize the answers that are generated.