Please, this is for VBA excel code using offset and anchor cell. Please answer all question and do not give inappropriate, thanks.

....o T-Mobile r o 69% 11:45 AM 4) Using the worksheet Data in the attached file, write a sub that will do the following a) use cell A3 as an anchor cell b) locate the cell where the word Bins is located c), declare a dynamic array (name it Bins) as a single and a dynamic array (name it Cnt) as an integer d) count the number of bins using range properties (ie. count, etc) e) re-dimension the array Bins to have the number of bins specified in the worksheet and in d) re-dimension the array Cnt to have the number of bins plus one g) write a sub that will count the number of times the 'amount purchased is below the first value in the Bins array and place in the first element of the array Cnt, the number of times is greater than the first value and less than or equal to the second the amount purchased value in the Bins array and place it in the second element of array Cnt, and so on. The last lement of the array Cnt will include the number of times the "amount purchased exceeds the last value in the Bins array. h) write next to the column for the Bins, the numbers collected in the Cnt array. Note that the Cnt array has one more element than the Bins array. Your code should run for a different number of Bins and a different data set with A3 as anchor cell. For the example given in the worksheet, the column for Counts will look as follows: Bins Counts 76 100 DOO 294 700 63 1000 53 61 ustomer orders 3 Order date ustomer IC Amount purchas 4 2-1an-05 190 5 2 Jan-05 $574 an 05 120 $1,911 6 3 7 3 Jan 05 192 $593 8 3 Jan 05 $2,782 9 3 Jan 05 4 Jan 05 113 5301 11 4 Jan 05 12 4 Jan 05 $421 13 4 Jan-05 $1,130 14 4 Jan-05 154 Jan-05 119 16 5 Jan 05 17 5 Jan-05 18 5 Jan 05 141 19 5 Jan 05 20 5 Jan 05 21 6 Jan 05