我想在整个电子表格中重复插入一个列表(下面:生成器,控制塔等) . 它应该每隔一行(每个涡轮机后)插入并偏移一列,如下所示 . 我不知道如何编写宏来自动执行此操作 . 任何帮助表示赞赏 .
TURBINE A-2
Generator
Control Tower
Brakes
Pitch System
Hydraulic System
Cooling System
Oil Filtration System
Lighting System
Ascent System
Scada Systems
Nacelle Cover
Cable System
Fire System
Blades
TURBINE A-3
Generator
Control Tower
Brakes
Pitch System
Hydraulic System
Cooling System
Oil Filtration System
Lighting System
Ascent System
Scada Systems
Nacelle Cover
Cable System
Fire System
Blades
TURBINE A-4
TURBINE A-5
TURBINE A-6
TURBINE A-7
1 回答
这应该做的伎俩:
我假设TURBINE条目都在excel文件的第一列 .