I am looking at automating a report, so i have cells that are
referenced to a sheet with a specific name "DUMP" . Access is unable
to export data to that specific sheet, so it creates a new sheet called
DUMP1 everytime..What i need to do is put a macro, which i can execute
from access immediately after the export, so that the sheet DUMP gets
populated with all the data on DUMP1 (sheet that just came in from
access), so that the formula reference works fine.

I cannot put formula reference to sheet DUMP1, because the DUMP1 doesnt
exist, but only is created when exported. When the sheet doesnt exist,
the formula changes to #REF error.

I tried a macro and it works fine, except in cases of large chunks of
data...Maybe i will try a macro which inserts the formula in the
specific cells mentioned...
Can you please help me, as to how a macro can be asked to paste a
formula on different range of cells in a sheet, like from C1:C20 and
C25:C40 and so on..

Cheers!