Populating data From one sheet to another, relative rows
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.
|