On Aug 20, 9:00 pm, Barb Reinhardt
wrote:
Can you be more specific on what data you want to stack and where you want it
stored?

Thanks,
Barb Reinhardt

" wrote:
Hello,

I actually have 2 issues I am trying to solve. I am taking data and
stacking it on top to have 1 row of data to run correlations.

I have a cell (N_Size) that has the number of rows I want to be
selected starting at D3. I don't know how to reference this named
cell to select the number of rows specified in it.

Next I don't know how to loop this code to repeat X amount of times to
stack the data on top of each other.

So just as an example, I have a 150 in B3 (# of rows wanted to be
selected in D3) and 5 in B5 (# of columns that I want stacked on top
of each other starting with D3). How do I get this to happen in a VBA
code.

Thanks for any help/guidance you can give.

PC

The data that is going to be stacked are numbers. They are %
allocations of market share. They need to be stacked on top of each
other along with stacking other information to run a correlation on
the market share.

It is going to be copied and pasted on another sheet.

Thanks for any help.

PC