I am not sure if a variable array is he right terminology but here is what I
want.

I am exporting data from a Sharepoint list. This data can change everyday
so I need the spreadsheet to reflect that via auto updating.

This is not a problem, works great, the issue is that the data comes in
formated incorrectly for what I need to report on.

The data come in as a list.
Thing Milestone Hours
AAAA 1 2
BBBB 1 3
CCCC 2 2
DDDD 2 4
EEEE 1 1
FFFF 3 5
GGGG 1 3
HHHH 3 1
IIII 3 3
JJJJ 3 3
27


I need to present it organized by milestone.
Thing Milestone Hours
AAAA 1 2
BBBB 1 3
EEEE 1 1
GGGG 1 3
9

CCCC 2 2
DDDD 2 4
6

FFFF 3 5
HHHH 3 1
IIII 3 3
JJJJ 3 3
12

is there a way to create an array on a second work sheet that would only
contain data that matches the Milestone critera?

Thanks

Jeff

--
Jeff