No no, you can do a macro to do all that, here is an example of something I wrote to do just that:
This macro is cutting and pasting two large blocks from one workbook and then updating another. This is taken from a much larger thing I did and was used in something that was already in a loop, hence the use of variable "i" as a counter. This is really simple if the bits you are copying from and to are set ranges, it is as simple as this. However, I am guessing that there is slightly more to what you are doing. What is the condition that decides what is being copied? And what decides where it goes?
Bookmarks