|
|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
子表数据：输入某个特定值，能运行宏从子表商品明细得到数据表格标题的内容。
子表商品明细：原始提供数据行
| 输入： | 安心寨LHHVV | | | | 站点名称 | 任务名称 | 商品名称 | 商品用途 | 收货状态 | 订单附言 | 采购时间 | 通知供应商发货时间 | 供应商发货时间 | 用户确认到货时间 | [tr] [/tr]
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 要求： | 能够输入H1单元格数据，从子表商品明细链接出以上数据 | | | |
| 站点名称 | 任务名称 | 供应商名称 | 商品名称 | 商品货号 | PMS物料编码 | 规格 | 数量 | 单位 | 单价 | 合计 | 需求单位 | 商品用途 | 地址 | 收货人 | 电话 | 收货状态 | 订单附言 | 采购时间 | 通知供应商发货时间 | 供应商发货时间 | 用户确认到货时间 | 净价 | 建安费单价 | 运费单价 | 税 | 企业价 | 净值 | 税额 | 总金额 | | 安心寨LHHVV | 1 | DA | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2017-03-07 19:14:27 | 2017-03-07 19:14:32 | 2017-03-08 09:39:51 | 2017-03-07 19:14:32 | | 安心寨LHHVV | 2 | SA | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2017-03-07 19:14:27 | 2017-03-07 19:14:32 | 2017-03-08 09:39:51 | 2017-03-07 19:14:33 | | 安心寨LHHVV | 3 | FS | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2017-03-07 19:14:27 | 2017-03-07 19:14:32 | 2017-03-08 09:39:51 | 2017-03-07 19:14:34 | | 安心寨LHHVV | 4 | SDA | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2017-03-07 19:14:27 | 2017-03-07 19:14:32 | 2017-03-08 09:39:51 | 2017-03-07 19:14:35 | | 安心寨LHHVV | 5 | GDF | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2017-03-07 19:14:27 | 2017-03-07 19:14:32 | 2017-03-08 09:39:51 | 2017-03-07 19:14:36 | | 三铺 | 6 | RT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2017-03-21 09:50:35 | 2017-03-21 09:50:41 | 2017-03-21 10:00:24 | 2017-03-07 19:14:37 | | 三铺 | 7 | DS | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2017-03-21 09:50:05 | 2017-03-21 09:50:15 | 2017-03-21 10:00:24 | 2017-03-07 19:14:38 | | 三铺 | 8 | SDZ | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2017-03-21 09:48:52 | 2017-03-21 09:48:56 | 2017-03-21 10:59:11 | 2017-03-07 19:14:39 | | 三铺 | 9 | FSF | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2017-03-21 09:48:52 | 2017-03-21 09:48:56 | 2017-03-21 10:59:11 | 2017-03-07 19:14:40 | | 高坡 | 10 | GDFS | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2017-03-21 09:41:17 | 2017-03-21 09:41:24 | 2017-03-21 10:00:24 | 2017-03-07 19:14:41 | | 高坡 | 11 | CDSS | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2017-03-21 09:41:17 | 2017-03-21 09:41:22 | 2017-03-21 10:00:24 | 2017-03-07 19:14:42 | | 高坡 | 12 | FSFD | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2017-03-21 09:40:28 | 2017-03-21 09:40:34 | 2017-03-21 10:00:24 | 2017-03-07 19:14:43 | | 高坡 | 13 | FSFSD | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2017-03-21 09:37:46 | 2017-03-21 09:37:52 | 2017-03-21 10:59:09 | 2017-03-07 19:14:44 | | 高坡 | 14 | ERWER | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2017-03-21 09:37:46 | 2017-03-21 09:37:52 | 2017-03-21 10:59:09 | 2017-03-07 19:14:45 | | 3XX-刘官洋西LHHD | 15 | FSDFS | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2017-03-21 09:33:15 | 2017-03-21 09:33:23 | 2017-03-21 10:00:24 | 2017-03-07 19:14:46 | | 3XX-刘官洋西LHHD | 16 | FSDS | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2017-03-21 09:33:15 | 2017-03-21 09:33:23 | 2017-03-21 10:00:24 | 2017-03-07 19:14:47 |
|
|
沪公网安备 31011702000001号 沪ICP备11019229号-2
发表于 2017-3-21 20:21
