VBA more efficient

[benoj2005]

Hi

I've got a workbook where some VBA code puts a formula in a range, similar to in the attached simple example.

Due to the size of the tables involved this can take a while to calculate so I was wondering if maybe VBA code would be more efficient to get to the same result. I had in my head maybe some sort of loop but before I try and think how to properly code it to test it, I was wondering whether anyone had a view of whether it maybe a more resource friendly method or whether not to bother.

The loop I was imaging was along the lines of this

For each cell in range F4 to N9, loop through and
Check for the parent from column E in the other table in column C
Then for each iteration that parent appears in column C
Set the cell value to the childs name from column A

Thanks