I have two worksheets, one is for inverstor names and the other is for more less secure (non-passworded) viewing. The non-passworded will not be edited, but I want to pull the info from the other worksheet. The problem is when I change the number of investors. I want to auto fill the non-passworded one with: Column A1= investor 1, investor 2..... (where on the passworded one it would say like Steve or something) Column C1= Actual values that were entered ($2500) How would I could the rows on one worksheet and then auto fill with the above info on another and change automatically if a value is changed?
Bookmarks