date:20160512

$$Excel-Macros$$ Re: Excel Training Material (PPT)

2016-05-12 Thread Pawan Yadav

Nice PPT. Thanks.

On Wednesday, 12 June 2013 09:25:24 UTC+5:30, Prabhakar S H wrote:
>
> Dear Team,
>  
> MY HR given me responsibility to give training on Excel to my Marketing 
> team. So can you send me the materilals on Basic & advance traning.
>  
> I have engough experience on Excel but don't know where to start.
>  
> So please send me either PPT or material on Basic as well as advance 
> trainnig.
>  
> Pls help.
>  
> Rgds,
> Prabhakar
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ need help with Evaluate function

2016-05-12 Thread Jaime Richmond

I am looping thru and getting a count of values in an array for a specific 
user in a single row range.  I switch to another range and add in the value 
fro that rnage

Here is the code:
If Evaluate("ISREF('" & "Game" & i & "'!A1)") Then
 Set ws = ThisWorkbook.Sheets("Game" & i)
 Else
 Set ws = ThisWorkbook.Sheets("Games")
 End If

 With ws
'for each game get the range for the names
'Provide the correct range for the specific Game
Set Rng = .Range("Game" & i)
r = Rng.Row
C = Rng.Column
iRows = Rng.Rows.Count
iCols = Rng.Columns.Count

'need to lop thru each player in the grid, get values if match
For p = 1 To iRows
'get value if name matches
sName = .Cells(r + p - 1, C)
If sName = Player Then
'add up
sPos = "=" & Position
Set RngPlayerGame = .Range(.Cells(r + p - 1, C), 
.Cells(r + p - 1, C + iCols))
iCount = iCount + ws.Evaluate("COUNTIF(RngPlayerGame," 
& Chr(34) & "=B" & Chr(34) & ")")'.Evaluate("=COUNTIF(.Cells(r + p - 1, 
C), .Cells(r + p - 1, C + iCols) ,Chr(34) & ='& Position)")
End If
Next

It does run, no errors, but returns a value of 0 which is incorrect.  
Answer is 1, then 2, then 1,1,2,1 for the first player.

But if I use :
   '=COUNTIF(B3:G3,"=B")

I get the correct value.  CLearly I need to use parameters and fnot hard 
code.  

In advance - THANK YOU so much.  This one has me by the short hairs!

jaime

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Urgent need AEM Architect - Hartford, CT

2016-05-12 Thread MADHU-GenuineItLlc

*AEM** Architect*

*Type of Hire:* contract

*Locations:* Hartford, CT



*MSM is the Key Skill we need for this position and need to be senior
candidate.*





*Job Description:*

· Basic AEM knowledge

· Must have done translations in AEM

· Should have worked with various translations vendors for
automated translations in AEM (ex: translations.com)

· Must have working knowledge of AEM integration with automated
translation vendors

· Knowledge on best practices and standards for doing multi
language rollout

· Multi-Site Manager module knowledge a must

· Should have worked with blueprint, livecopy features.

· Must have Java/J2EE, HTML, CSS/JS knowledge





---

*With Warm Regards *

*Madhu Roy*

GenuineIT LLC *Certified Women Owned Business*

Making IT Happen…

Ph: 832 539 3475

Fax: 281-605-5969

*E-Mail* :ma...@genuineitllc.com

*Gmail *: *nandimadhu74 , madhu.genuineitllc*

*YM  *: madhu_recruiter



Looking ahead to work with you for better Business prospects



According to Bill S.1618 Title III passed by the 105th US Congress, this
message is not considered as "Spam" as we have included the contact
information. If you wish to be removed from our mailing list, please
respond with "remove" in the subject field. We apologize for any
inconvenience caused.

Please consider the environment before printing this e-mail

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ URGENT NEED FUSE Developer - DallasTX

2016-05-12 Thread MADHU-GenuineItLlc

Hi Partner,

Hope you are doing great …

Please send resume to ma...@genuineitllc.com



*TITLE :Fuse Developer*

*Location: Dallas, TX *

*Rate: $45-$50/hr *



JD:-

-  6+ years of integration experience

· Experience with Services Oriented Architecture and RESTful
Architecture, web services development

· Experienced in J2EE, Java Servlets, JMS, EJB, Design Patterns,
Web services and building integration projects  using Redhat Fuse ESB and
Camel

· Solid programming skills and experience troubleshooting Fuse ESB,
API and configuration tools.

· Mandatory skills needed are Redhat Fuse, Camel, Java, J2EE, CXF,
Active MQ and Web services experience



---

*With Warm Regards *

*Madhu Roy*

GenuineIT LLC *Certified Women Owned Business*

Making IT Happen…

Ph: 832 539 3475

Fax: 281-605-5969

*E-Mail* :ma...@genuineitllc.com

*Gmail *: *nandimadhu74 , madhu.genuineitllc*

*YM  *: madhu_recruiter



Looking ahead to work with you for better Business prospects



According to Bill S.1618 Title III passed by the 105th US Congress, this
message is not considered as "Spam" as we have included the contact
information. If you wish to be removed from our mailing list, please
respond with "remove" in the subject field. We apologize for any
inconvenience caused.

Please consider the environment before printing this e-mail

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Extract Correct Web Address Link By Date

2016-05-12 Thread Bill Q

Hi, 

The link in question is below.
http://contests.covers.com/KingOfCovers/Contestant/CompletedPicks/0c459c57-a44f-4aed-9104-a5de00e4c7ea

Once you go into this link - you will see part of the page looks like 
below. 

On the far right you have a hyperlink for each record. Unfortunately, this 
link is not unique. I do not understand "elements", but I am pretty certain 
that this is the issue. 

How can I easily extract the unique hyperlinks associated to each date for 
downloading / scraping purposes ? 

Thank you. 



DATEW-L-T%UNITSRECORD
05/11/2016 3-2-0 60.00% +400 Detail 

05/10/2016 4-1-0 80.00% +1485 Detail 

05/09/2016 2-1-0 66.67% +780 Detail 

05/08/2016 2-1-0 66.67% +600 Detail 

05/07/2016 1-5-0 16.67% -1915 Detail 

05/06/2016 10-5-1 66.67% +2615 Detail 

05/05/2016 1-3-0 25.00% -1150 Detail 

05/04/2016 2-4-0 33.33% -1130 Detail 

05/03/2016 5-2-1 71.43% +1450 Detail 

05/02/2016 3-3-0 50.00% -245 Detail 

05/01/2016 5-2-1 71.43% +1845 Detail 

04/30/2016 3-2-0 60.00% +175 Detail 

04/29/2016 12-6-1 66.67% +3290 Detail 

04/28/2016 2-8-0 20.00% -3730 Detail 

04/27/2016 9-4-0 69.23% +3050 Detail 

04/26/2016 9-6-0 60.00% +2795 Detail 

04/24/2016 11-11-2 50.00% -330 Detail 

04/23/2016 10-10-0 50.00% -460 Detail 

04/22/2016 9-8-0 52.94% +205 Detail 

04/21/2016 6-8-0 42.86% -1415 Detail 

04/20/2016 13-10-1 56.52% +1355 Detail 

04/19/2016 19-9-0 67.86% +4740 Detail 

04/18/2016 7-5-2 58.33% +1050 Detail 

04/17/2016 3-4-0 42.86% -1620 Detail 

04/16/2016 4-5-0 44.44% -895 Detail 

04/15/2016 3-6-0 33.33% -2040 Detail 

04/14/2016 5-2-0 71.43% +1440 Detail 

04/13/2016 6-5-0 54.55% +240 Detail 

04/12/2016 3-5-0 37.50% -1380 Detail 

04/11/2016 4-3-0 57.14% +1010 Detail 


-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page

$$Excel-Macros$$ Client in Birmingham, AL need Salesforce Service Cloud Business Analyst//Need Local F2F Required //GC or Citizens are preferred.

2016-05-12 Thread MADHU-GenuineItLlc

Hi Partner,

Hope you are doing great …

Please send resume to ma...@genuineitllc.com



*Title : Salesforce Service Cloud Business Analyst*

*Duration :4+ Months*

*Location :** Birmingham, AL*





***Need locals with in-person interview available.*

***GC or Citizens are preferred.*



*Job Description:*

We are seeking *Salesforce.com Service Cloud Professionals* with specific
experience in *Business Architecture*, *Functional Solutions* or *Technical
Architecture* related to enterprise Service Cloud implementations.  Some of
the experience and skills we are looking for in each area include:



*Business Architect*:

   - Well rounded expertise in all aspects of contact center operations
   (work distribution, scheduling, forecasting, process improvement, training,
   performance management, and continuous improvement).
   - Ability to create operational process flows, define case reasons,
   routing rules, reporting requirements, support the interface design, UAT,
   change management and user migration.
   - Customer service business process design experience.



*Functional Architect*:

   - Experience working with business process and development teams to
   design, implement and deploy Salesforce.com Service Cloud applications to a
   wide variety of clients at the enterprise level
   - Ability to develop business requirements and functional designs to
   effectively demonstrate solutions that address customer requirements
   - Knowledge of Call Centers, Contact Centers or Delivery Centers,
   including an understanding of key operational metrics and performance
   indicators used to manage a Customer Support environment and knowledge of
   the relationship between a Customer Support environment and other Business
   units



*Technical Architect: *

   - Experience implementing force.com and Service Cloud platforms.
   - Broad technical background and expertise in all aspects of the Service
   Cloud platform including cloud applications, security, and integration to
   technical and non-technical audiences.
   - Experience with end-to-end solution architecture definition and
   implementation including application architecture, integration
   architecture, data, performance and security architecture and expertise in
   how Salesforce integrates with the key technology enablers used within a
   Customer Support environment.



*Basic Qualifications*:

   - Bachelor's Degree
   - *Minimum of 3 years of Salesforce.com Service Cloud implementation
   experience and/or Contact Center/ Customer Service operations experience*
   - Minimum of 3 years of experience developing requirements, process
   and/or technical solutions
   - *Ability to travel up to 80%*



*Preferred Skills Requirements*:

   - Salesforce.com certifications (Admin, Service Cloud Consultant)
   - Experience with Oracle-Siebel, ServiceNow or SAP
   - Customer service business process design experience
   - Ability to facilitate requirements and design sessions with 10-20
   client stakeholders
   - Design through deploy experience.
   - Background with technical architecture and security concepts
   (integration patterns, architecture styles, data security).
   - Understanding of key SFDC architectural concepts (e.g. API and
   governor limits).



---

*With Warm Regards *

*Madhu Roy*

GenuineIT LLC *Certified Women Owned Business*

Making IT Happen…

Ph: 832 539 3475

Fax: 281-605-5969

*E-Mail* :ma...@genuineitllc.com

*Gmail *: *nandimadhu74 , madhu.genuineitllc*

*YM  *: madhu_recruiter



Looking ahead to work with you for better Business prospects



According to Bill S.1618 Title III passed by the 105th US Congress, this
message is not considered as "Spam" as we have included the contact
information. If you wish to be removed from our mailing list, please
respond with "remove" in the subject field. We apologize for any
inconvenience caused.

Please consider the environment before printing this e-mail

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to

$$Excel-Macros$$ MS Excel Training for Microsoft Office Specialist Certification

2016-05-12 Thread letsgolive30






This* MS Excel 2013  *Course 
has been designed for students, clerical workers, book keepers, and 
instructors, to provide them with a basic knowledge of using the various 
features of Excel. By enrolling for the course, the students can practice 
working on Excel for creating budgets, charts, sales invoices, exercise 
logs, and much more.

For more details Please Contact...
SSDN Technologies
M-44 & M-50,Old-DLF,Sec-14, Gurgaon-122001
0124-4018080, 109937
http://www.ssdntech.com/



-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Error in Excel-VB macro

2016-05-12 Thread Mandeep Baluja

Great Paul



On Tuesday, May 10, 2016 at 4:53:10 PM UTC+5:30, Paul Schreiner wrote:
>
> What I mean is:
>
> Protection can be at either the Workbook level, WorkSHEET level, or both. 
> Some of the worksheets are protected.
> It LOOKS like the workbook protection flag is set, but the workbook isn't 
> really protected.
> Otherwise, I couldn't protect the workbook without first knowing the 
> password to UNprotect it.
>
> I experienced the same issue you did with regard to opening the file.
> I protected the WORKBOOK (with password), then unprotected it (with 
> password)
> and the problem went away.
>
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you 
> can,In all the places you can,At all the times you can,To all the people 
> you can,As long as ever you can.” - John Wesley*
> -
>
>
> On Tuesday, May 10, 2016 7:10 AM, ITP Abdulgani Shaikh <
> itpabd...@gmail.com > wrote:
>
>
>
> But, yes workbook is password protected, but earlier it doesn't gives 
> error, but now when I am opening workbook it gives error for debug.
>
> On Mon, May 9, 2016 at 7:31 PM, Paul Schreiner  > wrote:
>
> The problem seems to be that some protection flag for the workbook is set.
> I'm using Excel 2010, and for some reason, on the Review tab, the Protect 
> Workbook icon doesn't SHOW that it is protected. 
> But I protected the workbook (with password) and then unprotected it.
>
> After that, the macros work correctly.
>
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you 
> can,In all the places you can,At all the times you can,To all the people 
> you can,As long as ever you can.” - John Wesley*
> -
>
>
> On Monday, May 9, 2016 9:09 AM, ITP Abdulgani Shaikh  > wrote:
>
>
>
> I want to make sure that macro is enable in excel sheet, but it gives 
> error.
>
> Please guide.
>
>
>
> -- 
> Shaikh AbdulGani A R
> ITP, STP, TRP, STRP
> -- 
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
> https://www.facebook.com/discussexcel
>  
> FORUM RULES
>  
> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security 
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>  
> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
> members are not responsible for any loss.
> --- 
> You received this message because you are subscribed to the Google Groups 
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to excel-macros...@googlegroups.com .
> To post to this group, send email to excel-...@googlegroups.com 
> .
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
>
> -- 
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
> https://www.facebook.com/discussexcel
>  
> FORUM RULES
>  
> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security 
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>  
> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
> members are not responsible for any loss.
> --- 
> You received this message because you are subscribed to the Google Groups 
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to excel-macros...@googlegroups.com .
> To post to this group, send email to excel-...@googlegroups.com 
> .
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
>
>
>
> -- 
> Shaikh AbdulGani A R
> ITP, STP, TRP, STRP
> -- 
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
> https://www.facebook.com/discussexcel
>  
> FORUM RULES
>  
> 1) Use

$$Excel-Macros$$ Re: Suimifs vba code processitng too slow

2016-05-12 Thread Mandeep Baluja

Try this code 

Sub Macro8()

Sheets("Pivot 101 value (NA)").Range("R7").FormulaR1C1 = 
"=SUMIFS('PrevNON NA'!C[-1],'PrevNON NA'!C[-13],[@[Po Number]],'PrevNON 
NA'!C[-12],[@[Po Line]])"
lr = Sheets("Pivot 101 value (NON NA)").Cells(Rows.Count, 
18).End(xlUp).Row
Range("R7:R" & lr).FillDown

Sheets("Pivot 101 value (NA)").Select
 Range("R7").Select
ActiveCell.FormulaR1C1 = "=SUMIFS('PrevNA'!C[-1],'PrevNA'!C[-13],[@[Po 
Number]],'PrevNA'!C[-12],[@[Po Line]])"
lr = Sheets("Pivot 101 value (NA)").Cells(Rows.Count, 18).End(xlUp).Row
Range("R7:R" & lr).FillDown

End Sub



' Regards :- Mandeep baluja
'https://www.facebook.com/groups/825221420889809/
'https://www.linkedin.com/in/mandeep-baluja-b777bb88
Add a share  if it helps :)
'**

















On Wednesday, May 11, 2016 at 11:28:19 AM UTC+5:30, raj.he...@gmail.com 
wrote:
>
> Hello Everyone,
>
> Just to give quick introduction, Myself Raj  I am  financial Analyst into 
> reporting domain but I try experimenting few codes in excel vba, I have 
> come across this group and found to be really helpful.
>
> Thanks  to Ayush and also one and all,for initiating such helpful platform 
> to each one of us which provides opportunity to learn and can enhance  
> potentials.
>
> I have tried bit coding part I was successful in running but it seems that 
> sumifs formula is taking long time to populate the results .
>
> Sheets("Pivot 101 value (NON NA)").Select
>Range("R7").Select
> ActiveCell.FormulaR1C1 = _
> "=SUMIFS('PrevNON NA'!C[-1],'PrevNON NA'!C[-13],[@[Po 
> Number]],'PrevNON NA'!C[-12],[@[Po Line]])"
>   Selection.AutoFill Destination:=Range("r7:r" & 
> ActiveSheet.UsedRange.Rows.Count)
>
>
> can some one please help me to fix the slow lag issue
>
> in sheets Pivot 101 value (NA) & Pivot 101 value (NON NA)
>
> I am trying to populate R column using sumifs formula the  steps which I 
> followed to get this result is
>
> 1) In sheet "Pivot 101 value (NON NA)")   column r com I am trying to pull 
> values from sheet PrevNON NA from Column Q using PO number  and PO line 
> items combinations in sumifs
> 2) similarly In Sheet Pivot 101 value (NON NA) column r com I am trying to 
> pull values from sheet PrevNA from Column Q using PO number  and PO line 
> items combinations in sumifs
>
>
> Rest of the macro is executing well but only this  sumifs is causing 10-20 
> min time to populate this.
>
> please find the attached macro sheet and kindly help me in fixing this.
>
> Thanks one and all have  a great day.
>
>
>
>
>
> Tha
> Raj
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: Excel Training Material (PPT)

$$Excel-Macros$$ need help with Evaluate function

$$Excel-Macros$$ Urgent need AEM Architect - Hartford, CT

$$Excel-Macros$$ URGENT NEED FUSE Developer - DallasTX

$$Excel-Macros$$ Extract Correct Web Address Link By Date

$$Excel-Macros$$ Client in Birmingham, AL need Salesforce Service Cloud Business Analyst//Need Local F2F Required //GC or Citizens are preferred.

$$Excel-Macros$$ MS Excel Training for Microsoft Office Specialist Certification

Re: $$Excel-Macros$$ Error in Excel-VB macro

$$Excel-Macros$$ Re: Suimifs vba code processitng too slow

9 matches

Site Navigation

Mail list logo

Footer information