I have an excel document used for our customers, where data is entered in several tabs. Many of the data elements (i.e. "Name of Reseller" row 11, "Name of EUC" row 15, etc...) are the same across all tabs. Is there a formula to utilize where data entered for these duplicate fields would transfer across all tabs of the excel document? Example would be entering "ABC company" on cell B11 and having that name copied to B11 on all other tabs. Then the name of EUC is entered on cell B15 and it's transferred as well. I've attached the sample excel for testing. Any help is much appreciated.
Bookmarks