复制Excel列并将所有列附加到1张表 [英] Copying Excel columns and appending all to 1 sheet
问题描述
嗨伙计 -
我今天早些时候发布了,但我的要求略有改变,所以这是我的最终要求,希望你能提供帮助。 我有一个Master" Utility"我需要使用"Sheet1","Sheet2"和"Sheet3"更新的excel文件。来自另一个excel文件的
内容。
I posted earlier today but my requirements changed slightly so this is my final requirements and I hope you can assist. I have a Master "Utility" excel file that I need to update with "Sheet1","Sheet2", and "Sheet3" content from another excel file.
我需要选择E,AA和A列; V从所有(3)张中的Row1开始并粘贴到Sheet"HC_Input"中。我的主人"实用程序"中的第2行excel文件。 然而,需要注意的是,来自源的col E进入目标中的col A,来自源
的col AA进入目标中的col B并且源中的col V进入目标中的col E进入B,并且V进入E. 
I need to take Columns E, AA & V starting in Row1 from all (3) sheets and paste into Sheet "HC_Input" Row 2 in my Master "Utility" excel file. However, the caveat is, col E from source goes in col A in target, col AA from source goes into col B in target and col V in source goes in col E in target goes in B, and V goes in E.
或者我的另一个选择就是粘贴在Col AC中,然后在B之后插入两列?
Or my other option is to just paste in Col A-C, and then insert two columns after B?
我有将每个工作表附加到"HC_Input"时遇到问题,我还需要帮助樱桃挑选列并在最后一行之后附加它们。
I'm having trouble appending each sheet to "HC_Input", I need help cherry picking columns as well and appending them after the last row.
非常感谢你的帮助!
推荐答案
尝试这样的宏,存储在Master Utility文件中:
Try a macro like this, stored in your Master Utility file:
这篇关于复制Excel列并将所有列附加到1张表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!