PDA

View Full Version : copy range with cell link



reza_doang
07-12-2010, 08:17 PM
hi all,

i have a workbook with many sheets. In every sheet i have many rows with total and sub total.
i attach my sample, in that sample i have 2 sheet (data & rekap).
in data sheet i already give different color in purpose to create summary.
what i want to do, in data sheet i filter by color and choose the yellow one. After that i drag my mouse to get range then copy to another sheet but with cells link. As you can see in rekap sheet, they have =data!xx, so every time i update data, rekap sheet always get updated. In this rekap sheet i have many summary from other sheets.
hope you not confused with my explanation (sorry, i'm not good with english)

thanks

p45cal
07-13-2010, 03:50 AM
Instead of just Pasting, choose Paste Special, then choose the option Values. If you want the formats too, immediately you have pasted Special, Paste Special again and choose Formats.