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
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