R
Ren
hi
i have data in multiple sheets
i want the summary of data in a mastersheet
ex: sheet1 to sheet6
the code is like this
Range("B20") = "summary"
Range("C20").Formula = "=sum('sheet1:sheet6'!c30)"
this code gets the SUM of all data at C30 in sheet1 to sheet6
what i want: is there anyway i can change this so that
i don't have to mention the B20 or C30??
i just say get the "summary" of all the shipout materials
to mastersheet and should be able to get the summary irrespective of the
cell wherever it is.
because everyweek the data keeps adding and i have to change the code
everytime
thanks
Ren
i have data in multiple sheets
i want the summary of data in a mastersheet
ex: sheet1 to sheet6
the code is like this
Range("B20") = "summary"
Range("C20").Formula = "=sum('sheet1:sheet6'!c30)"
this code gets the SUM of all data at C30 in sheet1 to sheet6
what i want: is there anyway i can change this so that
i don't have to mention the B20 or C30??
i just say get the "summary" of all the shipout materials
to mastersheet and should be able to get the summary irrespective of the
cell wherever it is.
because everyweek the data keeps adding and i have to change the code
everytime
thanks
Ren