随笔分类 -  Excel

vba-记录从同文件夹下根据sheet名批量导入数据的方法
摘要：Sub CopyFilesToSheetsFromFolder() Dim selectedFile As Variant Dim targetWorkbook As Workbook Dim sourceWorkbook As Workbook Dim ws As Worksheet Dim fs 阅读全文
posted @ 2024-06-28 23:29 AZ26 阅读(144) 评论(0) 推荐(0)
Excel-记录一次xlookup的使用案例
摘要：=XLOOKUP(A2,INDIRECT("Sheet1!"&VLOOKUP(MATCH("公司代码",Sheet1!1:1),Sheet1!S:T,2,0)&":"&VLOOKUP(MATCH("公司代码",Sheet1!1:1),Sheet1!S:T,2,0)),Sheet1!I:I,,0) 阅读全文
posted @ 2024-06-15 10:28 AZ26 阅读(88) 评论(0) 推荐(0)
vba-记录一次自动填充公式的function
摘要：Public Function nihao() As String Application.ScreenUpdating = False '防止宏运行时屏幕抖动 Sheets("Sheet2").Activate Sheets("Sheet2").Select '选择Sheet1 Range("B1 阅读全文
posted @ 2024-06-04 22:16 AZ26 阅读(102) 评论(0) 推荐(0)