can this be used dynamically? I've been trying it but cant work out how
to use it...
i would like it to work when u change the input data without having to
press anything else...
It's not a dynamic solution. You would need to hook it into a
Worksheet_Change event procedure to make it appear dynamic. Chip Pearson has
a page or two on Excel events: