|
本帖最后由 moonlit123 于 2019-9-30 23:47 编辑
- Sub 从表n并入总表()
- '''打开总表执行
- Dim sh, x, i, R, arr(), brr(), adr As String
- adr = "$I$11:$I$271"
- arr = ThisWorkbook.Sheets("第一期TB表").Range("J8:AV8").Value
- mypath = ThisWorkbook.Path & ""
- fn = Dir(mypath & "\*.xl*")
- Do While fn <> ""
- If fn <> ThisWorkbook.Name Then
- Set wb = GetObject(mypath & fn)
- brr = wb.Sheets("第一期TB表").Range(adr).Value
- fncolumn = Split(fn, ".xl")(0)
- wb.Close False
-
- For i = 1 To UBound(arr, 2)
- If arr(1, i) = fncolumn Then
- ThisWorkbook.Sheets("第一期TB表").Cells(11, i + 9).Resize(UBound(brr), 1).Value = brr
复制代码
按总表里的列名(比如A011-TB表-醒醒)为依据复制的,如果分表的文件名和列名不一样,不会复制进来。
|
|