Worksheet "A" is a master inventory list for company's eyes only. Worksheet
"B" is a distribution list for public view and it is all driven by formulas
from "A"
so that I do not have to reinput the same data twice. "B" will have certain
columns and sheets hidden and is password protected. From time to time I
must enhance "A" by inserting a row within the list and adding a new client's
data. I want this row insertion and new data to also copy over to "B"
automatically. Bottom line I need any changes made to "A" to automatically
copy over into "B". Original data is easy to do, but I cannot figure out how
to make adding/deleting a column or row and the new data that is input
automatically copy over into "B".