Thank you Rory.
I think I had the first bit, so Q1 rephrased is (say) having populated array "y." with data records, how do I the select an (record) element from it eg the fifth record? Or is it as simple as "y."(5)? See below
Q2: Solved - thank you
Q3: say my array has 12 records (eg months of data - see below for an example) and I want to smooth the data, do I dump the array element out (ie unpack just the sales info eg y.mySingle) or do I access the data with Range (y.mySingle(Range?(what):Range?(what)

R#1: y.myDate ="Jan 10", y.mySingle = 123, y.myString = "Southern", ...
R#2: y.myDate ="Jan 11", y.mySingle = 456, y.myString = "Southern", ...
R#3: y.myDate ="Jan 12", y.mySingle = 789, y.myString = "Southern", ...
R#4: y.myDate ="Jan 13", y.mySingle = 212, y.myString = "Southern", ...

I hope this is not too dumb! I do not have Excel data loaded yet because I wanted to build my solution first so I know how to import the data (format) into excel then manipulate it with vba.
I want to learn vba so thats why I am attempting this - perhaps novice rather than newbie.
Thank you Rory