I keep condo unit information. I have a list of names and addresses and unit numbers along with other pertinent information all located on one spreadsheet, in one tab. I just created two additional tabs in the same worksheet and I copied over the names, addresses, and unit numbers from the first tab. When I'm on the first tab and I remove a person name in order to enter a new name in its place, how can I direct excel to automatically repeat my changes in the other tabs on the same spreadsheet?
I hope someone has an answer to this question.
