Firstly, my problem may be not knowing how to properly describe what I need.

I'm trying to make a master spreadsheet where all data is entered, then have that populate individual sheets based on criteria in an if statement.

I got it to work by referencing specific cells, but I need it to where it could by just referencing a column.



I would greatly appreciate any help. I've uploaded the .xls. I know my description skills are a little lacking, so please contact me if you need any clarification.

Thank you kindly.

Attached Files

mmpCal.xlsx (10.9 KB, 26 views)