帮助在VBA中编码 [英] help with coding in VBA
问题描述
您好
我需要帮助excel 2007中的一些vba代码。我试着尽可能详细地描述,下面。我没有看到任何附加xl-doc的选项,否则我可以上传它:
非常感谢您的帮助!!!
描述 标签和列礼仪
标签交易对手
Counterpartyname1
Counterpartyname2
emailadress
包含所有
对手方!!!
template
行
1-16将在每个创建的标签中使用!!!
DATA
AccountingDate
账户
CCY
SUM_AmountOriginalCurrency
sum_AmountLedgerCurrency
CounterPartyEmittentID
第1步
我有一个带有几个标签的xl文件。一个名为交易对手的标签。列A,
,单元格A1中标题为 " counterpartyname1"
包含对方名称。这些名称应该用于创建以单元格A2中的数据命名的新选项卡,直到最后一个值。
B列ha s标题" counterpartyname2"
in cell b1。
< p style ="margin-bottom:0pt"> 它包含用于选项卡中的查找数据的名称"data"(参见步骤3)。要查找/匹配的名称在列中
F在选项卡"DATA"中。
STEP2
名为"template"的下一个标签包含
第1-16行中的模板数据。应插入这些行 在每个创建的选项卡中(在创建选项卡后为step2)。
列 C
包含来自c2及以下的电子邮件地址。这些地址应插入单元格M11中创建的标签中。电子邮件地址位于与
相同的行 Counterpartyname1
用于 命名创建的选项卡!
第3步
名为"DATA"的下一个标签包含A-F列中的数据。数据查找 是
,基于列 F命名为" CounterPartyEmittentID
"在单元格F1中。 这些 值应与tab
中的值匹配 交易对手,B栏。
对于每个 value f2
以及vba代码 搜索
in tab
交易对手 in
列B并在步骤1中创建的创建选项卡中插入在选项卡DATA中找到的数据。此数据放在第17行和第17行。然后创建一个总和
根据插入的数据。 根据B18列中的数据计算总和
。一个以开头的值计算的总和81,一个用于82,一个用于83和一个用于84.总和由
值列 E。
Sverreberre
< blockquote>
你好Sverreberre,
欢迎来到Msdn论坛,关于vba问题是avialible专题论坛,请看下面的链接
http://social.msdn.microsoft.com/Forums/it-IT/isvvba/threads
最诚挚的问候。
Hi
I need help with some vba code in excel 2007. I tried to describe as detailed as possible, below. I dont see any options to attach a xl-doc here otherwise I could upload it:
Many thanks for the help!!!
Description of tabs and column-etiquettes
Tab Counterparties
Counterpartyname1
Counterpartyname2
emailadress
Contains a list of all counterparties!!!
template
Rows 1-16 to be used in each created tab!!!
DATA
AccountingDate
Account
CCY
SUM_AmountOriginalCurrency
sum_AmountLedgerCurrency
CounterPartyEmittentID
STEP 1
I got a xl-file with several tabs. One tab called counterparties. Column A, with header in cell A1 called "counterpartyname1"
contains counterparty names. These names should be used to create new tabs named after the data in cell A2 and down to the last value.
Column B has the header "counterpartyname2" in cell b1.
It contains names to be used for lookup data in the tab "data" (see step3.) Names to lookup/match are in column F in the tab "DATA".
STEP2
Next tab called "template" contains template-data in row 1-16. These rows should be inserted in every tab created (as step2 after creation of the tabs).
Column C in counterparties tab contain emailadresses from c2 and down. These adresses should be inserted in the created tabs in cell M11. The email adress is on the same row as the Counterpartyname1 used for naming the created tabs!
STEP 3
Next tab called "DATA" contains data in column A-F. Lookup of data is based on the column F named "CounterPartyEmittentID " in cell F1. These values should be matched against values in tab counterparties, column B. For each value f2 and down the vba code search in tab counterparties in column B and inserts the data found in tab DATA in the created tab created in step1. This data is placed on row 17 and down. A sum is then created based on the data inserted. The sum should be calculated based on data in column B18. One sum for values that start with 81, one for 82, one 83 and one for 84. Sum is made of the values column E.
Sverreberre
Hello Sverreberre,
Welcome to Msdn Forum , for vba question is avialible dedicated Forum , see link below http://social.msdn.microsoft.com/Forums/it-IT/isvvba/threads
Best Regards.
这篇关于帮助在VBA中编码的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!