referring to range( columns) and looping and paste it

C

ccching79

Hi,

I felt confusion.. about the coding…
I also got similar problem to that example… Can u help me!!!!

In fcbga sheet, that got one button to let the user click the month an
item they wanna …
Let said the user choose jan so later the user also select/click th
POR, POR Equip and Maning Ratio..
They will auto select the value from the related sheet.. for the PO
based on sheet HC ForeCast, POR Equip is based on sheet Equip summar
and Maning Ratio will based on sheet Mses HC.
the password to open the sheet is twtan


In the sheet equipment summary a bit different compare another shee
because in this sheet is in week…
For Jan is start fr WW 01 to WW 04
Feb fr WW 05 to WW 08
Mar fr WW 09 to WW 13
Apr fr WW 14 to WW 17
May fr WW 18 to WW 21
Jun fr WW 22 to WW 26
Jul fr WW 27 to WW 30
Aug fr WW 31 to WW 34
Sep fr WW 35 to WW 39
Oct fr WW 40 to WW 43
Nov fr WW 44 to WW 47
Dec fr WW 48 to WW 52

Example data fr column A
APL FC1/3 7.7 7.8 6.5 7.6
FC5 0.0 0.0 0.0 0.0

It will take average, for FC1/3 7.7 + 7.8 + 6.5 + 7.6 = xx /4 + 0.0
0.0 + 0.0 + 0.0 = xx/4 = XXX
so, it will get the value XXX to paste in sheet fcbga in relate
month…

if anyone know it.. pls help me a look … I will attach the excel fil
in!!
 
C

ccching79

ccching79 said:
*Hi,

I felt confusion.. about the coding…
I also got similar problem to that example… Can u help me!!!!

In fcbga sheet, that got one button to let the user click the mont
and item they wanna …
Let said the user choose jan so later the user also select/click th
POR, POR Equip and Maning Ratio..
They will auto select the value from the related sheet.. for the PO
based on sheet HC ForeCast, POR Equip is based on sheet Equip summar
and Maning Ratio will based on sheet Mses HC.
the password to open the sheet is twtan


In the sheet equipment summary a bit different compare another shee
because in this sheet is in week…
For Jan is start fr WW 01 to WW 04
Feb fr WW 05 to WW 08
Mar fr WW 09 to WW 13
Apr fr WW 14 to WW 17
May fr WW 18 to WW 21
Jun fr WW 22 to WW 26
Jul fr WW 27 to WW 30
Aug fr WW 31 to WW 34
Sep fr WW 35 to WW 39
Oct fr WW 40 to WW 43
Nov fr WW 44 to WW 47
Dec fr WW 48 to WW 52

Example data fr column A
APL FC1/3 7.7 7.8 6.5 7.6
FC5 0.0 0.0 0.0 0.0

It will take average, for FC1/3 7.7 + 7.8 + 6.5 + 7.6 = xx /4 + 0.
+ 0.0 + 0.0 + 0.0 = xx/4 = XXX
so, it will get the value XXX to paste in sheet fcbga in relate
month…

if anyone know it.. pls help me a look … I will attach the excel fil
in!!!
Click to expand...
 
C

ccching79

ccching79 said:
*Hi,

I felt confusion.. about the coding…
I also got similar problem to that example… Can u help me!!!!

In fcbga sheet, that got one button to let the user click the month
and item they wanna …
Let said the user choose jan so later the user also select/click the
POR, POR Equip and Maning Ratio..
They will auto select the value from the related sheet.. for the POR
based on sheet HC ForeCast, POR Equip is based on sheet Equip summary
and Maning Ratio will based on sheet Mses HC.
the password to open the sheet is twtan


In the sheet equipment summary a bit different compare another sheet
because in this sheet is in week…
For Jan is start fr WW 01 to WW 04
Feb fr WW 05 to WW 08
Mar fr WW 09 to WW 13
Apr fr WW 14 to WW 17
May fr WW 18 to WW 21
Jun fr WW 22 to WW 26
Jul fr WW 27 to WW 30
Aug fr WW 31 to WW 34
Sep fr WW 35 to WW 39
Oct fr WW 40 to WW 43
Nov fr WW 44 to WW 47
Dec fr WW 48 to WW 52

Example data fr column A
APL FC1/3 7.7 7.8 6.5 7.6
FC5 0.0 0.0 0.0 0.0

It will take average, for FC1/3 7.7 + 7.8 + 6.5 + 7.6 = xx /4 + 0.0
+ 0.0 + 0.0 + 0.0 = xx/4 = XXX
so, it will get the value XXX to paste in sheet fcbga in related
month…

if anyone know it.. pls help me a look … I will attach the excel file
in!!! *
Click to expand...
 
Top