excel在一个单元格 引用另外一个单元格

Inserting values from a cell into another text field/cell

 

="this is the result of "& A1&" iterations"

where A1 houses a number indicating the actual number of iterations.

 

="insert into dbo.tbm_cti_CustomTableItem_EmployeeHierarchy(UniqueID,ManagerID) values('"& D2&"','"& E2&"');"

insert into dbo.tbm_cti_CustomTableItem_EmployeeHierarchy(UniqueID,ManagerID) values('E8007','E6275')

 

excel如何带公式下拉到最后一行

对准右下角光标成“+”状时双击，

作者:Chuck Lu    GitHub