Forum Discussion

curry2445's avatar
curry2445
Copper Contributor
Aug 25, 2020
Solved

Processing a list of data through a separate excel setup

I have a complicated spreadsheet which only allows one input case at a time. I have around 200 input cases. Instead of creating 200 spreadsheets I would like to write a marco which runs each case thr...
excel
Formulas and Functions
Macros and VBA
  • mtarler's avatar
    mtarler
    Aug 26, 2020

    curry2445  i think you want to look up bar size based on column P and then copy the corresponding M' and Mres values to columns n and o.  At least that is how I updated the macro.

curry2445's avatar
curry2445
Copper Contributor
Aug 26, 2020

Hi mtarler,

 

This is working. Thanks a lot you've saved me a lot of time. 

 

I just have one final question, if you don't mind. I attempted it myself, but its completely wrong. 

 

I want to add a column to my summary sheet with bar sizes in it and ask the macro to look up the bar size in the Cases tab B13:B18 then return the corresponding Mres V13:V18 in the original summary sheet O2...

See attached:

Capture - my weak attempt.
Capture1 - the additional column
Capture2 - the information I'm talking about. 

mtarler's avatar
mtarler
Silver Contributor
Aug 26, 2020

curry2445  i think you want to look up bar size based on column P and then copy the corresponding M' and Mres values to columns n and o.  At least that is how I updated the macro.

  • curry2445's avatar
    curry2445
    Copper Contributor
    Aug 26, 2020

    mtarler Thanks for all your help. This is perfect.

Resources