Hi Azam,

Thanks for the reply.

The method you provided is hardcoding on each cell on Table 'B' get get reference.

However, Table 'B' that I've mentioned in the enquiring summary 'does not exists'. It only exists when a formula/pivot table is created to sieve through the data from Table 'A' then subsequently produced Table 'B' as an end results.. More automation on my queries.

Any help on such instance?