transfer data

D

daddyosworld

how do I get data that auto updates totals and percentages to do so on
another sheet ( sheet1 to sheet2), in other words I've made a
spreadsheet that is a daily sheet that auto updates to a weekly total
on sheet 1, I want to make another sheet to take weekly into
monthly.. copy and paste leaves a #REF error.
 
B

Bernie Deitrick

Use Copy / Pastespecial and choose the Paste Link option.

HTH,
Bernie
MS Excel MVP
 
Top