I am new to Excel VBA and need some help writing a macro.
From Worksheet1
of Workbook1
I need to copy each column of range D1:Z100
, one at a time, and pasteValue it to cells B1:B100
.
This triggers a calculation in Worksheet2
of Workbook1
. Here I need to copy cells A1:B200
into a new workbook.
This new workbook is to be renamed with the text string in Worksheet1
, cell B1
. The new workbook is to be saved into the same folder as Workbook1
.
The loop is then to continue with the next column from Worksheet1
, and continue until all columns in the range have been treated this way.
I have used two days searching the net to find an answer without any luck....