I have an Excel document that has 4 tabs in it. How do I formulate cells in each of the tab spreadsheets to generate the same if I change the information on one.
Example: Each tab spreadsheet has a cell that I input the employee's drivers license number. if I update on one of the tab spreadsheet, I want it to update then on the other three tab spreadsheets.
A1
on all sheets. Before you enter the data, holdCTRL
and click the sheet tabs, which will select multiple sheets at once. Then put the data inA1
. It should put the info there on all selected sheets. ...is that what you mean?