Hello, I need help figuring out an array macro. I need to run a macro from
one page, check a cell on another page to see if it is a 1 or a 2, if it is a
1 I need to take a range of cells and store it to a macro for later use, and
if it is 2 store it in another macro for later use. Then take each of the
built array's and place them in a specific range of cells. I have tried
numerous things but nothing seems to be working for me. Any ideas or
thoughts from anybody?

Thanks,