Thanks to all! I knew there was an easy way to do that, but I forgot
about paste link. Works perfectly.

On Sun, 11 Jan 2009 21:53:00 -0800, Deepali Joshi
wrote:

Hi,

Select Original Table, Copy it

select the location from other sheet where you want to copy the table.

Click Edit--Paste Special, from Paste Special dialog box, select All from
Paste options, and click on Paste Link button. This will paste the table in
other sheet in such a way that when you'll make changes in original sheet
that would get reflected in the other sheet.

I am sure, this will help you


"JimS" wrote:

I just want to copy a small table from one sheet to another. Whenever
it is updated on the main sheet, it will also be automatically updated
on the second sheet. When I put it on the second sheet it will be in
a different area as well.

Can you do this without macros?

Thanks (I have ASAP utilities, but after fiddling with it all morning
I drew a blank.)