VBA - Excel - 帮助！ [英] VBA - Excel - Help!
问题描述
文件说明：
将外部文件中的数据复制到电子表格中，并使用宏为每个部分创建新工作表（完成此位）
我遇到的问题是Control页面中有重复的文件需要复制，我想同时创建它们，而不是让宏关闭并多次重新打开文件。我希望它只是将它们全部粘贴在一个
中，而不是多次复制粘贴。我宁愿它可以找到文档中需要粘贴的部分，然后粘贴它们而不是多次复制。
我最好明天早上想答案。所以，如果您有任何建议，请随时帮助我！
我想知道某个细胞是否在一系列细胞中重复出现例如
A   B  C
1 Z Y X
2 W L U
3 T S R
4 Q P O
5 N'NBSP;  M 然后，它会告诉电子表格而不是用户，B2和C5中存在复制值，这意味着分配给值"L"的路径目录将被分配给值"L"。需要在主文档的相对位置粘贴两次。
如果需要，我将能够提供原始文件将部件复制到文件中的宏是。
通过电子邮件或Skype与我联系;
miles.fraser @ contractor 。 xlgroup。 com
MrAserFiles（Skype用户名）
将每个单元格值输入Collection对象或Dictionary对象。
自动拒绝重复值。
'---
Jim Cone
美国俄勒冈州波特兰市
https：/ /goo.gl/IUQUN2 （Dropbox）
File Description:
Copying data from outside files into a spreadsheet and creating a new sheet for each section using a macro (done this bit)
The problem I have is that there are repeated files in the Control page which need to be copied and I want to create them all at the same time rather than having the macro close and re-open the file multiple times. I want it to just paste them all in one go rather than copy and paste it multiple times. I would rather it could find the parts in the document that needed it to be pasted into and then have them be pasted and not copied multiple times.
I would preferably like an answer by tomorrow morning. So please if you have any suggestions feel free to help me!
I want to find if a certain cell repeats itself in a range of cells for example
A B C
1 Z Y X
2 W L U
3 T S R
4 Q P O
5 N M L
It would then tell the spreadsheet, not the user, that there is a copied value in B2 and C5 this would mean that the path directory allocated to the value "L" needs to be pasted twice in the relative place in the main document.
If needs be I will be able to provide the original file that the macro to copy the parts into the document is.
Contact me via email or Skype below;
miles.fraser @ contractor . xlgroup . com
MrAserFiles (Skype User ID)
解决方案Feed each cell value into a Collection object or Dictionary object.
Duplicate values are automatically rejected.
'---
Jim Cone
Portland, Oregon USA
查看全文
