Hello Mr Sam,
Thank you very much of your help.
Regards
Son
2011/11/28 Sam Mathai Chacko
> Great, so no modifications required for Excel 2010
>
> The code below works for both 2003 and 2010
>
>
> Sub Consolidator()
>
> Dim rngStart As Range
> Dim varArray As Range
>
>
> Applicatio
Chacko
Sent: Monday, November 28, 2011 8:32 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help me with a macro
Great, so no modifications required for Excel 2010
The code below works for both 2003 and 2010
Sub Consolidator()
Dim rngStart As Range
Dim varArray As Range
Great, so no modifications required for Excel 2010
The code below works for both 2003 and 2010
Sub Consolidator()
Dim rngStart As Range
Dim varArray As Range
Application.ScreenUpdating = 0
Range("F1").CurrentRegion.Clear
With Cells.Find(What:="Machine", Lookat:=xlWhole,
sear
Hi Sam
I tried on office 2010 ,result is ok.Could you send me a modified version
2003 and explain for me a bit of this code as i am a beginer of VB.
Thanks a lot
Son
2011/11/28 Sam Mathai Chacko
> Son, the macro is written for 2007-10. Will send a modified version,
> but before that, can you c
Son, the macro is written for 2007-10. Will send a modified version,
but before that, can you confirm the result is correct in 2007-10? If
not, what is the issue?
Sam
On 28/11/2011, son nguyen wrote:
> Hi Mr Sam.
> I wonder this code used for which office as 2003,2007,2010.Because my
> office is
Hi Mr Sam.
I wonder this code used for which office as 2003,2007,2010.Because my
office is 2003 and result is not to like my desirement.
Hope that you can feed back more to me
Regards
son
2011/11/27 Sam Mathai Chacko
> Here's a macro to get this done
>
> Sub Consolidator()
>
> Dim rngStar
Hi Rajan,
Thank you very much but i like macro better because it is really fast.As
you known my sheet is large with lots of rows.
Hope that your experience'll help everyone .
Regards
Son
2011/11/27 rajan verma
> Hi
> Please see the attached file.. Pivot table can be used for this ..
>
> Reg
Here's a macro to get this done
Sub Consolidator()
Dim rngStart As Range
Application.ScreenUpdating = 0
Range("F1").CurrentRegion.Clear
With Cells.Find(What:="Machine", Lookat:=xlWhole,
searchDirection:=xlNext, After:=Cells(1))
Set rngStart = Range(.Offset(1), .Offset(, 1).En
Hi
Please see the attached file.. Pivot table can be used for this ..
Regards
Rajan
On Sat, Nov 26, 2011 at 8:23 PM, son nguyen wrote:
> Dear all,
>
>
> I have problem of calculating sheet.Detail as sheet attached.
> I want to have a macro to sum value within qty, and downtime column then
> del
Dear son
Here with i attached excel file using sumif command.
Mothilal
On Sat, Nov 26, 2011 at 8:23 PM, son nguyen wrote:
> Dear all,
>
>
> I have problem of calculating sheet.Detail as sheet attached.
> I want to have a macro to sum value within qty, and downtime column then
> delete produc
Dear all,
I have problem of calculating sheet.Detail as sheet attached.
I want to have a macro to sum value within qty, and downtime column then
delete products are duplicated within each machine.
I look foward to hear your help asap
Best Regards
Son
--
FORUM RULES (934+ members already BANN
11 matches
Mail list logo
