How do I reference and update a group of cells, say old account numbers that are to be covered under a new account number? I get 50 or 100 old account numbers on an xls. sheet from UPS that I neeed to update easily to one new account number. Is there a way I can automatically reference or link the old numbers to the one new account number that covers it?
Thanks in advance for any help!
Bookmarks