excel工作表名称引用（国外英文资料）.docVIP

excel工作表名称引用（国外英文资料） Each eldest brother: I set up in the same workbook 32 table, of which 31 respectively named 1 to 31 (sheet1 renamed 1, namely, etc), and each form a complete set, each table B2 to H2 for different data Table 32 is called the total table, which is named from A2 to A32 for 1 to 31 So, Im going to use a formula that I can do with 31 tables in the total table (B column to H column)? thank you 0 reply The 1st floor is 2007-12-2517:24 and I also say a word A stay The E knows half of the solution and the VBA is avoided (not yet). thank you Replying to the receipt of the reply to the second floor of the building, 2007-12-2517:26, I also said qinqh_yl E6 = SUM (1:31! B2) Reply to the reply to the third floor of 2007-12-2517:44 to report |, I also say A stay Thats not what I mean This is the same location data for 31 tables My request is that the data allocated by the table is changed in the same table by row, If more tables are added, I only need to add A column name in the general table thank you Replying to the 4th floor of 2007-12-2517:50 to report |, I also say qinqh_yl All of them E6 = INDIRECT (ROW (A1) day! $B $2) Copy the formula down. Replying to the 5-floor 2007-12-2608:27 report on |, I also said A stay E to the half solution, thats what that means But raises another question: when I copied formulas, $B $2 can not be carried out in accordance with the hope of sequence changes, cancel the absolute reference number $ is (presumably because within quotation marks, formula are processed according to the content rather than the coordinates), could you tell me is there any way to improve? Thanks again, the most critical problem has been solved Replying to the 6th floor of the 6th floor, 2007-12-2610:45, I also said, | A stay The series of problems arising from the partial solution of half solution: Workbook of multiple work table, one is the employee number and the names of employees, such as from A1 to A4 corresponds to 1, 2, 3, 4, from B1 to B4