date:20131008

$$Excel-Macros$$ Re: Read a Text file with delimiter as comma and import the infor into excel sheet

2013-10-08 Thread rani

hi

On Monday, November 5, 2007 11:52:56 PM UTC+5:30, SK wrote:
>
> Hello Everybody,
>
> I am new to Excel VBA. I am trying to read a text file in which
> columns are separated by commas, for eg:
>
> 1,2,3
> 2,3,4
> 3,4,5
> 4,5,6
>
> I canwrite this to an Excel worksheet. So, final Excel sheet has 3
> columns and 4 rows(number of rows depends on on how many entries we
> have in a text file). So the worksheet will look like:
>
> 1 | 2 | 3
> 2 | 3 | 4
> 3 | 4 | 5
> 4 | 5 | 6
>
> If I specify the range of the cells for example B9, my first column
> starts from B9, second from C9 and thrid from D9. I want to do
> something different. I want to have different range set for diffferent
> column.
> Can I specify that the first column should populate in range
> B9:Bx((where x is the number of rows in the text file) and second
> coulmn populate in range G9:Gx(where x is the number of rows in the
> text file) and third column populates in range I9:Ix((where x is the
> number of rows in the text file).
>
> Thanks for your help in advance.
> ~SK
>
>

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Re: Email Trigger ?

2013-10-08 Thread Basole

Bill, enable reference, as indicated Ashish Watve and keep the quotes ("") 
in their name and email in the email password.

Basole.


Em domingo, 6 de outubro de 2013 17h34min31s UTC-3, Bill Q escreveu:
>
> Hi, 
>
> I am using Excel 2007 and have Gmail as my primary email account.
>
> I have a dynamic spreadsheet that monitors different stock prices that is 
> refreshed ever "x" amount of minutes.
>
> I would like to have a small macro created so that when a certain cell is 
> either <= to a certain price, will automatically send me an email to my 
> Gmail account with the message to be defined later.
>
> Anyone ? 
>
> Thanks in advance ?  
>

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Re: Email Trigger ?

2013-10-08 Thread Basole

'Ashish Kumar, thank you very much. Pls. add this code:

Private Sub Worksheet_Calculate()
If ThisWorkbook.ActiveSheet.Range("A1") < 10 Then
Call SendEmail
Else
End If
End Sub

'and in cell A1, enter the formula: =RANDBETWEEN(1,15)
'and press F9 to test.

'I share an example to analyze. 

'Basole.




Em domingo, 6 de outubro de 2013 17h34min31s UTC-3, Bill Q escreveu:
>
> Hi, 
>
> I am using Excel 2007 and have Gmail as my primary email account.
>
> I have a dynamic spreadsheet that monitors different stock prices that is 
> refreshed ever "x" amount of minutes.
>
> I would like to have a small macro created so that when a certain cell is 
> either <= to a certain price, will automatically send me an email to my 
> Gmail account with the message to be defined later.
>
> Anyone ? 
>
> Thanks in advance ?  
>

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Re: Email Trigger ?

2013-10-08 Thread Basole

Aashish, try changing the port number in this line:Flds.Item(schema & 
"smtpserverport") = 465
see this site indicated by Ashish: http://www.rondebruin.nl/win/s1/cdo.htm




Em domingo, 6 de outubro de 2013 17h34min31s UTC-3, Bill Q escreveu:
>
> Hi, 
>
> I am using Excel 2007 and have Gmail as my primary email account.
>
> I have a dynamic spreadsheet that monitors different stock prices that is 
> refreshed ever "x" amount of minutes.
>
> I would like to have a small macro created so that when a certain cell is 
> either <= to a certain price, will automatically send me an email to my 
> Gmail account with the message to be defined later.
>
> Anyone ? 
>
> Thanks in advance ?  
>

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Re: Interview Questions with Answers (Excel+VBA+Access+SQL Server)

2013-10-08 Thread Manoj Kumar Singh



On Thursday, May 10, 2012 4:19:25 AM UTC-7, NOORAIN ANSARI wrote:
>
> Dear Group,
>
> Please find attached Interview questions and answers for MS Excel+VBA+MS 
> Access+SQL Server.
>
> If any one have this type of question and answers, Kindly share with group.
>
>
> Thanks ! it really Help to me.

 

>
>
> -- 
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

RE: $$Excel-Macros$$ Re: Pie chart

2013-10-08 Thread joseph camill

Any luck with this one
On Oct 6, 2013 3:16 PM, "joseph camill"  wrote:

> Hi Ravi,
>
> Pie chart calculates the percentage by its inbuilt feature and is the
> whole pie is equal to 100%.
>
> I just want the first slice to be exactly in the centre to the right as I
> had ahown in my original example.
>
> Let me know if you need any further clarification.
>
> Thanks,
> Joseph
> On Oct 5, 2013 5:11 PM, "Ravinder"  wrote:
>
>> I think u r saying about % value but how can that be same of value if
>> value is more than 125 then percentage will be 125%
>>
>> ** **
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *joseph camill
>> *Sent:* Saturday, October 05, 2013 4:48 PM
>> *To:* excel-macros@googlegroups.com
>> *Cc:* Soum
>> *Subject:* Re: $$Excel-Macros$$ Re: Pie chart
>>
>> ** **
>>
>> Hi Ravi,
>>
>> ** **
>>
>> thanks for the code, but if I change the values they do not appear right.
>> 
>>
>> ** **
>>
>> Thanks,
>>
>> Joseph
>>
>> ** **
>>
>> On Sat, Oct 5, 2013 at 4:20 PM, Ravinder 
>> wrote:
>>
>> pfa
>>
>>  
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *joseph camill
>> *Sent:* Saturday, October 05, 2013 12:13 AM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ Re: Pie chart
>>
>>  
>>
>> Hi,
>>
>>  
>>
>> Attached is the file with two examples.
>>
>>  
>>
>> I am looking for a similar output to be done using vba.
>>
>>  
>>
>> Let me know if you need any further clarification on this.
>>
>>  
>>
>> Thanks,
>>
>> Joseph
>>
>>  
>>
>> On Wed, Oct 2, 2013 at 12:42 PM, ashish koul 
>> wrote:
>>
>> please share the chart
>>
>>  
>>
>> On Wed, Oct 2, 2013 at 12:39 PM, joseph camill 
>> wrote:
>>
>> Can anyone help me with a code
>>
>> On Sep 24, 2013 9:11 PM, "joseph camill"  wrote:
>> 
>>
>> Thanks for your response. I know to do it manually but my charts gets
>> updated very often. So I am looking for an automation.
>>
>> On Sep 24, 2013 6:54 PM, "Johnnyboy5"  wrote:
>> 
>>
>> Goto the pie chart - double click on the pie - should be able to bring up
>> a four tab choice box - select "option" the just adjust the angle in
>> degrees of the first slice
>>
>>  
>>
>>  
>>
>>  
>>
>> regards
>>
>>  
>>
>> John
>>
>> On Thursday, 19 September 2013 18:46:52 UTC+1, Joseph wrote:
>>
>> Hi,
>>
>> I have a two slice pie chart and the first slice should face to the right
>> centre horizontally.
>>
>> Can you provide a macro for this.
>>
>> Thanks for your help in advance.
>>
>> Regards,
>> Joseph
>>
>> --
>> 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 http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>> --
>> 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 VB

$$Excel-Macros$$ Re: Need macro export data into workbooks with grand Totals and specified format

2013-10-08 Thread Renukachari Kasee

Hi ravinder negi,

Thanks for given this macro but it was not working in my end

i was entered multiple times range criteria but i was not work it shows
error debug message

please help me out.

thanking you.

*(¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`•.•´¨)¸.•´ Smiling!!
`•.¸.•´
Thanks & Regards´¨)
  ¸ •´ ¸.•*´¨)   ¸.•*¨)
 (¸.•´  (¸.•*  ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪*
* *
*P Let us do our best to save nature, save water, plant trees, protect
greenery, keep our surroundings clean, reduce usage of plastics, and use
renewable energy sources.*


On 7 October 2013 19:46, Renukachari Kasee  wrote:

> Hi ravinder negi,
> Thanks for giving this macro i am expecting exactly Like this only,
>
> but if change the range it would not work please check this once actually
> i was given only
> sample copy only but data range would be nearly 20k to 30k.
>
> what i want is exactly you are prepared format only but range would be
> different. this range
> would not same in every day.
>
> Please help me out in this regard...
>
> Thanks
>
>
> *(¨`•.•´¨) Always
> `•.¸(¨`•.•´¨) Keep
> (¨`•.•´¨)¸.•´ Smiling!!
> `•.¸.•´
> Thanks & Regards´¨)
>   ¸ •´ ¸.•*´¨)   ¸.•*¨)
>  (¸.•´  (¸.•*  ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪*
> * *
> *P Let us do our best to save nature, save water, plant trees, protect
> greenery, keep our surroundings clean, reduce usage of plastics, and use
> renewable energy sources.*
>
>
> On 6 October 2013 18:50, Renukachari Kasee  wrote:
>
>> Dear Group,
>>
>> Please Give me the required format macro for data exporter.
>>
>> please find the attachments
>>
>> required format is Export data with Specified range and grand totals as
>> well
>>
>> Thanks
>>
>> *(¨`•.•´¨) Always
>> `•.¸(¨`•.•´¨) Keep
>> (¨`•.•´¨)¸.•´ Smiling!!
>> `•.¸.•´
>> Thanks & Regards´¨)
>>   ¸ •´ ¸.•*´¨)   ¸.•*¨)
>>  (¸.•´  (¸.•*  ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪*
>> * *
>> *P Let us do our best to save nature, save water, plant trees, protect
>> greenery, keep our surroundings clean, reduce usage of plastics, and use
>> renewable energy sources.*
>>
>
>

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Re: Multi sheets Grouping Problem

2013-10-08 Thread Renukachari Kasee

Hi De Premor,

Thanks alot for your help.

thank you so much.



*(¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`•.•´¨)¸.•´ Smiling!!
`•.¸.•´
Thanks & Regards´¨)
  ¸ •´ ¸.•*´¨)   ¸.•*¨)
 (¸.•´  (¸.•*  ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪*
* *
*P Let us do our best to save nature, save water, plant trees, protect
greenery, keep our surroundings clean, reduce usage of plastics, and use
renewable energy sources.*


On 6 October 2013 18:11, Renukachari Kasee  wrote:

> Dear Group
>
> Please help me this problem for multi sheets select with in the single
> click
> As per the requirement
>
> Thank
>
>  *(¨`•.•´¨) Always
> `•.¸(¨`•.•´¨) Keep
> (¨`•.•´¨)¸.•´ Smiling!!
> `•.¸.•´
> Thanks & Regards´¨)
>   ¸ •´ ¸.•*´¨)   ¸.•*¨)
>  (¸.•´  (¸.•*  ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪*
> * *
> *P Let us do our best to save nature, save water, plant trees, protect
> greenery, keep our surroundings clean, reduce usage of plastics, and use
> renewable energy sources.*
>

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Getting Application-defined or object-defined error, when pasting the data from webpage to excel

2013-10-08 Thread Menaka Balakrishnamoorthy

Getting the application - defined or object - defined error while execution.
 
Sub GetTable()

dataarr = Range("A1:A3") 'Change according to your criteria
For i = 1 To UBound(dataarr, 1)
If counter = 0 Then
store_value = dataarr(i, 1)
counter = 1
MsgBox store_value
Else
store_value = store_value & Chr(13) & dataarr(i, 1)
End If
Next

MsgBox store_value
 
 Dim ieApp As InternetExplorer
'Dim ieDoc As Object
Dim ie As Object
Dim ieDoc As Object
Dim strReturnBody As String


Dim MyObject As Object' Create object variable.
Set MyObject = Sheets(1)

Set ie = CreateObject("InternetExplorer.application")
ie.Visible = True
ie.navigate "
http://sbm/BizSolo/OrderProcessStatusQuery/EnterQuery.jsp?dummy=false"
  
' website where I'm pasting the data's to be queried
Do
Loop Until ie.ReadyState = READYSTATE_COMPLETE
Application.Wait DateAdd("s", 3, Now)
While ie.Busy
DoEvents
Wend
ie.Document.getElementById("SB_Name").Click
ie.Document.getElementById("SB_Name").Click
Application.Wait (Now + TimeValue("0:00:10"))
ie.Document.getElementById("orderNumber").Value = store_value
Application.Wait (Now + TimeValue("0:00:1"))
ie.Document.getElementById("SB_Name").Click
Application.Wait (Now + TimeValue("0:00:20"))

With ActiveSheet.QueryTables.Add(Connection:= _
"URL;http:///DisplayQueryResult.jsp?dummy=false"; _
, 
Destination:=Range("B1"))   
  ' webpage where I'm getting the result of the data's queried
.Name = "DisplayQueryResult.jsp?dummy=false"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.WebSelectionType = xlSpecifiedTables
.WebFormatting = xlWebFormattingNone
.WebTables = """table1"",2,4"
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.WebDisableRedirections = False
.Refresh BackgroundQuery:=False
End With

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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Re: Email Trigger ?

2013-10-08 Thread ashish koul

Hi Bill

try this link http://www.rondebruin.nl/win/s1/cdo.htm

Regards
Ashish


On Tue, Oct 8, 2013 at 6:11 PM, Ashish Kumar wrote:

> Hi Basole,
>
> This coding is working fine Great Work...
>
> But, Can you please do some changes in it, whenever anyone was do changes
> in sheet in a Specific Cell, then the mail is automatically send an email
> with the specific cell details.
>
> Great Work..!!! :)
>
> Thanks,
> Ashish
>
>
> On Monday, October 7, 2013 8:35:24 PM UTC+5:30, Basole wrote:
>>
>>
>>
>> 'hi, below option of sending email ( gmail ) without Outlook with SMTP
>> server
>>
>> Sub SendEmail()
>> ' Enable Reference> Object> Microsoft CDO for Windows 2000 Library
>> Dim iMsg, iConf, Flds, nTo, nFr, rng, psw
>>
>> nTo = "your email address here"
>> nFr = nTo
>> rng = Range("a1").Value
>> psw = "your email password here"
>> Set iMsg = CreateObject("CDO.Message")
>> Set iConf = CreateObject("CDO.**Configuration")
>> Set Flds = iConf.Fields
>> ' send one copy with Google SMTP server (with autentication)
>> schema = 
>> "http://schemas.microsoft.com/**cdo/configuration/
>> "
>> Flds.Item(schema & "sendusing") = 2
>> Flds.Item(schema & "smtpserver") = "smtp.gmail.com"
>> Flds.Item(schema & "smtpserverport") = 465
>> Flds.Item(schema & "smtpauthenticate") = 1
>> Flds.Item(schema & "sendusername") = nTo
>> Flds.Item(schema & "sendpassword") = psw
>> Flds.Item(schema & "smtpusessl") = 1
>> Flds.Update
>>
>> With iMsg
>> .To = nTo
>> .From = nFr
>> .Subject = "Important message"
>> .ReplyTo = nFr
>> Set .Configuration = iConf
>> .TextBody = "the cell A1 changed to: " & rng
>> SendEmailGmail = .Send
>> End With
>> MsgBox " Email sent to " & nTo & " successfully ! "
>> Set iMsg = Nothing
>> Set iConf = Nothing
>> Set Flds = Nothing
>> End Sub
>>
>> Private Sub Worksheet_Change(ByVal Target As Range)
>> If ThisWorkbook.ActiveSheet.**Range("A1") < 10 Then
>> Call SendEmail
>> Else
>> End If
>> End Sub
>>
>> 'Basole.
>>
>>
>>
>>
>>
>>
>>
>> Em domingo, 6 de outubro de 2013 17h34min31s UTC-3, Bill Q escreveu:
>>>
>>> Hi,
>>>
>>> I am using Excel 2007 and have Gmail as my primary email account.
>>>
>>> I have a dynamic spreadsheet that monitors different stock prices that
>>> is refreshed ever "x" amount of minutes.
>>>
>>> I would like to have a small macro created so that when a certain cell
>>> is either <= to a certain price, will automatically send me an email to my
>>> Gmail account with the message to be defined later.
>>>
>>> Anyone ?
>>>
>>> Thanks in advance ?
>>>
>>  --
> 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 http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>



-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*My Excel Blog *
Like Us on 
Facebook
Join Us on Facebook 


P Before printing, think about the environment.

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

$$Excel-Macros$$ Re: Email Trigger ?

2013-10-08 Thread Ashish Kumar

Hi Basole,

This coding is working fine Great Work...

But, Can you please do some changes in it, whenever anyone was do changes 
in sheet in a Specific Cell, then the mail is automatically send an email 
with the specific cell details.

Great Work..!!! :)

Thanks,
Ashish


On Monday, October 7, 2013 8:35:24 PM UTC+5:30, Basole wrote:
>
>
>
> 'hi, below option of sending email ( gmail ) without Outlook with SMTP 
> server
>
> Sub SendEmail()
> ' Enable Reference> Object> Microsoft CDO for Windows 2000 Library
> Dim iMsg, iConf, Flds, nTo, nFr, rng, psw
>
> nTo = "your email address here"
> nFr = nTo
> rng = Range("a1").Value
> psw = "your email password here"
> Set iMsg = CreateObject("CDO.Message")
> Set iConf = CreateObject("CDO.Configuration")
> Set Flds = iConf.Fields
> ' send one copy with Google SMTP server (with autentication)
> schema = "http://schemas.microsoft.com/cdo/configuration/";
> Flds.Item(schema & "sendusing") = 2
> Flds.Item(schema & "smtpserver") = "smtp.gmail.com"
> Flds.Item(schema & "smtpserverport") = 465
> Flds.Item(schema & "smtpauthenticate") = 1
> Flds.Item(schema & "sendusername") = nTo
> Flds.Item(schema & "sendpassword") = psw
> Flds.Item(schema & "smtpusessl") = 1
> Flds.Update
>
> With iMsg
> .To = nTo
> .From = nFr
> .Subject = "Important message"
> .ReplyTo = nFr
> Set .Configuration = iConf
> .TextBody = "the cell A1 changed to: " & rng
> SendEmailGmail = .Send
> End With
> MsgBox " Email sent to " & nTo & " successfully ! "
> Set iMsg = Nothing
> Set iConf = Nothing
> Set Flds = Nothing
> End Sub
>
> Private Sub Worksheet_Change(ByVal Target As Range)
> If ThisWorkbook.ActiveSheet.Range("A1") < 10 Then
> Call SendEmail
> Else
> End If
> End Sub
>
> 'Basole.
>
>
>
>
>
>
>
> Em domingo, 6 de outubro de 2013 17h34min31s UTC-3, Bill Q escreveu:
>>
>> Hi, 
>>
>> I am using Excel 2007 and have Gmail as my primary email account.
>>
>> I have a dynamic spreadsheet that monitors different stock prices that is 
>> refreshed ever "x" amount of minutes.
>>
>> I would like to have a small macro created so that when a certain cell is 
>> either <= to a certain price, will automatically send me an email to my 
>> Gmail account with the message to be defined later.
>>
>> Anyone ? 
>>
>> Thanks in advance ?  
>>
>

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Re: Complicated Formula (automatic add back)

2013-10-08 Thread amar takale

Dear any solution pls


On Mon, Oct 7, 2013 at 6:13 PM, amar takale  wrote:

> Dear sir
> Thanks for reply first.I attached example file with detailed.pls see it.
> Regards
> Amar
>
>
> On Mon, Oct 7, 2013 at 5:05 PM, Rs.  wrote:
>
>> Amar,
>>
>> You want to add the Balance Qty with your Received Qty (ie in Cell F7)
>> But where you key-in (on which cell) your second receipt for "A"??
>>
>> Regards
>>
>> Rs.
>>
>> --
>> 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 http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>
>

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ INDEX MATCH DOUBT

2013-10-08 Thread Kannan Excel

Hi friend,

if you feel free, pls teach me how u did this formula. my major doubt is
why you using +COLUMN()-3) and why you using ctrl+shift+enter.

when you feel free pls tell me...


On Tue, Oct 8, 2013 at 3:35 PM, Ravinder wrote:

> Thanks dear…..
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Kannan Excel
> *Sent:* Tuesday, October 08, 2013 3:32 PM
>
> *To:* Google
> *Cc:* Soum
> *Subject:* Re: $$Excel-Macros$$ INDEX MATCH DOUBT
>
> ** **
>
> *HEY AWESOME, FANTASTIC, EXCELENT GREAT :-) AM REALLY HAPPY :-)*
>
> *THANK U BOSS, THANKS A LOT :-) ITS WORKING. :-)*
>
> ** **
>
> ** **
>
> ** **
>
> On Tue, Oct 8, 2013 at 3:21 PM, Ravinder 
> wrote:
>
> There may be different total number of rows in ur file
>
> Try this
>
>  
>
> =INDEX('MASTER DATA'!$A$2:$AQ$65000,MATCH($F$4,'MASTER 
> DATA'!$D$2:$D$65000,0),MATCH($B18&$C$17,'MASTER
> DATA'!$A$1:$AQ$1&'MASTER DATA'!$A$2:$AQ$2,0)+COLUMN()-3)  ctrl+shift+enter
> 
>
>  
>
>  
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Kannan Excel
> *Sent:* Tuesday, October 08, 2013 3:15 PM
>
>
> *To:* Google
> *Cc:* Soum
> *Subject:* Re: $$Excel-Macros$$ INDEX MATCH DOUBT
>
>  
>
> *HEY,*
>
>  
>
> *ITS REALLY GREAY BOSS BUT ITS UNABLE TO COPY PASTE IN MY ORIGINAL MASTER
> DATA.*
>
> *WHAT I HAVE TO DO:??*
>
>  
>
> =INDEX('MASTER DATA'!$A$2:$AQ$65000,MATCH($F$4,'MASTER 
> DATA'!$D$2:$D$65000,0),MATCH($B18&$C$17,'MASTER
> DATA'!$A$1:$AQ$1&'MASTER DATA'!$A$2:$AQ$2,0)+COLUMN()-3)
>
>  
>
>  
>
>  
>
> On Tue, Oct 8, 2013 at 2:53 PM, Ravinder 
> wrote:
>
> I think this one help u
>
>  
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Kannan Excel
> *Sent:* Tuesday, October 08, 2013 2:38 PM
> *To:* Google
> *Cc:* Soum
> *Subject:* Re: $$Excel-Macros$$ INDEX MATCH DOUBT
>
>  
>
> That also i tried... :-(  but no use. it too urgent, anybody help me
>
>  
>
> On Tue, Oct 8, 2013 at 2:25 PM, Ravinder 
> wrote:
>
> I think u did not mentioned “BITUMEN’ in second sheet
>
>  
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Kannan Excel
> *Sent:* Tuesday, October 08, 2013 1:41 PM
> *To:* Google
> *Subject:* $$Excel-Macros$$ INDEX MATCH DOUBT
>
>  
>
> *HI,*
>
>  
>
> *PLS FIND THE ATTACHED FILE AND DO THE NEEDFUL PRIORITY BASE..*
>
>  
>
>  
>
> *REGARDS*
>
> *KANNAN V*
>
> --
> 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 http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
> --
> 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 p

RE: $$Excel-Macros$$ INDEX MATCH DOUBT

2013-10-08 Thread Ravinder

Thanks dear...

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kannan Excel
Sent: Tuesday, October 08, 2013 3:32 PM
To: Google
Cc: Soum
Subject: Re: $$Excel-Macros$$ INDEX MATCH DOUBT

HEY AWESOME, FANTASTIC, EXCELENT GREAT :-) AM REALLY HAPPY :-)

THANK U BOSS, THANKS A LOT :-) ITS WORKING. :-)

On Tue, Oct 8, 2013 at 3:21 PM, Ravinder 
wrote:

There may be different total number of rows in ur file

Try this

=INDEX('MASTER DATA'!$A$2:$AQ$65000,MATCH($F$4,'MASTER
DATA'!$D$2:$D$65000,0),MATCH($B18&$C$17,'MASTER DATA'!$A$1:$AQ$1&'MASTER
DATA'!$A$2:$AQ$2,0)+COLUMN()-3)  ctrl+shift+enter

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kannan Excel
Sent: Tuesday, October 08, 2013 3:15 PM

To: Google
Cc: Soum
Subject: Re: $$Excel-Macros$$ INDEX MATCH DOUBT

HEY,

ITS REALLY GREAY BOSS BUT ITS UNABLE TO COPY PASTE IN MY ORIGINAL MASTER
DATA.

WHAT I HAVE TO DO:??

=INDEX('MASTER DATA'!$A$2:$AQ$65000,MATCH($F$4,'MASTER
DATA'!$D$2:$D$65000,0),MATCH($B18&$C$17,'MASTER DATA'!$A$1:$AQ$1&'MASTER
DATA'!$A$2:$AQ$2,0)+COLUMN()-3)

On Tue, Oct 8, 2013 at 2:53 PM, Ravinder 
wrote:

I think this one help u

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kannan Excel
Sent: Tuesday, October 08, 2013 2:38 PM
To: Google
Cc: Soum
Subject: Re: $$Excel-Macros$$ INDEX MATCH DOUBT

That also i tried... :-(  but no use. it too urgent, anybody help me

On Tue, Oct 8, 2013 at 2:25 PM, Ravinder 
wrote:

I think u did not mentioned "BITUMEN' in second sheet

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kannan Excel
Sent: Tuesday, October 08, 2013 1:41 PM
To: Google
Subject: $$Excel-Macros$$ INDEX MATCH DOUBT

HI,

PLS FIND THE ATTACHED FILE AND DO THE NEEDFUL PRIORITY BASE..

REGARDS

KANNAN V

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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

Re: $$Excel-Macros$$ INDEX MATCH DOUBT

2013-10-08 Thread Kannan Excel

*HEY AWESOME, FANTASTIC, EXCELENT GREAT :-) AM REALLY HAPPY :-)*
*THANK U BOSS, THANKS A LOT :-) ITS WORKING. :-)
*




On Tue, Oct 8, 2013 at 3:21 PM, Ravinder wrote:

> There may be different total number of rows in ur file
>
> Try this
>
> ** **
>
> =INDEX('MASTER DATA'!$A$2:$AQ$65000,MATCH($F$4,'MASTER 
> DATA'!$D$2:$D$65000,0),MATCH($B18&$C$17,'MASTER
> DATA'!$A$1:$AQ$1&'MASTER DATA'!$A$2:$AQ$2,0)+COLUMN()-3)  ctrl+shift+enter
> 
>
> ** **
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Kannan Excel
> *Sent:* Tuesday, October 08, 2013 3:15 PM
>
> *To:* Google
> *Cc:* Soum
> *Subject:* Re: $$Excel-Macros$$ INDEX MATCH DOUBT
>
> ** **
>
> *HEY,*
>
> ** **
>
> *ITS REALLY GREAY BOSS BUT ITS UNABLE TO COPY PASTE IN MY ORIGINAL MASTER
> DATA.*
>
> *WHAT I HAVE TO DO:??*
>
>  
>
> =INDEX('MASTER DATA'!$A$2:$AQ$65000,MATCH($F$4,'MASTER 
> DATA'!$D$2:$D$65000,0),MATCH($B18&$C$17,'MASTER
> DATA'!$A$1:$AQ$1&'MASTER DATA'!$A$2:$AQ$2,0)+COLUMN()-3)
>
> ** **
>
> ** **
>
> ** **
>
> On Tue, Oct 8, 2013 at 2:53 PM, Ravinder 
> wrote:
>
> I think this one help u
>
>  
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Kannan Excel
> *Sent:* Tuesday, October 08, 2013 2:38 PM
> *To:* Google
> *Cc:* Soum
> *Subject:* Re: $$Excel-Macros$$ INDEX MATCH DOUBT
>
>  
>
> That also i tried... :-(  but no use. it too urgent, anybody help me
>
>  
>
> On Tue, Oct 8, 2013 at 2:25 PM, Ravinder 
> wrote:
>
> I think u did not mentioned “BITUMEN’ in second sheet
>
>  
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Kannan Excel
> *Sent:* Tuesday, October 08, 2013 1:41 PM
> *To:* Google
> *Subject:* $$Excel-Macros$$ INDEX MATCH DOUBT
>
>  
>
> *HI,*
>
>  
>
> *PLS FIND THE ATTACHED FILE AND DO THE NEEDFUL PRIORITY BASE..*
>
>  
>
>  
>
> *REGARDS*
>
> *KANNAN V*
>
> --
> 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 http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
> --
> 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 http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>  
>
> --
> 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

RE: $$Excel-Macros$$ INDEX MATCH DOUBT

2013-10-08 Thread Ravinder

There may be different total number of rows in ur file

Try this

 

=INDEX('MASTER DATA'!$A$2:$AQ$65000,MATCH($F$4,'MASTER
DATA'!$D$2:$D$65000,0),MATCH($B18&$C$17,'MASTER DATA'!$A$1:$AQ$1&'MASTER
DATA'!$A$2:$AQ$2,0)+COLUMN()-3)  ctrl+shift+enter

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kannan Excel
Sent: Tuesday, October 08, 2013 3:15 PM
To: Google
Cc: Soum
Subject: Re: $$Excel-Macros$$ INDEX MATCH DOUBT

 

HEY,

 

ITS REALLY GREAY BOSS BUT ITS UNABLE TO COPY PASTE IN MY ORIGINAL MASTER
DATA.

WHAT I HAVE TO DO:??

 

=INDEX('MASTER DATA'!$A$2:$AQ$65000,MATCH($F$4,'MASTER
DATA'!$D$2:$D$65000,0),MATCH($B18&$C$17,'MASTER DATA'!$A$1:$AQ$1&'MASTER
DATA'!$A$2:$AQ$2,0)+COLUMN()-3)

 

 

 

On Tue, Oct 8, 2013 at 2:53 PM, Ravinder 
wrote:

I think this one help u

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kannan Excel
Sent: Tuesday, October 08, 2013 2:38 PM
To: Google
Cc: Soum
Subject: Re: $$Excel-Macros$$ INDEX MATCH DOUBT

 

That also i tried... :-(  but no use. it too urgent, anybody help me

 

On Tue, Oct 8, 2013 at 2:25 PM, Ravinder 
wrote:

I think u did not mentioned "BITUMEN' in second sheet

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kannan Excel
Sent: Tuesday, October 08, 2013 1:41 PM
To: Google
Subject: $$Excel-Macros$$ INDEX MATCH DOUBT

 

HI,

 

PLS FIND THE ATTACHED FILE AND DO THE NEEDFUL PRIORITY BASE..

 

 

REGARDS

KANNAN V

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

 

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

Re: $$Excel-Macros$$ INDEX MATCH DOUBT

2013-10-08 Thread Kannan Excel

*HEY,*
*
*
*ITS REALLY GREAY BOSS BUT ITS UNABLE TO COPY PASTE IN MY ORIGINAL MASTER
DATA.*
*WHAT I HAVE TO DO:??*

=INDEX('MASTER DATA'!$A$2:$AQ$1048576,MATCH($F$4,'MASTER
DATA'!$D$2:$D$1048576,0),MATCH($B18&$C$17,'MASTER DATA'!$A$1:$AQ$1&'MASTER
DATA'!$A$2:$AQ$2,0)+COLUMN()-3)




On Tue, Oct 8, 2013 at 2:53 PM, Ravinder wrote:

> I think this one help u
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Kannan Excel
> *Sent:* Tuesday, October 08, 2013 2:38 PM
> *To:* Google
> *Cc:* Soum
> *Subject:* Re: $$Excel-Macros$$ INDEX MATCH DOUBT
>
> ** **
>
> That also i tried... :-(  but no use. it too urgent, anybody help me
>
> ** **
>
> On Tue, Oct 8, 2013 at 2:25 PM, Ravinder 
> wrote:
>
> I think u did not mentioned “BITUMEN’ in second sheet
>
>  
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Kannan Excel
> *Sent:* Tuesday, October 08, 2013 1:41 PM
> *To:* Google
> *Subject:* $$Excel-Macros$$ INDEX MATCH DOUBT
>
>  
>
> *HI,*
>
>  
>
> *PLS FIND THE ATTACHED FILE AND DO THE NEEDFUL PRIORITY BASE..*
>
>  
>
>  
>
> *REGARDS*
>
> *KANNAN V*
>
> --
> 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 http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
> --
> 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 http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
> ** **
>
> --
> 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 http://groups.g

RE: $$Excel-Macros$$ INDEX MATCH DOUBT

2013-10-08 Thread Ravinder

I think this one help u

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kannan Excel
Sent: Tuesday, October 08, 2013 2:38 PM
To: Google
Cc: Soum
Subject: Re: $$Excel-Macros$$ INDEX MATCH DOUBT

That also i tried... :-(  but no use. it too urgent, anybody help me

On Tue, Oct 8, 2013 at 2:25 PM, Ravinder 
wrote:

I think u did not mentioned "BITUMEN' in second sheet

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kannan Excel
Sent: Tuesday, October 08, 2013 1:41 PM
To: Google
Subject: $$Excel-Macros$$ INDEX MATCH DOUBT

HI,

PLS FIND THE ATTACHED FILE AND DO THE NEEDFUL PRIORITY BASE..

REGARDS

KANNAN V

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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

Re: $$Excel-Macros$$ INDEX MATCH DOUBT

2013-10-08 Thread Kannan Excel

That also i tried... :-(  but no use. it too urgent, anybody help me


On Tue, Oct 8, 2013 at 2:25 PM, Ravinder wrote:

> I think u did not mentioned “BITUMEN’ in second sheet
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Kannan Excel
> *Sent:* Tuesday, October 08, 2013 1:41 PM
> *To:* Google
> *Subject:* $$Excel-Macros$$ INDEX MATCH DOUBT
>
> ** **
>
> *HI,*
>
> ** **
>
> *PLS FIND THE ATTACHED FILE AND DO THE NEEDFUL PRIORITY BASE..*
>
> ** **
>
> ** **
>
> *REGARDS*
>
> *KANNAN V*
>
> --
> 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 http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
> --
> 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 http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

RE: $$Excel-Macros$$ INDEX MATCH DOUBT

2013-10-08 Thread Ravinder

I think u did not mentioned "BITUMEN' in second sheet

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kannan Excel
Sent: Tuesday, October 08, 2013 1:41 PM
To: Google
Subject: $$Excel-Macros$$ INDEX MATCH DOUBT

HI,

PLS FIND THE ATTACHED FILE AND DO THE NEEDFUL PRIORITY BASE..

REGARDS

KANNAN V

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ INDEX MATCH DOUBT

2013-10-08 Thread Kannan Excel

*HI,*
*
*
*PLS FIND THE ATTACHED FILE AND DO THE NEEDFUL PRIORITY BASE..*
*
*
*
*
*REGARDS*
*KANNAN V*

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


DOUBT.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Re: Recognizing Number format

2013-10-08 Thread Sandeep Kumar Chhajer

Sorry for all mails sent to you today...actually my outlook is not working for 
3 days and all mails were there in outbox.

Sorry for the inconvenience :(

All the issues regarding this thread are resolved.

Thanks once again.
  Sandeep Chhajer.


Sent on my BlackBerry® from Vodafone

-Original Message-
From: "Sandeep Chhajer" 
Date: Tue, 8 Oct 2013 13:19:55 
To: 
Subject: Recognizing Number format

Dear Excel Gurus,

 

I have a peculiar problem. When I import data in excel from Tally it shows
me number as shown below 

 


 

Balance

Debit

Credit

Balance


Aditya Birla Memorial Hospital

3049.00

3049.00

 


Aditya Enterprises

99521.00

101086.00

1565.00 Cr


Airways Corporation

39363.80 Dr

39363.80 Dr


Airways Surgical Pvt Ltd

361446.45 Dr

959168.00

1133676.00

186938.45 Dr


AL-SAMIYAH GROUP FOR MARKETING & INT. TRADE

791326.00

883606.25

92280.25 Cr


Al-Wafigroup for Marketing & Int'l Trade Co.

743036.00

754572.48

11536.48 Cr


 

 

When I check in format menu it shows me ""0.00" Cr"  for NEGETAIVE  value
and ""0.00" Dr" for POSITIVE value.

 

All I want to do is recognise the format with the help of macro and change
the value accordingly.

 

I have tried to develop a macro with my very lesser knowledge but it is
not working as value of  variable "b" is not changing according to its
present (changing) location.  

Please help.

 

My VBA Working

 

Sub format()

a = Range("e15").NumberFormat

' i want this "b" shall change value according to the new destination i.e.

'   _want to make it as variable according to the new cell format.

b = ActiveCell.NumberFormat

Do

ActiveCell.Offset(1, 0).Select

If a = b Then

ActiveCell.Offset(0, 1).Select

ActiveCell.Formula = ActiveCell.Offset(0, -1) * -1

ActiveCell.Offset(0, -1).Select

Else

ActiveCell.Offset(0, 1).Select

ActiveCell.Formula = ActiveCell.Offset(0, -1) * 1

ActiveCell.Offset(0, -1).Select

End If

Loop Until ActiveCell.Offset(0, -4).Value = ""

End Sub

 

Thanks in advance.

 

 

 

Thank you
Regards


Sandeep Kumar Chhajer.

  

 

 


-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Recognizing Number format

2013-10-08 Thread Sandeep Chhajer

Dear Excel Gurus,

 

I have a peculiar problem. When I import data in excel from Tally it shows
me number as shown below 

 


 

Balance

Debit

Credit

Balance


Aditya Birla Memorial Hospital

3049.00

3049.00

 


Aditya Enterprises

99521.00

101086.00

1565.00 Cr


Airways Corporation

39363.80 Dr

39363.80 Dr


Airways Surgical Pvt Ltd

361446.45 Dr

959168.00

1133676.00

186938.45 Dr


AL-SAMIYAH GROUP FOR MARKETING & INT. TRADE

791326.00

883606.25

92280.25 Cr


Al-Wafigroup for Marketing & Int'l Trade Co.

743036.00

754572.48

11536.48 Cr


 

 

When I check in format menu it shows me ""0.00" Cr"  for NEGETAIVE  value
and ""0.00" Dr" for POSITIVE value.

 

All I want to do is recognise the format with the help of macro and change
the value accordingly.

 

I have tried to develop a macro with my very lesser knowledge but it is not
working as value of  variable "b" is not changing according to its present
(changing) location.  

Please help.

 

My VBA Working

 

Sub format()

a = Range("e15").NumberFormat

' i want this "b" shall change value according to the new destination i.e.

'   _want to make it as variable according to the new cell format.

b = ActiveCell.NumberFormat

Do

ActiveCell.Offset(1, 0).Select

If a = b Then

ActiveCell.Offset(0, 1).Select

ActiveCell.Formula = ActiveCell.Offset(0, -1) * -1

ActiveCell.Offset(0, -1).Select

Else

ActiveCell.Offset(0, 1).Select

ActiveCell.Formula = ActiveCell.Offset(0, -1) * 1

ActiveCell.Offset(0, -1).Select

End If

Loop Until ActiveCell.Offset(0, -4).Value = ""

End Sub

 

Thanks in advance.

 

 

 

Thank you
Regards


Sandeep Kumar Chhajer.

  

 

 

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


dr cr.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12

RE: $$Excel-Macros$$ Identifying Excel number format

2013-10-08 Thread Sandeep Chhajer

Dear Xltime,

 

 

The macro is working fine but the loop it is not going down to the last used
cell it is working only up to 1st blank cell can you please change the code
so as to make it run up to last used cell.

 

Thanks in advance.

 

Thank you
Regards


Sandeep Kumar Chhajer.

  

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of xlstime
Sent: 05 October 2013 16:59
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Identifying Excel number format

 

c

an you please example your requirement 

please find attachment hope it fulfill your requirement 




.

Enjoy
Team XLS

 

On Sat, Oct 5, 2013 at 3:14 PM, Sandeep Chhajer mailto:chhajersand...@gmail.com> > wrote:

PFA the original file. Hope it will work.

 

On 5 October 2013 13:00, ashish koul mailto:koul.ash...@gmail.com> > wrote:

i can't see custom format

 

On Sat, Oct 5, 2013 at 12:59 PM, Sandeep Kumar Chhajer
mailto:chhajersand...@gmail.com> > wrote:

Dear Ashish,

This is only original file, I have just cut down the number of entries to
certain extent as I am checking my code with lesser data.

Sent on my BlackBerryR from Vodafone

  _  

From: ashish koul mailto:koul.ash...@gmail.com> > 

Sender: excel-macros@googlegroups.com 


Date: Sat, 5 Oct 2013 12:55:31 +0530

To: excel-macrosmailto:excel-macros@googlegroups.com> >

ReplyTo: excel-macros@googlegroups.com
  

Subject: Re: $$Excel-Macros$$ Identifying Excel number format

 

can u share the orginal file 

 

On Sat, Oct 5, 2013 at 12:53 PM, Sandeep Chhajer mailto:chhajersand...@gmail.com> > wrote:

Dear Excel Gurus,

 

I have facing a peculiar problem related to number format.

When I export any ledger from tally I got result as bellow

 

 

 


Aditya Birla Memorial Hospital

3049.00

3049.00

 


Aditya Enterprises

99521.00

101086.00

1565.00 Cr


Airways Corporation

39363.80 Dr

39363.80 Dr


Airways Surgical Pvt Ltd

361446.45 Dr

959168.00

1133676.00

186938.45 Dr


AL-SAMIYAH GROUP FOR MARKETING & INT. TRADE

791326.00

883606.25

92280.25 Cr


Al-Wafigroup for Marketing & Int'l Trade Co.

743036.00

754572.48

11536.48 Cr


 

   Now, the custom number format for negative number is ""0.00" Cr" and for
positive number is ""0.00" Dr". (I have also attached herewith the file for
your reference.)

 

Again, I have tried to build a macro with my limited VBA knowledge but it is
not working as variable "b" is not changing according to the current cursor
location.

I am pasting what i have tried.

 

 

Sub format()

a = Range("e15").NumberFormat

' i want this "b" shall change value according to the new destination i.e.

'   _want to make it as variable according to the new cell format.

b = ActiveCell.NumberFormat

Do

ActiveCell.Offset(1, 0).Select

If a = b Then

ActiveCell.Offset(0, 1).Select

ActiveCell.Formula = ActiveCell.Offset(0, -1) * -1

ActiveCell.Offset(0, -1).Select

Else

ActiveCell.Offset(0, 1).Select

ActiveCell.Formula = ActiveCell.Offset(0, -1) * 1

ActiveCell.Offset(0, -1).Select

End If

Loop Until ActiveCell.Offset(0, -4).Value = ""

End Sub 

 

Please Help me out.

 

Thanks in advance.

 


 

-- 

Regards,
Sandeep Kumar Chhajer.

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.





 

-- 

Regards

 

Ashish Koul

 

 

Visit

  My Excel Blog

Like Us on Facebook
 

Join Us on Facebook  

 

 

P Befor

RE: $$Excel-Macros$$ Writing a string to a particular cell

2013-10-08 Thread Ravinder

Use Cells(4, iPasteCol).address)

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Jewel Sharma
Sent: Tuesday, October 08, 2013 1:08 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Writing a string to a particular cell

Hi,
This should have a quick fix hopefully. Please tell me what's is wrong with
the following lines in the code:

sStr1 = "Personnel " & iNumPer + 1
ThisWorkbook.Worksheets("Job Details").Range(Cells(4, iPasteCol)).Value =
sStr1

When i run the code, I receive

Run-time error '1004':
Application-defined or object-defined error

sStr1 is declared as a "string". iNumper is declared as an "Integer".
iPasteCol is declared as an "Integer". I've used MsgBox to confirm the
values stored in them are correct.
Currently, iNumper = 1, sSTR1 = "Personnel 2", iPasteCol = 19.

All I want to do is to write [Personnel 2] in cell S4 of the worksheet "Job
Details"; but I need to use the column index number instead of the letter.
I've tried Range.Text, as well as Range.FormulaR1C1; but I receive the same
error.

Thanks in advance.
Jewel

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Writing a string to a particular cell

2013-10-08 Thread Jewel Sharma

Hi,
This should have a quick fix hopefully. Please tell me what's is wrong with 
the following lines in the code:
sStr1 = "Personnel " & iNumPer + 1
ThisWorkbook.Worksheets("Job Details").Range(Cells(4, iPasteCol)).Value = 
sStr1

When i run the code, I receive
*Run-time error '1004':*
*Application-defined or object-defined error*

sStr1 is declared as a "string". iNumper is declared as an "Integer". 
iPasteCol is declared as an "Integer". I've used MsgBox to confirm the 
values stored in them are correct.
Currently, iNumper = 1, sSTR1 = "Personnel 2", iPasteCol = 19.

All I want to do is to write [Personnel 2] in cell S4 of the worksheet "Job 
Details"; but I need to use the column index number instead of the letter. 
I've tried Range.Text, as well as Range.FormulaR1C1; but I receive the same 
error.

Thanks in advance.
Jewel

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Re: Email Trigger ?

2013-10-08 Thread Aashish Watve

Hi Bill,

For your question about Enable Reference.

In VBA window, where your VBA code is, under Tools menu you will find this
option.

Basole,

I am still struggling to make this code work (without using Outlook). I
still get the error "transport failed to connect to the server".

Regards,
Aashish


On Tue, Oct 8, 2013 at 9:43 AM, Bill Q  wrote:

> HI Besole,
>
> I am impressed with your code. I will be really impressed once it works !
>
> I read up a bit on the "Enable Reference> Object> Microsoft CDO for
> Windows 2000 Library".
> Sorry, but I am lost on this one and need guidence.
>
> I have put my email address and password where indicated and I left the
> quotes (" ") there. Is that correct, or should the quotes be removed ?
>
> I see two other parts, but it appears to be just notes with no action
> required on my part. Am I correct ?
>
> ' send one copy with Google SMTP server (with autentication)
> schema = 
> "http://schemas.microsoft.com/**cdo/configuration/"
>   ***
> Flds.Item(schema & "sendusing") = 2
> Flds.Item(schema & "smtpserver") = "smtp.gmail.com"
> ***
>
> Thanks !
>
>
>
>
>
> On Monday, 7 October 2013 11:05:24 UTC-4, Basole wrote:
>>
>>
>>
>> 'hi, below option of sending email ( gmail ) without Outlook with SMTP
>> server
>>
>> Sub SendEmail()
>> ' Enable Reference> Object> Microsoft CDO for Windows 2000 Library
>> Dim iMsg, iConf, Flds, nTo, nFr, rng, psw
>>
>> nTo = "your email address here"
>> nFr = nTo
>> rng = Range("a1").Value
>> psw = "your email password here"
>> Set iMsg = CreateObject("CDO.Message")
>> Set iConf = CreateObject("CDO.**Configuration")
>> Set Flds = iConf.Fields
>> ' send one copy with Google SMTP server (with autentication)
>> schema = 
>> "http://schemas.microsoft.com/**cdo/configuration/
>> "
>> Flds.Item(schema & "sendusing") = 2
>> Flds.Item(schema & "smtpserver") = "smtp.gmail.com"
>> Flds.Item(schema & "smtpserverport") = 465
>> Flds.Item(schema & "smtpauthenticate") = 1
>> Flds.Item(schema & "sendusername") = nTo
>> Flds.Item(schema & "sendpassword") = psw
>> Flds.Item(schema & "smtpusessl") = 1
>> Flds.Update
>>
>> With iMsg
>> .To = nTo
>> .From = nFr
>> .Subject = "Important message"
>> .ReplyTo = nFr
>> Set .Configuration = iConf
>> .TextBody = "the cell A1 changed to: " & rng
>> SendEmailGmail = .Send
>> End With
>> MsgBox " Email sent to " & nTo & " successfully ! "
>> Set iMsg = Nothing
>> Set iConf = Nothing
>> Set Flds = Nothing
>> End Sub
>>
>> Private Sub Worksheet_Change(ByVal Target As Range)
>> If ThisWorkbook.ActiveSheet.**Range("A1") < 10 Then
>> Call SendEmail
>> Else
>> End If
>> End Sub
>>
>> 'Basole.
>>
>>
>>
>>
>>
>>
>>
>> Em domingo, 6 de outubro de 2013 17h34min31s UTC-3, Bill Q escreveu:
>>>
>>> Hi,
>>>
>>> I am using Excel 2007 and have Gmail as my primary email account.
>>>
>>> I have a dynamic spreadsheet that monitors different stock prices that
>>> is refreshed ever "x" amount of minutes.
>>>
>>> I would like to have a small macro created so that when a certain cell
>>> is either <= to a certain price, will automatically send me an email to my
>>> Gmail account with the message to be defined later.
>>>
>>> Anyone ?
>>>
>>> Thanks in advance ?
>>>
>>  --
> 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 http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>

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

$$Excel-Macros$$ Re: Read a Text file with delimiter as comma and import the infor into excel sheet

$$Excel-Macros$$ Re: Email Trigger ?

$$Excel-Macros$$ Re: Email Trigger ?

$$Excel-Macros$$ Re: Email Trigger ?

$$Excel-Macros$$ Re: Interview Questions with Answers (Excel+VBA+Access+SQL Server)

RE: $$Excel-Macros$$ Re: Pie chart

$$Excel-Macros$$ Re: Need macro export data into workbooks with grand Totals and specified format

$$Excel-Macros$$ Re: Multi sheets Grouping Problem

$$Excel-Macros$$ Getting Application-defined or object-defined error, when pasting the data from webpage to excel

Re: $$Excel-Macros$$ Re: Email Trigger ?

$$Excel-Macros$$ Re: Email Trigger ?

Re: $$Excel-Macros$$ Re: Complicated Formula (automatic add back)

Re: $$Excel-Macros$$ INDEX MATCH DOUBT

RE: $$Excel-Macros$$ INDEX MATCH DOUBT

Re: $$Excel-Macros$$ INDEX MATCH DOUBT

RE: $$Excel-Macros$$ INDEX MATCH DOUBT

Re: $$Excel-Macros$$ INDEX MATCH DOUBT

RE: $$Excel-Macros$$ INDEX MATCH DOUBT

Re: $$Excel-Macros$$ INDEX MATCH DOUBT

RE: $$Excel-Macros$$ INDEX MATCH DOUBT

$$Excel-Macros$$ INDEX MATCH DOUBT

$$Excel-Macros$$ Re: Recognizing Number format

$$Excel-Macros$$ Recognizing Number format

RE: $$Excel-Macros$$ Identifying Excel number format

RE: $$Excel-Macros$$ Writing a string to a particular cell

$$Excel-Macros$$ Writing a string to a particular cell

Re: $$Excel-Macros$$ Re: Email Trigger ?

27 matches

Site Navigation

Mail list logo

Footer information