Table 1 for the home page, including A1 of 01, B1 for 02, C1 for 03, how to quickly set up set in table 2 A1 to the 01 in table 1, A2 is set to the B2 in table 1, A3 set to the C1 in table 1, and then set up the table 3, table 4 etc.

CodePudding user response:

Use the formula in sheet2 of A1=sheet1! A1
Use the formula in sheet3 of A1=sheet2! A1
Then according to your needs, use the mouse to drag the cell, the formula of filling into other cells,