Excel - Manipulate Whole Columns of Data At Once

[Dominic_Fichera]

Hi All,

It's been a while since I've posted here, but was wondering if anyone had any tricks on manipulating whole columns of data at once, more specifically, if there was any way to copy a whole column from one document to another. In my example, I'm opening 4 Excel documents and combining them into one (and in another, I'm combining 4 sheets into 1). At the moment, the script iterated through each row and copies everything cell-by-cell, but this is a pretty slow process when the excel files have close to 100000 rows.

Thanks!

Dominic Fichera

[Marcus Tettmar]

This seems like an Excel question, not a Macro Scheduler question. But perhaps you want to trigger this from Macro Scheduler.

Excel has VBA which will let you do almost anything. What I would do is record what you want to do in Excel. This will create an Excel VBA macro. Then you can either trigger this macro from Macro Scheduler, or convert the VBA that was produced into VBScript which you can run from within Macro Scheduler.

See: http://help.mjtnet.com/article/19-conve ... o-vbscript