 |
|
发布时间：2025-10-18 23:21:02
| 实习生教我VBA，自动填写vlookup公式！ 📊做数据的，肯定免不了跨表格取数，最常用的就是vlookup函数。可是每次一个个拉函数，实在太费时间还容易不小心搞错 这段VBA直接帮你省去输入函数的麻烦，直接帮你输入index + match函数，还可以选择直接变为值！！！具体步骤看图片呀！ （注：用任何vba之前，请做好数据备份！另外，此段vba默认表格第一行为表头。） ——————————————— Option Explicit \' ------------- Ribbon 转发入口 ------------- Sub IndexMatchFill_onAction(control As IRibbonControl) IndexMatchFill End Sub \' ------------- 主过程：Index Match 自动填充 ------------- Sub IndexMatchFill() Dim wbTarget As Workbook Dim wsTarget As Worksheet Dim wbSource As Workbook Dim wsSource As Worksheet Dim srcFile As Variant Dim srcSheetName As String Dim tgtHeaders As Variant, srcHeaders As Variant Dim tgtKeyCol As Long, srcKeyCol As Long Dim colInput As String, colArr() As String Dim i As Long, colIndex As Long Dim lastRowTgt As Long, lastRowSrc As Long Dim dataColLetter As String, srcKeyColLetter As String （未完） #打工人自救 #excel技巧 #办公技巧 #提高工作效率#vlookup |
上一篇：护理实习生急诊出科总结
