Question

我对以前的问题进行了彻底的调查,但我看不到我所期望的。

Daily I have to download a file from the internet, the columns of which are always the same, but the values (in all but the title row) are the different. There are many columns which I don t need to pay attention to.

I d like to be able to create a macro that I will link to a button in Excel that will: Take certain columns from one sheet, and paste them to a new blank sheet or workbook.

我在搜索时发现的大多数结果似乎含有以下规则:“如果是”,或“何时......”,等等。

我只是想做一些事情: Column: C, N, AC, AG, AZ, others, and Paste them to栏A, B, C, D, etc. in another blankmap.

Answer 1

幸运的是,起草守则就是这样。只是制造了一种 but子和一种点击方法,然后将这种方法放在其中:

Sheets("Sheet3").Select
Columns("A:A").Select
Selection.Copy
Sheets("Sheet4").Select
Range("A1").Select
ActiveSheet.Paste

你们需要为每个栏目做这一垫子,但如果你为用户建立一个冰层,则可以在代码上做到。

友情链接