Moving a table to another sheet

[skatmandu2002]

Hiya,

I made a sheet which contains a load of data, and then I made (on the same sheet) a big complex table, which calculates all sorts of things based on the data (i.e. pretty much everything in the table links to this data).

Now that I've made this sheet, I've stupidly decided that I want to table on a different sheet, but to obviously still link to all the data on the same sheet. Copy & Paste obviously wont work.

I've never used paste special before, but I had a play around and can't figure out how to do it. Pasting special values won't do either because the data can change and thus the values in the table will change.

Hope this makes sense, any help would be mint. Cheers

[Stuie]

hi skatmandu2002,

If you want to paste forumla over to another sheet, have you tried Paste Special>Forumlas.

[skatmandu2002]

This doesn't work, none of the links to the data which is still in the first sheet works. The formulas all read #REF!