如何将数据从一个工作簿工作表发送到不同工作簿的不同工作表 [英] How to send data from one workbook work sheet to different workbook different work sheet
问题描述
我正在处理一个宏,该宏会将数据从具有不同工作表的多个工作簿文件传输到具有2个工作表的一个工作簿中
例子
就像我有3个工作簿一样
(A)与库仑的销售订单
(1.)orderno
(2.)orderdate
(3.)shipto
(B)装运
(1.)shipmentdate
(2.)数量
(3.)orderno
(C)第三份工作簿交付
(1.)deliveryboy
(2.)交货日期
(3.)orderno
仅包含一张带有信息的工作表1
我想通过唯一的密钥验证将这些文件中的数据发送到称为跟踪器的第四个文件
有两张纸
1.发货不当,如发货到,交货日期,交货人,数量,订单数量有序错误
2.订购具有序号orderno,orderdate,orderno
并根据同伴的名字
我刚刚开始vba.请有些人帮助我.我是这个的初学者.只知道初学者的东西.
谢谢你
Akshay sharma
i am working on a macro that will transfer the data from multiple workbook files with differents worksheets to one work book with 2 worksheet
Example
Like i have 3 workbooks as
(A)sales order with coulmn
(1.)orderno
(2.) orderdate
(3.)shipto
(B) shipment
(1.)shipmentdate
(2.)quantity
(3.)orderno
(C)third workbook delivery
(1.)deliveryboy
(2.)deliverydate
(3.)orderno
with only one sheet1 with information
and i want to send the data from these file with unique key validation to fourth file called tracker
which has two sheets
1. shipment having coulmn like shipto , deliverydate , deliveryboy , quantity ,orderno not in orderly manner manner
2. ordering having coulmns orderno , orderdate , orderno
and according to name of the coulmn
i have just started vba .Please some body help me out.i am beginner in this . just know beginner stuff.
thanks you
Akshay sharma
推荐答案
快速学习VBA功能的最简单方法之一就是使用Excel的宏记录功能,从而:
One of the easiest way to learn VBA functions quickly is to use the Macro record feature of Excel thus:
- 从菜单中选择
Tools -> Macro -> Record New Macro
. - 执行工作簿/工作表中所需的任何功能.
- 按停止记录按钮.
- 打开编辑器中的新宏以查看代码,并根据需要进行修改.
- Select
Tools -> Macro -> Record New Macro
from the menu. - Perform whatever functions you need in your workbooks/sheets.
- Press the stop recording button.
- Open the new macro in the editor to see the code, and modify as necessary.
这篇关于如何将数据从一个工作簿工作表发送到不同工作簿的不同工作表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!