alexandro88
11-04-2011, 10:18 PM
Sheets(Array("Ori", "LW", "day")).Select
Sheets("Ori").Activate
vResult_Total1 = FormatPercent((vResult1 / vResult3), 4)
vResult_Total2 = FormatPercent((vResult2 / vResult3), 4)
zResult_Total1 = FormatPercent((zResult1 / zResult3), 4)
zResult_Total2 = FormatPercent((zResult2 / zResult3), 4)
I want transfer the total calculate data to another sheet ("day") for every day.
ColA ColB Col C Col D Col E Col F ColG
Mon Tues Wed Thur Friday Sat Sun
Sheets("Ori").Activate
vResult_Total1 = FormatPercent((vResult1 / vResult3), 4)
vResult_Total2 = FormatPercent((vResult2 / vResult3), 4)
zResult_Total1 = FormatPercent((zResult1 / zResult3), 4)
zResult_Total2 = FormatPercent((zResult2 / zResult3), 4)
I want transfer the total calculate data to another sheet ("day") for every day.
ColA ColB Col C Col D Col E Col F ColG
Mon Tues Wed Thur Friday Sat Sun