Hi all,

I have a workbook with 10 worksheets out of which i created a new workbook
with just 1 worksheet from original workbook.I was wondering how can i write
a macro so that whenever data gets updated i.e changed or added or deleted in
original worksheet the same is reflected in newly created copy.

Thanks