Array Partial Paste

[Aphyx]

I have assigned a bunch of data to 3 dimentional array without any problems. My problem is in extracting part of the 3d array at a time to be pasted at once statring at my activecell.

Details: Lets say I'm tracking Years, Produce, Yeild. I want to paste data into a sheet one Year at a time showing each Produce and Yeild for that Produce. Each Produce type is unique and the Yield is irrelevant and is just part of the data I want to show.

I can place the headers ok, but I can't seem to figure out how to paste all data from 1 year at one time thus giving me control back so I can place the header for the next Year and then the next Year's data . Maybe I am going about it the wrong way.

What I am ultimately trying to do is manipulate data in a more efficient way with less pasting to individual cells, switching sheets, and switching workbooks using countless loops. My assigning of the 3d array seems sound as I could step through the array in the Watch window and all was assigned as expected, so Array is declared, created and filled.

Any help on the array extraction is greatly appreciated.

[patel45]

I think we need more details and your file