I have a spread sheet that I am entering information. I would like the
information (including as I add lines) to be created on another worksheet in
the same workboook. As an example, I have to insert X company onto a new
line of informaiton on the main worksheet and I want that line to
automatically insert on another worksheet in the workbook. My workbook has
three tabs, one for "overall information", one for "completed" and one "in
progress". I know there are ways to filter data but I am not familiar enough
with macros to apply them here.