$$Excel-Macros$$ Re: Introduce Yourself !!

[Rakesh Bjain]

Hi all,

This is Rakesh here, I am chartered accountant by profession, next target 
for me is to train myself in Macro and VBA.

Request experts to send me easy way of understanding and learning Macro and 
VBA.

Regards,
CA Rakesh B Jain

On Saturday, 9 June 2012 00:51:59 UTC+5:30, Ayush Jain wrote:
>
> Hey all new and current posters,
>  
> Welcome to excel group,one of the largest online community of excel Fans!
>  
> I hope you enjoy your time here & find this forum to be a friendly and 
> knowledgeable community. Please feel free to post a small introduction, a 
> friendly hello or tell us a bit about yourself. Why not tell us where are 
> you from, what you do, what your interests are, how old you are, which is 
> your favourite excel site or blog is or anything else that comes to mind!
>
> Thanks for your time
> Ayush Jain
> Group Manager
> Microsoft MVP
>

-- 
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$$ VBA Macro for PPT Chart objects content edit (inside)

[Satheesh Arumugam Naidu]

Hi team,

is there any piece of code for opening chart object and edit the content in
PPT?

-- 
Thanks & regards
Satheesh

-- 
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: Help required on making pivot caches / tables

[abhishek bhalla]

Hi All,

I am trying to make pivot table using VBA.but I am getting runtime error 5 or 
so. Can someone suggest me a code to make pivot cache and then table.

Thanks
Abhishek Bhalla

From: amar takaleamartak...@gmail.com
Sent:Thu, 25 Feb 2016 10:20:12 +0530
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ If formula Required
Dear Paul Sir
>
>Please accept my apologies (G10  G11 Cell). I had made an error on my 
>part in accidentally.And Overall formula is perfect as per mind.And this is 
>sumif formula  put in subject If formula also apologies for that.
>Thanks again.
>
>Regards
>Amar
>
>
>On Wed, Feb 24, 2016 at 7:29 PM, Paul Schreiner schreiner_p...@att.net 
>wrote:
>You keep mentioning an IF formula, but I dont see one.Im 
>not sure what test youre expecting for an if 
>formula.It looks like youre trying to simply add the values in the two 
>columns (C and D)for each of the values in column B.
>This can be done with the Sumif() function.
>See attached.
>although, you have values in rows 10 and 11 for product AAA.Your 
>output seems to expect a value of 40.But I only see one previous entry of 
>20.00.
>All the other calculations match your expectation, so Im not sure where 
>the error lies.
> 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 Wednesday, February 24, 2016 4:46 AM, amar takale 
> amartak...@gmail.com wrote:
>  
>
> Dear Paul Sir thanks very much for this, but if there are another (column 
> criteria) add in formula then how to modified IF formula?.Pls check sheet for 
> sampleRegradsAmarOn Tue, Feb 23, 2016 at 10:41 PM, Paul Schreiner 
> schreiner_p...@att.net wrote:In cell G4, enter 
> formula:=SUMIF(C$4:C4,F4,D$4:D4)and copy the formula down through column 
> G.The $ means that the beginning row of the range is 
> anchored which means that the first row of each range is 4,but 
> the ending row of each range will increment to match the current 
> row.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, February 
> 23, 2016 8:30 AM, amar takale amartak...@gmail.com wrote:   --  
> 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) Dont post a question in the thread 
> of another member. 3) Dont 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  : Dont 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. --  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) Dont post a question in the thread 
> of another member. 3) Dont 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  : Dont 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 

Re: $$Excel-Macros$$ If formula Required

[amar takale]

Dear Paul Sir

Please accept my apologies (G10 & G11 Cell). I had made an error on my part
in accidentally.And Overall formula is perfect as per mind.And this is
sumif formula & put in subject If formula also apologies for that.
Thanks again.

Regards
Amar


On Wed, Feb 24, 2016 at 7:29 PM, Paul Schreiner 
wrote:

> You keep mentioning an "IF" formula, but I don't see one.
> I'm not sure what "test" you're expecting for an "if" formula.
> It looks like you're trying to simply add the values in the two columns (C
> and D)
> for each of the values in column B.
>
> This can be done with the Sumif() function.
>
> See attached.
>
> although, you have values in rows 10 and 11 for product "AAA".
> Your output seems to expect a value of 40.
> But I only see one previous entry of 20.00.
>
> All the other calculations match your expectation, so I'm not sure where
> the error lies.
>
>
> *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 Wednesday, February 24, 2016 4:46 AM, amar takale 
> wrote:
>
>
>
> Dear Paul Sir thanks very much for this, but if there are another (column
> criteria) add in formula then how to modified IF formula?.
> Pls check sheet for sample
> Regrads
> Amar
>
> On Tue, Feb 23, 2016 at 10:41 PM, Paul Schreiner 
> wrote:
>
> In cell G4, enter formula:
> =SUMIF(C$4:C4,F4,D$4:D4)
> and copy the formula down through column G.
>
> The "$" means that the beginning row of the range is "anchored"
> which means that the first row of each range is 4,
> but the ending row of each range will increment to match the "current" row.
> *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, February 23, 2016 8:30 AM, amar takale 
> wrote:
>
>
>
>
> --
> 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.
>
>
> --
> 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.
>
>
> --
> 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 

$$Excel-Macros$$ PasteSpecial method of Range class failed error

[Kat]

Hi all,

I'm getting error for my code. Can anyone help me analyze where is the 
error?

Thanks in advance.


Sub getnew()
Dim Sheet1 As Worksheet
Dim Sheet3 As Worksheet
Dim lastrow As Long
Dim i As Long
Dim erow As Long
Application.ScreenUpdating = False
Application.DisplayStatusBar = False
ActiveSheet.DisplayPageBreaks = False
Set Sheet1 = ThisWorkbook.Sheets("Sheet1")
Set Sheet3 = ThisWorkbook.Sheets("Sheet2")
lastrow = Sheet1.Range("C" & Rows.Count).End(xlUp).Row
Sheet3.Select
Rows("1:1").Select
Selection.AutoFilter
ActiveSheet.Range("A:V").AutoFilter Field:=2, Criteria1:="NEW"
Columns("A:V").Select
Selection.Copy
ThisWorkbook.Activate
Sheets("Sheet1").Select
Range("C2" & lastrow).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
   :=False, Transpose:=False
Application.CutCopyMode = False
Sheet1.Select
Range("A1:X750001").Select
Selection.Sort Key1:=Range("C2"), Order1:=xlAscending, Key2:=Range("G2") 
_
, Order2:=xlAscending, Header:=xlGuess, OrderCustom:=1, MatchCase:= 
_
False, Orientation:=xlTopToBottom
Application.ScreenUpdating = True
Application.DisplayStatusBar = True
ActiveSheet.DisplayPageBreaks = True
End Sub


-- 
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$$ Search and Data Formating help....

[Paul Schreiner]

I'm sorry, I STILL do not understand.
How does the value in column "J" determine the value to display in column "O"?
as for "empty" rows.How can a row be empty if it has a value or something in 
it?If it has something in it, it is not empty.If it is empty, it doesn't have 
anything in it!?
I suspect I'm missing something in your explanation.
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 Wednesday, February 24, 2016 11:19 AM, Maju  wrote:
 
 

 I am using 2010 excel. 
I have attached a file. The value in column J will determine what will go into 
o. So I don't have the value for column o stored any where. 
what I mean by delete row. Is to clean up the rows after the last row with 
data. Sometimes some rows might be empty but have in value or something that 
will make it thing that there is value. 
thanks!


It would be helpful to provide a sample file.But:What version of Excel are you 
using?
Where do you get the values for column "O"? Your example has entering "utility" 
when something other than "fuel" is in column J.Are there other values?
And, what so you mean by "Delete any extra line after the last row with 
data."?Excel 2010 allows 1,048,576 rows.You cannot "delete" any of these 
rows.You can delete the CONTENTS, but the rows are still there.However, you can 
HIDE any or all of these rows.
Can you please elaborate?
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, February 23, 2016 8:48 AM, Maju  wrote:
 
 

 Hello All,
Please I need help with the below macro.I have a worksheet with lots of data.   
   - I want to go through each cell in column J. To find data and put the 
answer in columnO. 
   - Then left and Right trim spaces
   - Delete any extra line after the last row with data.
   - Save file as expense with a date attached to it.

The below should be the final result.   Column J    
  ColumnO Fuel      
     Fuel Gas       
     UtilityElectric    
     UtilityFuel    
   Fuel 
Your help will be greatly appreciated
thanks!!-- 
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 

Re: $$Excel-Macros$$ Search and Data Formating help....

[Maju]

I am using 2010 excel. 

I have attached a file. The value in column J will determine what will go 
into o. So I don't have the value for column o stored any where. 

what I mean by delete row. Is to clean up the rows after the last row with 
data. Sometimes some rows might be empty but have in value or something 
that will make it thing that there is value. 

thanks!

It would be helpful to provide a sample file.
> But:
> What version of Excel are you using?
>
> Where do you get the values for column "O"? 
> Your example has entering "utility" when something other than "fuel" is in 
> column J.
> Are there other values?
>
> And, what so you mean by "Delete any extra line after the last row with 
> data."?
> Excel 2010 allows 1,048,576 rows.
> You cannot "delete" any of these rows.
> You can delete the CONTENTS, but the rows are still there.
> However, you can HIDE any or all of these rows.
>
> Can you please elaborate?
>
> *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, February 23, 2016 8:48 AM, Maju  > wrote:
>
>
>
> Hello All,
>
> Please I need help with the below macro.
> I have a worksheet with lots of data.
>
>1. I want to go through each cell in column J. 
>To find data and put the answer in column O. 
>2. Then left and Right trim spaces
>3. Delete any extra line after the last row with data.
>4. Save file as expense with a date attached to it.
>
>
> The below should be the final result. 
>  
>  
> Column J Column O 
> Fuel Fuel 
>
> Gas  
> Utility
> Electric
> Utility
> Fuel Fuel 
>
>
> Your help will be greatly appreciated
>
> thanks!!
> -- 
> 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+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.


Test1.xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ Client in San Francisco, CA need Ruby Developer---Must have LinkedIn

[MADHU-GenuineItLlc]

Hi Partner,

Hope you are doing great …

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



*Title : Ruby Developer--** Must have LinkedIn*

*Duration: 5 months *

*Location: San Francisco, CA*



Candidate

*Qualifications*

ü  3+  years of experience with developing full stack web applications in *Ruby
on Rails*

ü  Core Ruby programmer experienced with building REST and SOAP based web
services.

ü  Experienced with deployment of ruby applications using *Nginx ,
Passenger and Sinatra.*

ü  *2+ years of Experience with Amazon working in AWS webservices*

ü  Experienced in Core Java experience/ Backend Java Development, RESTful
Web Services, Weblogic, JBoss,WebLogic, Tomcat.

ü  Experienced in development and deployment of J2EE Application archives
(jar, war) on Jboss, Tomcat

ü  3+ years of Experience in developing REST API's

ü  *Knowledge of Zookeeper is helpful*

ü  Strong understanding of object-oriented programming and Service-Oriented
Design

ü  Experienced with building third-party APIs and Web Services

ü  Working knowledge of the general web application landscape,
architectures, trends, and emerging technologies

ü  Experience with Agile development, preferably Scrum

ü  Experience with Perforce deployment and code management

ü  Experience with Jenkins for Continuous Integration/Continuous Deployment



---

*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.

Re: $$Excel-Macros$$ If formula Required

[Paul Schreiner]

You keep mentioning an "IF" formula, but I don't see one.I'm not sure what 
"test" you're expecting for an "if" formula.It looks like you're trying to 
simply add the values in the two columns (C and D)for each of the values in 
column B.
This can be done with the Sumif() function.
See attached.
although, you have values in rows 10 and 11 for product "AAA".Your output seems 
to expect a value of 40.But I only see one previous entry of 20.00.
All the other calculations match your expectation, so I'm not sure where the 
error lies.
 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 Wednesday, February 24, 2016 4:46 AM, amar takale  
wrote:
 
 

 Dear Paul Sir thanks very much for this, but if there are another (column 
criteria) add in formula then how to modified IF formula?.
Pls check sheet for sample
Regrads
Amar

On Tue, Feb 23, 2016 at 10:41 PM, Paul Schreiner  wrote:

In cell G4, enter formula:=SUMIF(C$4:C4,F4,D$4:D4)and copy the formula down 
through column G.
The "$" means that the beginning row of the range is "anchored" which means 
that the first row of each range is 4,but the ending row of each range will 
increment to match the "current" 
row.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, February 23, 2016 8:30 AM, amar takale  
wrote:
 
 

 
-- 
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.


 
   -- 
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.


-- 
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 

Re: $$Excel-Macros$$ Re: overflow error issue

['ravinder negi' via MS EXCEL AND VBA MACROS]

Hi
Integer has as limit 32767 more than it it will show overflow error so you have 
to use long variable. 
ThanksRavinder Negi 

On Wednesday, February 24, 2016 1:11 PM, Kat  wrote:
 

 Hi Mandeep, 

I don't know how to use VLookUp function for my situation. I was wondering 
whether would you mind showing me how to use VLookUp function according to my 
code?


Cheers

On Monday, 22 February 2016 20:57:58 UTC+8, Mandeep baluja wrote:


Will you please let me know why you're not using a simple vlookup 
function,index match for the same it would be more faster than this to search 
using find method one by one, while defining the value to integer it doesn't 
matter how many rows of data you have 1 to 5 lac it will work for -32,768 
through 32,767 (signed) That's i used long  to run the macro for all rows.  
Another thing you can use a dictionary object or use array to intesify the 
speed of macro. Don't miss Application.screenupdating = false in every code to 
avoid flickering.


Regards, Mandeep baluja   
-- 
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.


  

-- 
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$$ If formula Required

[amar takale]

Dear Paul Sir thanks very much for this, but if there are another (column
criteria) add in formula then how to modified IF formula?.
Pls check sheet for sample
Regrads
Amar

On Tue, Feb 23, 2016 at 10:41 PM, Paul Schreiner 
wrote:

> In cell G4, enter formula:
> =SUMIF(C$4:C4,F4,D$4:D4)
> and copy the formula down through column G.
>
> The "$" means that the beginning row of the range is "anchored"
> which means that the first row of each range is 4,
> but the ending row of each range will increment to match the "current" row.
> *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, February 23, 2016 8:30 AM, amar takale 
> wrote:
>
>
>
>
> --
> 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.
>
>
> --
> 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.
>

-- 
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.


Sample.xls
Description: MS-Excel spreadsheet