bigbillybear 发表于 2016-3-28 16:11:23

关于修改表格时使用二级下拉框的过滤公式

本帖最后由 通达林河水 于 2016-7-30 15:41 编辑 <br /><br />用多行数据统计一个表的填报单位和项目,第一列读取所有的填报单位做下拉没问题,第二列,想根据选择的单位名称过滤本单位的项目做下拉。
提取<XXSB_3_1.主表,XXSB_3_1.详表>中
    <筛选条件:XXSB_3_1.主表.表头日期:=本报表.主表.表头日期与XXSB_3_1.主表.单位: =本报表.详表1.单位>按以下方式填入<本报表.详表1>:
      XXSB_3_1.主表.单位: ->(匹配) 本报表.详表1.单位
    XXSB_3_1.详表.项目名称 ->(构造下拉列表) 本报表.详表1.项目
正常填写此表没问题,由于设置了筛选变化执行,可以正常的过滤,但是把这个公式设置为修改自动执行,那么项目下拉框就做不到过滤了,会把所有项目都列在里面。
可见项目1111是另一个公司的项目,感觉没有起到匹配的效果
data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAesAAADiCAIAAADh6XiKAAAXdklEQVR4nO2dS47cOLZAuaA3q5kXkW8BNX1IRO/BgFeQgKcFT3LewwQ86onnid6AgQIaXkB6B3qDSKtl8v5ISSEGdQ4uqiIZV/yFeIJWKDPSNE3TNKWUJoAT8/b2dnQXNoZFnTHkhLwPacixAcTB4MMz5IREDZ5Sahh/21Fth7vJZcK29RtptfOwct5uXO0YYPDhGXJCKvbgDeu/yqppwcPDg1ZD+p22tuJH1WZ2a/B5xp6enpLCti3eFxh8eIacEMvg2joPLvugGuaE5YOHhwetofTL71mh3ZaWHBxOcCxTjcG11uOzGhmIUej28FRg8OEZckJ8g1sHe8qL1FOaKy324GL+7PeskpX9iZTH5ySi16oD3RZt7FEEKxkYDD48Q06IanBRkUaC/VREEEuFZY7OHtvPGmNp8FRwLLZz48NvPrBqIBi8BIMPz5ATsv0nmVqmW8NSYcvrJKLU4jISxSoKV6zHGEt8mHERi52PHBip9grXwUUw+PAMOSEbGzyl9PLyItphLs/qTNJ17Ukxb1leNrcsaRjC9LugDdnFW4k0bQw2cmBwUG7aacHgwzPkhMgG17S1XmdlWpKua9s1zMY3Lpe79ezEPMDIVteYyXi34zm3mYE7BYMPz5ATEtqDi94J1R6Ti33nScTg7iG2N0W9tmH3v/yxfBPa1eDJ+5Q1NsoBweDDM+SE+AZ3hWjVXikX2y9zvrgHT5VXYyI9NEwnHlU+lfW8bF38Z4TdiphsJ3z58kWsM9jEGcDgwzPkhDgGb1jzDdbLzOtab2Z5+aWsx+hz1pbRt2D5taS81q+NKxu7WH9Qr5FXBIO7YPDhGXJCKq6iaBpyD3RzyjtPbIOXdxNeLpeyPNIxe1y1Ztc6rOk46b99Gp9nO1McYFKINDcqGHx4hpyQ6L0oU9OnYQ0GnyTXiPnLksvl4rZ4fSrbJrttrTe4Xc/yM4AsPzjba9IQ9wwGH54hJyRq8EyvwblwMxs2gKXB7eayJkRXaodvYnBjjGK50aVUSXByxIGcDQw+PENOSPSTzLgO4mYpHwePyq48VDW07K142To+IrdCtxtJ+vdEmWP0MM5cT9WgzgMGH54hJ0Q1uLuqj1rwpfXWVGUPQUtwyw3LN0zpJlN9ckG7YPDhGXJC7A0ZAAB0zCzy19eJIE4b4y2B8Ua0fkKO3S/vAQYniOl1RN+NN6L1E3KsbfcAgxPE9Dqi78Yb0foJOda2e+AYfFm+yQkRrHB+ym000qt4bc1jWZOzYXN7tHuSGG/GxhvR+gk51rZ7UGFw7ZwwLrLbFW5i8EiOW1vVEGrbdSdN7EBVi+JRLOCqGG+6xhvR+gk51rZ7EDJ4XG1xmdrJonOXhTaRFhssuflItdEtCyMjTYu3iviLRWivxRgx3ojWT8ixtt0D1eCaJlaeNM0Gbz4dXUvGh6AdLs5epNqIwSOFmcFrXxTCmCX3hWsoPHZEpw3N4Hdt9uhVlFrzVtWzfGDsLrMK7W3pMi1r0T6zI29CRrvz4/JZsTP2FAVLyoETtaH5Vzv3mguPHdGZQzT19TW6rXW3xDK4IaOGk6a0p+HTUojBhuz6Iyuq7byP9EecXnGGRdFrxi9HGn+9CPeVip9+VSfqgSM6bWimHtzgEZsET5qyNree2obEfVCwe1U5QUsa/Sy12zy3xnshEQwMPnycy+DiBtY9M6p2uJF6bAOKGFVtaHD7x0jfggaPj3H+r5tPuK+pXY7B7zHOZfDlSbC0gH1abGLweHPxLmW63KS2yCHuU67By6pEg9tvD4QbGHz4OK/Blz/uavC5ftFWmjdt92k1VK1YuyFtU2z3Ldsgt43CLmENxwODDx9nN3hkX7zJHlxrq/ZxbWa8PBVo+YZJ43vw2reurJyVHAkMPnyc1+DaP9JfJZeJagumiSefWFv2rHHilj+u7JvdRENtZQ3G6LJW7MONGgjjJdDmeZPCY0d05kj63YTiU3cBf9mKIKbXEX033ojWT8ixtt0DDE4Q0+uIvhtvROsn5Fjb7gEGJ4jpfz//z6hx+Nz2E2MaHAAO9+x+cfTUws7MIj/8HZIgjorDPbtfHD63/UQacg/+/j8MTpw4DvcsBr9BYHCCGDMGU95gw9kqTm1wLcG9SlOVVrYltusmGD13K3SrjbduV7IcuzEbDUMmamMw5Q02nK0Cg1eUZ89Wma7KuVXvB25tkXFtZfDlg/VvWsF3R0IMV3n3NbEYXAwMrpZr53fpKTstkhzplZFj6y9Ss51mmHTZRDkzbg+rRt2WfNoQlSeedfb5456xBw6HSGczeOS8tM/vUlhummY6sXtiJ7VRaBVmw4lUqA3EGKPWebFdt6pyArWe290grqEpzz5va8vF11d70fcYzskjhX+rXiycuvwLKo7Bqx4bPwbTjKO26oC9hMT8SK/iSl3muyON9ME9a6vO8nOGa/DIq2lPvnvabPhKYXDt5cj1tyhJi1urtYRhDa6d39mZ6qbNOWWy1jdDhWJ52aKRpg3WKFkOITKfWp1Vr4I4t2IaIUbE4Nkh5Umrnd7Ga2e8oHsM5+SR1hm8/LEHdtmD2x400l6lf1QaldjLZtlKRM1anWWj2o/L5oLrWcyPTHXkhRCPIsqIG9w+f4IvUFUlGw7n5JFOaPC4ibIfNW9G0txzXWs9kiYuxXJoRru1SzfSDXu67LYiM0zYgcHPEGc0eOSxTVXasn7Rp1oP4+6zEzY0uD3MrP7yv81DiEwIkcV6g8dfcaOSvYdz8khnM3g2+Kry7NlgmvajptH4+4Hd4T0MbhdmXbUnyu5DVqFWM2GEYfDsbbVKvhi8q8DgcrlNVVrZVu257vpaU+S8UO2+BXuitWL0U3Nuw6RFyollaPeDi5MZPKleMXhnkTB4vDx7Npi2/DEuqfnZSL5daCxOw6SRprMcOz+ymCOzgb6DEVGe+wYcOSuChTcYzglD9O88/22Fh8NftiIIR3miYQ2hu+XHDue00Zt8NwGDEwR/XfYUgcEJYsy4yu7YpQig8fz8rD3lXt0FGJ/Z4D8B+uP5+Vk9d2eR3+jdBKA/MDj0jLUHf/8fBodzc10CRy9VAAEMDuCAwaFbMDiAAwaHbsHgAA4YHLoFgwM4YHDoFgwO4IDBoVtaDJ7dayg+BhgGDA7dgsEBHDA4dAtXUQAc7sjgzzAE8fPtGYMD2NyXwf8Bd86PHz/i5xsGB3C4O4MfPWGwCgwOsCUYHG4JBgfYEgwOtwSDA2wJBodbgsEBtiRu8JSSXSgmNGRqYPABwOAAW2IY3P2CiEzHRs6cZudg8OHB4ABbEtmDz/L9qW+f7R169ix78NOymcEBIKX09vZmr6gk7bXFnKxm7dgyLb6eMfi9U2tw9cS9VpfYg8O5MQyeGTZ7vLS2mPDzd7OXOeKPhtMx+ABwFQVgSyJ7cHvj7Br8Z3gPjsGHB4MDbEn8KopWotn5Z+AKDFdRzgYGB9iSrvbg7nrG4PcOBgfYkm334Flh7R6cqyjDcyODX8+kSGEzZW1V9bd15jZHNbQSP2STym8wogOrrWKTPfjs6yyndg+OwYfnSIPHy8vTNNJKD6IUux1pSFzn9vBr+2Y3VFVz/EWp6lsVc8+fnp7WzNtKXIO7JO8uQyOnPMQAgw9ApwbPngrqL3vKXcZaQnDZx3PKB24TtcMPjiUFzGsUiry8vFS1og2hbSBGoTuoPXDvJjQw1l6WkPRfyLTrweCDcWuDR9Zkdojx2GDZ4sPDg53jVmI/FUmLDDNSfyQ/iHhIpJ4sx+3eVi9lPC0+z5uzfg9+MzD4AOxr8CSRPRvpZWRxag0lxeBuZ4zuxZON4UeasIcWrEqrX9w7u721k5dHRcYb6XZwaLVN78R9GfwH3D/x823LqyhZibHAbJW4FSZ9D263UpsplouC0/S3pm/ufNYqzKgh8qCsxBj7muGXVd37dfCbcYPZgNsQfMUbDV6un+A6f3h4iC88rc5lPa4IIq1oW9e53B57pGlNQIaMyqfsOY+MNNgrsfV4ow3zsyZtb+7I4HA21hq8XO2aj6bF3rlBYe4uTHvWOEpsVysRG7KbNqq1f8wKywfuUfbA7Xy7fvepCJHDtQ7fHgwO3dJi8JTSly9fgqrKnpqvfjQobMnynUBrKygj+0AjIdV8oGr3JzJ8ozCI0SvtgdaK8dJEOhbPcRuqnYQGMDh0y8YGF12zfFY0eEQT8x58WY97oFGiDtvLzLoRNIuRpplInKLyQZz4i1U+FTww2LHIJEfOsduAwaFbGu9FmZQ1byzsqdi0ujJaJmQGd8VXteaTidGrPW5qFHOCI7IHEmk00iWjYw1D0xIwOIDLlveDl0+Vhyw/yXS1ssws9+BJ+aRxeWwy3yHsRu2EK+Ib0vomyrQGi8VzIgQ7tknfxBcu0rGdwODQLQf8TmbcRMuVLF5FCdZQtc7d/FIfy45dLpeykqz/YivxmTFmvraVeOVaTkMTwRwt7WbinsHg0C27/GUrQzHlptVIvtpwktxkdyN7ymglOC4tIRVvLZfLJaX08eNHI62sZNlPuxv2eGtb0dIy7BkwatMqNHAHa8zATmBw6JbNDJ6tQHuZicnl6r3a8Hqp5OnpadJ1YNdvdKnBLFnPy7eW9LvBywfaTGoPIn1raEUbkXi4nW9M1xqC87BJWwZvb2/PAL2iLp95FclPF6tLSygLDcWUlomvUndVb7LgjU7OfPz40e3hfhoKtmKkxXuoVbvhQDapag3XPThAh7QbHOAkXA1+9E4LIGfC4AAus8H/AdAN1z+AZRkcAK7MBr/Z2wacito/Xrg0uHXWTtOUUnp9nQjitJEZ/I+/bhevj/wL+BRcdRzkeir6e/D3/2Fw4txhGFwEg0MttX8THIMTRDS0qyiZyjP5GmBwyMDgBLFXlHvwydO3VpiVf/u12D4pJRj8JGBwgtgrDIOLBA3+6e/p27+mP/6a/vz3NP0tl2Dwk4DBCWKvsA2uCdpg3m6/b73/Of3nbfpTKsHgJwGDE8ReETG48UBT/LffL558kkow+EnIDC7eHIjBCaIlMDjsTbkH1/SNwQmiLpoNrsFVFMgQr6KI+sbgBFEXosGnsMr5JBNctOvgpb4xOEHURXk/uCjlrLxMK8u5mxCu8EkmQewV9m/VL0uyxxqi2cXA4CcBgxPEXqEZ/Iom9PIpuxyDnxkMThB7BX+bEPYGgxPEXoHBYW9+/PhR9d0OGJwgooHBYW92+YaH9/9hcOLcMRu89s/wA+wKBicIPxJfNAi9wresAfhM0/R/AP0R+pa1G72bAHTJbPCjOwLwG1eDa89icIBpwuDQKxgcwAeDQ59gcAAfDA59gsEBfDA49AkGB/DB4NAnGBzAB4NDnzQaPLvXUHwMMAwYHPoEgwP4YHDoE66iAPhgcOgTDA7gg8GhTzA4gA8Ghz7B4AA+GBz6BIMD+GBw6BMMDuCDwaFPMDiADwaHPsHgAD6Kwb8+fvj8fYMSgEYwOIBPafDvnz+klNLCxW0lAGtwDA4AKaW3t7ep3IN///whc3FbCUArfMsagA8Ghz7hKgqADwaHPsHgAD4YHPpkM4Mvr7pU0XzgfpUHjxLT4i3ecsZ2muRdX7uuwODQJ7czuJZgHxj/rKm5Y82HbGXw2h7Gx9vcRLwbKaWnp6faF+XuKA3+fldJSimlx6/tJQBruOkevMxxj2r2r0vk8NrhVHV4manNTNnnYMcul4tWSaQh4yijsG0e7gJ5Dw5wNHsZPGI3WwF2ebwnVQmRLpXJEfHt3VaWfLlcqurXOhZME/tQ+8L1DAaHPrmpwY187ZBaEbjdMCqs6pImUK1+zbxGVdrhkbG4Q1ufvEyrmud7BINDn6z6lrWZ5ZXQKazviMJWimC941yrtrXoKjuSbx8en+SqIZRVnfM6OEAPbLAHF9ewkVz17EoRxH368vIiOmguD1YeabHBdGJ+duxW9qzqUnMr9wUGhz5Za/B5GQfdUbvsq/JFBRssD7EbNdJS/SZ0TdoyXzvWqDNC5HC75+ORG3xxT8n7nYGREoCtuanBS/u4LlujiezYeFXBzKzPweZKFxuZDw8PRt+CTbiTbDRh57gNNb92vZEb/Ovjr3sBvz5e/RwpAdiaVQYXbSKu23JJl2nGgdHRmAfGq6pSmHiU69ZIfpIMPkmTqbXSNgluTkrpy5cvYjdGsvYS/SoKv8MDR7K9wad6fxlHtRmhwSzJpMwUr48b6iwL3R4mDN4NqsEROBxKu8FrfTTd0ODLYw2l2gc2pBlujYy3nMPZ4FWizEZdUjsuo/JlYW1Dd4Ri8PLySKQEYDNW3U0YKdG8E6lBK6yiwSbB/HiH2wpTSg8PD9o0Gp0UJRsf2ubDHwDJ4OgbjqfF4M1Lt9bgW+l7qvR4s8Jct1a1IlZlz2FbH+K4/V//kvWJdC/K72qOlABszTb3gxs3TWeZmX0aHBGkVjpV/iqHnOXUzoaWkF0Hd0cUmWFxZhqYK9m1lU7IDL78A1UppQ+fv0dKDh0BjMk2v1XfsFarZFRbrXHsVlop/aX1xK2htsWV9WzFSIJ24Td6oE/4hgcAHwwOfYLBAXwwOPQJ31UPEGLC4NAf0e+qf32dCOK0gcGhT6JXUQ5fQgRxYBQG//o4b3Pe//pJpARgYzA4QfiRG/y/f7Xq16/MR0oAtgaDE4Qf+lWUr4/5BjtSArANGJwg/JAMfv2VnaWaIyUAW4LBCcIPcw/OX0eBw8DgBOGHcS8Kl1HgQDA4QfiRGfz758dfe+r3/XWkBGBzMDhB+FHei8LNhNADGJwg/OA3eqBPMDhB+IHBoU8wOEH4MRv8j78mgugnMDhB+GEYXOTwhU2cJDA4QfiRGVw0dSlug8NXPjFGYHCC8KPcg7v61gqz8m+/FtsnvYQgtMDgBOGHYXBji+0a/NPf07d/TX/8Nf3572n6Wy4hCCMwOEH4YRs8W1S23JeK/zZvtP85/edt+lMqOdwRRM+BwQnCj4jBjQdZCAb/9bgsOdwRRM/Bt6wBhMDgRIcR/ZY16x+EAKPTbHCNawJXUYiVwXfVA/iIBp+m9wdzifYgi4lPMomNAoMD+KTifvBsIU2TUF6mleXcTUisCQwO4FPuwZcxTepjjcNXPjFGYHAAH83gV8rC7IGWQBArA4MD+CT+NiF0CQYH8DEMbtzEBbA3GBzAJzO4aOpymdh3lwOsp9Hg2d3i4mOAYSj34K6+tUKp/Otj/j2aZQmAAAYH8DEM3vCrcMvy758/pJSW34RclgBocBUFwMc2uJg8xa+ifP/8IfN1WQIggcEBfCIGNx6Itf0XDA6tYHAAHwwOfYLBAXyaDc5VFNgVDA7gIxr8WsgeHA4EgwP4ZAbXPr3MyivuRUkppfT4VS4B0MDgAD7lHrx8VnwcuooC0AoGB/DRDC7quPoqCkArGBzAZzY4QG/wPZkADm9vb9M0/QToD74nE8ABg0O3cBUFwAGDQ7dgcAAHDA7dgsEBHDA4dAsGB3DA4NAt7QZfftppF8YP3+nA5rYAJgwOHXO8wWv1audnd9G0NQGwBINDtxxvcPEo7e7GSP0ppcvlolWCyqEWDA7dsoHBNVE2bJbd5EgrV4NX1Q9ggMGhW6oNbgtUc6Vtedf4VW1ph0cyAUowOHTLMVdRXGVH8u3DG94nAEQwOHTLAQZv8KmYLwodR8PmYHDolrUGTyk9PT1VbXXXpBkGzw5UlyNAJRgcumUDgy9/zJ7VjhIflJkPDw/a4fEmgm8YABoYHLql0eClDWt3x26+aPDpdy/L/dbfGzA4NIDBoVsa70V5eXkx/KgZ2diki7VhcOgBDA7dsuUnmYZbIzItnT4b3NW9WE9S0A4EEMHg0C23uBelrfBq8FK77MHhxmBw6JYb7cEjh4sJhoKN9wBMDRuCwaFbWgyeiuvgmTQjAo0YPLsO7u6pxS5p2N0DmMHg0C2r7kWZlJ2yUV7WEETLR8ewNxgcuoVveABwwODQLRgcwAGDQ7dgcAAHDA7dYhkcAK5gcOiT5+dn66y9ivz1dSKI0wYGh24JXUU5fAkRxIGBwaFbDIP/P9NVonRh9RIfAAAAAElFTkSuQmCC

bigbillybear 发表于 2016-3-28 16:15:04

本帖最后由 通达林河水 于 2016-7-30 15:41 编辑 <br /><br />修改表格自动执行的效果

通达林河水 发表于 2016-4-1 09:53:14

本帖最后由 通达林河水 于 2016-7-30 15:41 编辑 <br /><br />我已记录,如果程序问题,我们将会修复。
页: [1]
查看完整版本: 关于修改表格时使用二级下拉框的过滤公式