I have a master sheet with 6 columns and 20 rows. I will be adding about
200-250 more rows to this. I would like to be able to add these rows and
have the info populated into one of 14 other sheets automatically. I found a
way to do this by adding a macro but I have to click that after each row is
added. Is there any way I can set up something to do this for me as I enter
the data?