I have a matrix format in excel that i need to fill in with a formula.
I was wondering if there was any vba code that could help me with this.
Example,

Policy Number Name Date

429438
975288
759284

I am going to be using a lookup function to fill in name and date, I
was hoping to get code that evaluates the # of fields and rows first
then copies in the encompassing cells. Thanks for the help.