Re: $$Excel-Macros$$ Macro is not working
Hi,
I believe your code is extracting the file name from the path which you are
browsing.
Your code had problem in substitute formula. Please check
Function Extractfilename(url As Variant) As String
For i = 1 To Len(url)
If Mid(url, i, 1) = "\" Then
x = x + 1
End If
Next i
'n = Application.WorksheetFunction.Substitute("\", "@", x)
>>>>>>>>>>>>error in this line
n = Application.WorksheetFunction.Substitute(url, "\", "@", x)'''Corrected"
m = Application.WorksheetFunction.Search("@", n) + 1
Extractfilename = Trim(Mid(url, m, Len(url)))
End Function
On Fri, Sep 2, 2016 at 11:57 AM, Learner Excel <xlst...@gmail.com> wrote:
> For list of file name, use enclosed code.
>
> --
>
> On Fri, Sep 2, 2016 at 10:33 PM, Izhar <izharra...@gmail.com> wrote:
>
>>
>> Please open the file and see the question
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
--
*Thanks & Regards*
*Gaurav Devrani*
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Want to count unique values from duplicate , by VBA or formula please help shiv..
Hi, Please check the attached file. On Tue, Aug 30, 2016 at 6:22 AM, Shiv s <shankar.shiv...@gmail.com> wrote: > Hello everyone, > > Please help me on above subject. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- *Thanks & Regards* *Gaurav Devrani* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. unique.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Click Button on URL using VBA
Hi,
check this out.
Sub Scraping()
Dim appIE As Object
Set appIE = CreateObject("internetexplorer.application")
With appIE
.Visible = True
.navigate "
https://www.google.co.in/?gfe_rd=cr=vuy-V726B9GL8Qf9qYW4CQ_rd=ssl;
appIE.document.getElementByid("gb_70").Click
End With
End Sub
On Thu, Aug 25, 2016 at 7:28 AM, Emamuddin Shah <emt...@gmail.com> wrote:
> Thanks Gaurav, but I don't want to navigate I want it to click that button.
> On Aug 25, 2016 6:40 PM, "Gaurav Devrani" <gauravdev1...@gmail.com> wrote:
>
>> Hi ,
>>
>> Check this code. I have just navigated the sign in link.
>>
>> Sub Scraping()
>>Dim appIE As Object
>>Set appIE = CreateObject("internetexplorer.application")
>>With appIE
>>.Visible = True
>>.navigate "https://www.google.co.in/?gfe
>> _rd=cr=vuy-V726B9GL8Qf9qYW4CQ_rd=ssl"
>>.navigate "https://accounts.google.com/S
>> erviceLogin?hl=en=true=https://www.google.
>> co.in/%3Fgfe_rd%3Dcr%26ei%3Dvuy-V726B9GL8Qf9qYW4CQ%26gws_rd%3Dssl"
>>End With
>> End Sub
>>
>> On Thu, Aug 25, 2016 at 6:48 AM, Emamuddin Shah <emt...@gmail.com> wrote:
>>
>>> Please suggest solutions... I just started vba crawling
>>> On Aug 25, 2016 6:17 PM, "Gaurav Devrani" <gauravdev1...@gmail.com>
>>> wrote:
>>>
>>>> Please disregard my email.
>>>>
>>>> On Thu, Aug 25, 2016 at 6:05 AM, Emamuddin Shah <emt...@gmail.com>
>>>> wrote:
>>>>
>>>>>
>>>>>
>>>>> Dear Friends,
>>>>>
>>>>> iam trying to click an button on url, please help my error
>>>>>
>>>>> CODE-
>>>>>
>>>>> Sub click1()
>>>>>
>>>>> Dim ie As InternetExplorerMedium
>>>>> Dim url As String
>>>>>
>>>>> Set ie = New InternetExplorerMedium
>>>>>
>>>>>
>>>>> '### BUILD THE FULL URL
>>>>> url = "www.google.com"
>>>>>
>>>>> With ie
>>>>> .Visible = True
>>>>> .Navigate url
>>>>> End With
>>>>> 'wait for page to load
>>>>>
>>>>> 'Do While ie.Busy Or ie.ReadyState <> 4
>>>>> 'DoEvents
>>>>> 'Loop
>>>>>
>>>>> ie.Document.getelementsbyname("Sign in").click
>>>>>
>>>>> End Sub
>>>>>
>>>>> ERROR -
>>>>>
>>>>> run time error '-2147467259(80004005)':
>>>>>
>>>>> Automation Error
>>>>> Unspecifed Error
>>>>>
>>>>>
>>>>> thanks!!!
>>>>>
>>>>> --
>>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>>>> https://www.facebook.com/discussexcel
>>>>>
>>>>> FORUM RULES
>>>>>
>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>>>> Advice will not get quick attention or may not be answered.
>>>>> 2) Don't post a question in the thread of another member.
>>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>>> measure.
>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>> 5) Jobs posting is not allowed.
>>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>>
>>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>>> and members are not responsible for any loss.
>>>>> ---
>>>>> You received this message because you are subscribed to the Google
>>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>>>> To post to this group, send email to excel-macros@googlegroups.com.
>>>>> Visit this group at https://groups.google.com/group/excel-macros.
>>>>> For more opti
Re: $$Excel-Macros$$ Click Button on URL using VBA
Hi ,
Check this code. I have just navigated the sign in link.
Sub Scraping()
Dim appIE As Object
Set appIE = CreateObject("internetexplorer.application")
With appIE
.Visible = True
.navigate "
https://www.google.co.in/?gfe_rd=cr=vuy-V726B9GL8Qf9qYW4CQ_rd=ssl;
.navigate "
https://accounts.google.com/ServiceLogin?hl=en=true=https://www.google.co.in/%3Fgfe_rd%3Dcr%26ei%3Dvuy-V726B9GL8Qf9qYW4CQ%26gws_rd%3Dssl
"
End With
End Sub
On Thu, Aug 25, 2016 at 6:48 AM, Emamuddin Shah <emt...@gmail.com> wrote:
> Please suggest solutions... I just started vba crawling
> On Aug 25, 2016 6:17 PM, "Gaurav Devrani" <gauravdev1...@gmail.com> wrote:
>
>> Please disregard my email.
>>
>> On Thu, Aug 25, 2016 at 6:05 AM, Emamuddin Shah <emt...@gmail.com> wrote:
>>
>>>
>>>
>>> Dear Friends,
>>>
>>> iam trying to click an button on url, please help my error
>>>
>>> CODE-
>>>
>>> Sub click1()
>>>
>>> Dim ie As InternetExplorerMedium
>>> Dim url As String
>>>
>>> Set ie = New InternetExplorerMedium
>>>
>>>
>>> '### BUILD THE FULL URL
>>> url = "www.google.com"
>>>
>>> With ie
>>> .Visible = True
>>> .Navigate url
>>> End With
>>> 'wait for page to load
>>>
>>> 'Do While ie.Busy Or ie.ReadyState <> 4
>>> 'DoEvents
>>> 'Loop
>>>
>>> ie.Document.getelementsbyname("Sign in").click
>>>
>>> End Sub
>>>
>>> ERROR -
>>>
>>> run time error '-2147467259(80004005)':
>>>
>>> Automation Error
>>> Unspecifed Error
>>>
>>>
>>> thanks!!!
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at https://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>
>>
>> --
>>
>> *Thanks & Regards*
>> *Gaurav Devrani*
>>
>> --
>> 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 a topic in the
>> Google Groups "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this topic, visit https://groups.google.com/d/to
>> pic/excel-macros/Gy_BSFcd_88/unsubscribe.
&g
Re: $$Excel-Macros$$ Click Button on URL using VBA
Please disregard my email.
On Thu, Aug 25, 2016 at 6:05 AM, Emamuddin Shah <emt...@gmail.com> wrote:
>
>
> Dear Friends,
>
> iam trying to click an button on url, please help my error
>
> CODE-
>
> Sub click1()
>
> Dim ie As InternetExplorerMedium
> Dim url As String
>
> Set ie = New InternetExplorerMedium
>
>
> '### BUILD THE FULL URL
> url = "www.google.com"
>
> With ie
> .Visible = True
> .Navigate url
> End With
> 'wait for page to load
>
> 'Do While ie.Busy Or ie.ReadyState <> 4
> 'DoEvents
> 'Loop
>
> ie.Document.getelementsbyname("Sign in").click
>
> End Sub
>
> ERROR -
>
> run time error '-2147467259(80004005)':
>
> Automation Error
> Unspecifed Error
>
>
> thanks!!!
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
--
*Thanks & Regards*
*Gaurav Devrani*
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Click Button on URL using VBA
Hi,
Please check the below code.
Sub Click()
Dim objIE As Object
Dim strURLAs String
Set objIE = CreateObject("InternetExplorer.application")
strURL = "www.google.com"
With objIE
.Visible
.navigate = strURL
End With
End Sub
On Thu, Aug 25, 2016 at 6:05 AM, Emamuddin Shah <emt...@gmail.com> wrote:
>
>
> Dear Friends,
>
> iam trying to click an button on url, please help my error
>
> CODE-
>
> Sub click1()
>
> Dim ie As InternetExplorerMedium
> Dim url As String
>
> Set ie = New InternetExplorerMedium
>
>
> '### BUILD THE FULL URL
> url = "www.google.com"
>
> With ie
> .Visible = True
> .Navigate url
> End With
> 'wait for page to load
>
> 'Do While ie.Busy Or ie.ReadyState <> 4
> 'DoEvents
> 'Loop
>
> ie.Document.getelementsbyname("Sign in").click
>
> End Sub
>
> ERROR -
>
> run time error '-2147467259(80004005)':
>
> Automation Error
> Unspecifed Error
>
>
> thanks!!!
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
--
*Thanks & Regards*
*Gaurav Devrani*
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Rename all sheets of one excel file in single shot with different names
What do you mean by 49 sheets. I don't think this code have such functionality not to work more than 49 sheets. I am sure you are confused with the code written inside. but still let me know your opinion about 49 sheets. On Tue, Aug 23, 2016 at 3:04 AM, Pravin Gunjal <isk1...@gmail.com> wrote: > Dear Gaurav > > Thanks for solution. You have created a sheet viz. *Tab-Names *and then > used two macros based on requirement. > > But my worry is that in every month number of sheets are getting changed > and I believe the codes can run only up to 49 sheets. Please check and > advise. > > > *With regards,**Pravin Gunjal* > *Mobile: 77100 * > *97250* > > > > > On Wed, Aug 17, 2016 at 4:05 PM, Gaurav Devrani <gauravdev1...@gmail.com> > wrote: > >> Hi Pravin, >> >> I think this query was already posted few weeks back. Please check the >> attachment. Let me know if that does not work. >> >> Regards >> Gaurav Devrani >> >> On Wed, Aug 17, 2016 at 3:25 AM, Pravin Gunjal <isk1...@gmail.com> wrote: >> >>> Dear Friends, >>> >>> Greetings! >>> >>> Could you please teach me how to rename multiple sheets in a single shot >>> with different name of each sheet. >>> >>> Any tool/formula/VB is welcome. Thanks, >>> >>> Example: >>> 1. Gather all sheet names in a new sheet in the same file >>> 2. In the next column type new names (which are to be replaced) >>> 3. Make one button in that sheet - once the button is hit the all the >>> sheets are renamed. >>> >>> Regards >>> Pravin Gunjal >>> >>> -- >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> 2) Don't post a question in the thread of another member. >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> 4) Acknowledge the responses you receive, good or bad. >>> 5) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners and >>> members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to excel-macros+unsubscr...@googlegroups.com. >>> To post to this group, send email to excel-macros@googlegroups.com. >>> Visit this group at https://groups.google.com/group/excel-macros. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> >> >> -- >> >> *Thanks & Regards* >> *Gaurav Devrani* >> >> -- >> 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 a topic in the >> Google Groups "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this topic, visit https://groups.google.com/d/to >> pic/excel-macros/tW_oubrzWAs/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group a
Re: $$Excel-Macros$$ Copy Paste Problem
Hi Shrini, As you said that you are receiving files from various users, are those excel files? if yes , then can you provide us those files, not exactly your original files. I know those files would be a confidential data, but may be if you can create few files with the dummy data that you need (highlight your data in your files) and send it over, then i can help you write a code. Because i need to know that where that data lies in your files, so we can automate and copy the data from various files and then paste that data in your desired location. Dummy files with the data is must to understand your query. If those are multiple excel files , you can also create a loop on those files using FSO (File system object) and copy that data. Let me know. Waiting for your response Shrini. Regards Gaurav Devrani On Wed, Aug 10, 2016 at 12:40 AM, Shrinivas Shevde <shrinivas...@gmail.com> wrote: > Dear Sir, > Thanks for effort putting to solve my query. > As you suggest I need to write a code but main hurdle is that both things > (from where to copy and where to paste )are not fixed as I am receiving > files from various users.So its difficult to write code. > Thanks for help > Regards > Shrinivas > > On Tue, Aug 9, 2016 at 9:40 PM, Gaurav Devrani <gauravdev1...@gmail.com> > wrote: > >> Hi Shrini, >> >> In that case either you need to grab all the data from those different >> location to the file which i sent and paste that data in column A and code >> will automatically check the range size. And if you dont want to copy the >> data manually and you want to automate this process too, then you need to >> write code to do that process and just paste that data in column A in the >> attached file that i sent earlier. you can check that code in case you want >> to know about the range where code is running, Let me know if i am not able >> to answer your question. >> >> Regards >> Gaurav Devrani >> 8586932754 >> >> On Tue, Aug 9, 2016 at 6:00 AM, Shrinivas Shevde <shrinivas...@gmail.com> >> wrote: >> >>> Dear Sir >>> Thanks for Problem >>> Actually I want to copy paste more than 50 items from various locations >>> In that case How will I use this macro. >>> So I want way to copy paste ot macro >>> >>> Regards >>> Shrinivas >>> >>> >>> On Tue, Aug 9, 2016 at 4:09 PM, Gaurav Devrani <gauravdev1...@gmail.com> >>> wrote: >>> >>>> Hi Shrini, >>>> >>>> Please check the attached file. Let me know if this does not solve your >>>> query. >>>> >>>> Regards >>>> Gaurav Devrani >>>> >>>> On Tue, Aug 9, 2016 at 1:37 AM, Shrinivas Shevde < >>>> shrinivas...@gmail.com> wrote: >>>> >>>>> Dear all >>>>> I have data in Column A in 1to 6 rows . I want to copy paste in Column >>>>> F but in column F 2 rows are merged .I want outout as shown in column I >>>>> but >>>>> I am getting as shown in F .Is there any way o copy paste data from non >>>>> merged cell to merged cell >>>>> Thanks in Advance. >>>>> >>>>> -- >>>>> Shrini >>>>> >>>>> -- >>>>> 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 ema
Re: $$Excel-Macros$$ Copy Paste Problem
Hi Shrini, In that case either you need to grab all the data from those different location to the file which i sent and paste that data in column A and code will automatically check the range size. And if you dont want to copy the data manually and you want to automate this process too, then you need to write code to do that process and just paste that data in column A in the attached file that i sent earlier. you can check that code in case you want to know about the range where code is running, Let me know if i am not able to answer your question. Regards Gaurav Devrani 8586932754 On Tue, Aug 9, 2016 at 6:00 AM, Shrinivas Shevde <shrinivas...@gmail.com> wrote: > Dear Sir > Thanks for Problem > Actually I want to copy paste more than 50 items from various locations > In that case How will I use this macro. > So I want way to copy paste ot macro > > Regards > Shrinivas > > > On Tue, Aug 9, 2016 at 4:09 PM, Gaurav Devrani <gauravdev1...@gmail.com> > wrote: > >> Hi Shrini, >> >> Please check the attached file. Let me know if this does not solve your >> query. >> >> Regards >> Gaurav Devrani >> >> On Tue, Aug 9, 2016 at 1:37 AM, Shrinivas Shevde <shrinivas...@gmail.com> >> wrote: >> >>> Dear all >>> I have data in Column A in 1to 6 rows . I want to copy paste in Column F >>> but in column F 2 rows are merged .I want outout as shown in column I but I >>> am getting as shown in F .Is there any way o copy paste data from non >>> merged cell to merged cell >>> Thanks in Advance. >>> >>> -- >>> Shrini >>> >>> -- >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> 2) Don't post a question in the thread of another member. >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> 4) Acknowledge the responses you receive, good or bad. >>> 5) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners and >>> members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to excel-macros+unsubscr...@googlegroups.com. >>> To post to this group, send email to excel-macros@googlegroups.com. >>> Visit this group at https://groups.google.com/group/excel-macros. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> >> >> -- >> >> *Thanks & Regards* >> *Gaurav Devrani* >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at https://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Shrini > > -- >
Re: $$Excel-Macros$$ Copy Paste Problem
Hi Shrini, Please check the attached file. Let me know if this does not solve your query. Regards Gaurav Devrani On Tue, Aug 9, 2016 at 1:37 AM, Shrinivas Shevde <shrinivas...@gmail.com> wrote: > Dear all > I have data in Column A in 1to 6 rows . I want to copy paste in Column F > but in column F 2 rows are merged .I want outout as shown in column I but I > am getting as shown in F .Is there any way o copy paste data from non > merged cell to merged cell > Thanks in Advance. > > -- > Shrini > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- *Thanks & Regards* *Gaurav Devrani* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Query (1).xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ MSG: Code execution has been interrupted
Hi Pravin, Give it a try with this code in the beginning of your macro. application.EnableCancelKey=xlDisabled I am not 100% sure. But let me know whatever happens. On Sat, Sep 19, 2015 at 2:15 AM, Pravin Gunjal <isk1...@gmail.com> wrote: > Hi, > > I am getting an above mentioned error message while running any macro on > my computer, while the same macro could run in other computer. > > Could you please help me out on this. Thanks, > > Regards > Pravin Gunjal. > > -- > 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/d/optout. > -- *Thanks & Regards* *Gaurav Devrani* -- 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/d/optout.
Re: $$Excel-Macros$$ RE: Help required
Either Press Cntl + 1 and then change the date format Or try this code in number format (VBA) = [$-409]dd-mmm-yy;@ DD-MMM-YY On Tue, Aug 4, 2015 at 4:59 AM, Neeraj Chauhan neerajchauhan...@gmail.com wrote: Thanks Anand *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Anand Tiwari *Sent:* Tuesday, August 04, 2015 4:24 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ RE: Help required Hi Neeraj Please use this, Alt+D+E then Delimited next click Date and choose format DMY then finish. *Regards,* *Anand Tiwari* On 4 August 2015 at 16:14, Neeraj Chauhan neerajchauhan...@gmail.com wrote: Dear experts I want to change the date format Date I want this format 31/7/2015 31-Jul-15 -- 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/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Thanks Regards* *Gaurav Devrani* -- 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
Re: $$Excel-Macros$$ Re: Populating rows using a range of data
Hi , Please check the attached file. Regards Gaurav Devrani On Wed, Apr 15, 2015 at 3:54 PM, Umar Abeer umarab...@googlemail.com wrote: Hi Mandeep, Many thanks. It serves the purpose but is there any way we can use index/match or any range formula to achieve the same? BR Aby On Wed, Apr 15, 2015 at 1:12 PM, Mandeep Baluja rockerna...@gmail.com wrote: check this out. the value which is blank does not go into the bucket you have set. Regards, Mandeep Baluja On Wednesday, April 15, 2015 at 2:21:15 PM UTC+5:30, dinoabeer wrote: Dear Experts, I have been trying to figure out a way to populate the row D9 to AM9 based on the table provided D14 to J18. I have tried index/match but to no avail. Any help in appreciated. Best Regards Aby -- 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/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Thanks Regards* *Gaurav Devrani* -- 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/d/optout. Price update using a formula (1).xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Urgent Help
Hi guys. I have a sheet where I have couple of pivot tables.. So I want a macro, where I can get access of entire sheet except pivot table data.. Pivot table data should be locked and if i create another pivot table in the same sheet. it should also be locked next time. So i can only use rest of the data except Pivot. To access pivot table data i need a macro to ask for password and then only I should be able to get access of pivot. If it does not make any sense.. Please let me know. i will explain again. Help me Guys.. -- *Thanks Regards* *Gaurav Devrani* -- 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/d/optout.
Re: $$Excel-Macros$$ Query for autofit columns.
Hi Mandeep, Please check the attached file. let me know if I am missing something. Regards Gaurav Devrani On Thu, Mar 12, 2015 at 1:43 PM, Mandeep baluja mandeepbal...@gmail.com wrote: Quuery for autofit -- 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/d/optout. -- *Thanks Regards* *Gaurav Devrani* -- 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/d/optout. QueryforAutofitcolumns.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Please help me Urgent
Dat's Cool Vaibhav. Thanks. On Wed, Mar 11, 2015 at 11:32 PM, Michael Vinoth michaelvino...@gmail.com wrote: Very Nice... Mr.Vabz On Wednesday, March 11, 2015 at 6:33:10 PM UTC+5:30, Vabz wrote: Suppose you have value in cell A1 then type follo. formula in A2 dont press enter press F9, you will get result in curly bracket, after = sign enter CONCATENATE( press enter to get result =TRANSPOSE(IF(EXACT(MID(A1,ROW(INDIRECT(1:LEN(A1))),1) ,UPPER(MID(A1,ROW(INDIRECT(1:LEN(A1))),1))),LOWER(MID(A1, ROW(INDIRECT(1:LEN(A1))),1)),UPPER(MID(A1,ROW(INDIRECT( 1:LEN(A1))),1) Cheers!! On Thu, Feb 26, 2015 at 8:42 PM, Gaurav Devrani gaurav...@gmail.com wrote: Hi Guys, I have a query . In this sentence.. This iS a tEst . All Upper case alphabets should be lower case and All Lowercase alphabets should be in Upper case. Please help me . I want that to be done in excel formulas.(If thats possible). Thanks Regards Gaurav Devrani -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Thanks Regards* *Gaurav Devrani* -- 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/d/optout.
Re: $$Excel-Macros$$ Formula based on some criteria
Hi Rameshwari , Please check the file. Let me know if it does not work for you. Regards Gaurav Devrani On Thu, Mar 12, 2015 at 5:47 PM, Rameshwari rameshwarish...@gmail.com wrote: Hello team, I stuck with one formula, please help me on this. Formula based on some criteria. Sheet “Question” having currency name with the prices, based on currency name prices need to update the value in answer filed. Master sheet will be a reference for the currency. Every 13 row need to change the reference. What I am looking ;- if AED is 15 then need to search in master file SAR 15 update the value of AED based on SAR, for KWD update the value of KWD based on SAR, it means in question sheet AED will be base and in Master sheet SAR will be the base. JOD, LBP, EGP, IQD will be the same as mention. Please urgent help required. Regards, Rameshwari -- 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/d/optout. -- *Thanks Regards* *Gaurav Devrani* -- 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/d/optout. Book16.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Query for autofit columns.
Okay. .I got it. On Thu, Mar 12, 2015 at 2:41 PM, Mandeep baluja mandeepbal...@gmail.com wrote: Not working Range(C8).CurrentRegion.Columns.AutoFit this line will unhide the hide columns in between the range. i have tried visible columns property but its not working. On Thursday, 12 March 2015 14:37:51 UTC+5:30, Gaurav Devrani wrote: Hi Mandeep, Please check the attached file. let me know if I am missing something. Regards Gaurav Devrani On Thu, Mar 12, 2015 at 1:43 PM, Mandeep baluja mandee...@gmail.com wrote: Quuery for autofit -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Thanks Regards* *Gaurav Devrani* -- 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/d/optout. -- *Thanks Regards* *Gaurav Devrani* -- 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/d/optout.
Re: $$Excel-Macros$$ Excel VBA to hide sheets of a workbook closes others too
Hi, I tried working on that.. while I was testing that , nothing such happend as you said that your other workbook started hidding sheets. Just wanted to See if you are using activeworkbook instead of thisworkbook. Let me know, if this is not the issue. I will see what i can do for that. And also I am sure that in your code Index is referring to the sheet name that you want to unhide. Regards Gaurav Devrani On Wed, Mar 4, 2015 at 7:34 AM, Yahya Muhammad yahya...@gmail.com wrote: Dears Any solution, please ! On Mon, Mar 2, 2015 at 11:24 AM, Yahya Muhammad yahya...@gmail.com wrote: Hi Experts I have an excel workbook, say Workbook1 with a vba on its workbook_open event to hide all worksheets except one, as follows: - Private Sub Workbook_Open() Dim sh As Worksheet For Each sh In ThisWorkbook.Worksheets If sh.Name Index Then sh.Visible = xlSheetHidden End If Next sh End Sub -- But my issue is that when I open another workbook while workbook1 is open, (say workbook2), while working on both workbooks, suddenly all the sheets of workbook2 also goes hidden, except the first one. I am unable to find a solution for this. Please help. -- 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/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Thanks Regards* *Gaurav Devrani* -- 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
Re: $$Excel-Macros$$ Please help me Urgent
Hi Paul, Thanks for the amazing macro you sent. it worked like a charm.. Thanks again. Regards Gaurav Devrani On Fri, Feb 27, 2015 at 1:04 AM, Paul Schreiner schreiner_p...@att.net wrote: Are you wanting a macro made to work like a function? Like: =CaseSwap(A1) where CaseSwap is: Option Explicit Public Function CaseSwap(target As String) Dim Pos As Integer Dim StrNew StrNew = For Pos = 1 To Len(target) If (Mid(target, Pos, 1) = UCase(Mid(target, Pos, 1))) Then StrNew = StrNew LCase(Mid(target, Pos, 1)) Else StrNew = StrNew UCase(Mid(target, Pos, 1)) End If Next Pos CaseSwap = StrNew End Function *Paul* - *“Do all the good you can,By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - *From:* Gaurav Devrani gauravdev1...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Thursday, February 26, 2015 11:55 AM *Subject:* Re: $$Excel-Macros$$ Please help me Urgent Thanks Paul for your quick reply. Yes I was also trying to create a macro but Just wanted to confirm before, if that's possible in excel functions. No worries. I really appreciate your quick response once again. Thank you. Regards Gaurav Devrani On Thu, Feb 26, 2015 at 10:16 PM, Paul Schreiner schreiner_p...@att.net wrote: I don't believe you'll be able to do that with standard Excel functions. you can create a CUSTOM function using VBA and use it like an Excel function. In your case, you need to process each character and switch the case. the problem is, within a standard Excel function, there's no way to process each character. *Paul* - *“Do all the good you can,By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - *From:* Gaurav Devrani gauravdev1...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Thursday, February 26, 2015 10:12 AM *Subject:* $$Excel-Macros$$ Please help me Urgent Hi Guys, I have a query . In this sentence.. This iS a tEst . All Upper case alphabets should be lower case and All Lowercase alphabets should be in Upper case. Please help me . I want that to be done in excel formulas.(If thats possible). Thanks Regards Gaurav Devrani -- 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/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Please help me Urgent
Thanks Paul for your quick reply. Yes I was also trying to create a macro but Just wanted to confirm before, if that's possible in excel functions. No worries. I really appreciate your quick response once again. Thank you. Regards Gaurav Devrani On Thu, Feb 26, 2015 at 10:16 PM, Paul Schreiner schreiner_p...@att.net wrote: I don't believe you'll be able to do that with standard Excel functions. you can create a CUSTOM function using VBA and use it like an Excel function. In your case, you need to process each character and switch the case. the problem is, within a standard Excel function, there's no way to process each character. *Paul* - *“Do all the good you can,By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - *From:* Gaurav Devrani gauravdev1...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Thursday, February 26, 2015 10:12 AM *Subject:* $$Excel-Macros$$ Please help me Urgent Hi Guys, I have a query . In this sentence.. This iS a tEst . All Upper case alphabets should be lower case and All Lowercase alphabets should be in Upper case. Please help me . I want that to be done in excel formulas.(If thats possible). Thanks Regards Gaurav Devrani -- 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/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Thanks Regards Gaurav Devrani -- 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
$$Excel-Macros$$ Please help me Urgent
Hi Guys, I have a query . In this sentence.. This iS a tEst . All Upper case alphabets should be lower case and All Lowercase alphabets should be in Upper case. Please help me . I want that to be done in excel formulas.(If thats possible). Thanks Regards Gaurav Devrani -- 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/d/optout.
Re: $$Excel-Macros$$ Formula to populate cells and sum in adjacent cell
Hi , I guess you also want to merge the header cells in sheet 2 for all entries.. Please refer to this new sheet. Regards Gaurav Devrani On Mon, Feb 23, 2015 at 6:19 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: HI Enock, Please check the attached file and let me know if I missed something. Regards Gaurav Devrani On Mon, Feb 23, 2015 at 5:08 AM, Enock Wangila ekwang...@gmail.com wrote: Hi Guys, I want a formula that populates values in a worksheet, on a single row based on two values entered on a different worksheet. The formula should then sum the populated cells and input the result in the cell adjacent to the last cell entry. Example: I want to fill 9 cells in sheet2 with a value of 100 and sum the cell entries in the adjacent cell to give 900. The operations of populating and summing should be contained in a single formula. I have attached an excel file for illustration. Cheers, -- 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/d/optout. -- Thanks Regards Gaurav Devrani -- Thanks Regards Gaurav Devrani -- 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/d/optout. Illustration (1).xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Formula to populate cells and sum in adjacent cell
Yes Sure.. I will get back to you with that formula. No worries. Regards Gaurav Devrani On Mon, Feb 23, 2015 at 7:25 AM, Enock Wangila ekwang...@gmail.com wrote: Hi Gaurav, Thank you for you help. Quick question, is there a way of using a formula instead of a code to do what you have done. Maybe an If statement of some sort. Would appreciate if that were possible. I really need a formula. On Mon, Feb 23, 2015 at 4:42 PM, Gaurav Devrani gauravdev1...@gmail.com wrote: Hi , I guess you also want to merge the header cells in sheet 2 for all entries.. Please refer to this new sheet. Regards Gaurav Devrani On Mon, Feb 23, 2015 at 6:19 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: HI Enock, Please check the attached file and let me know if I missed something. Regards Gaurav Devrani On Mon, Feb 23, 2015 at 5:08 AM, Enock Wangila ekwang...@gmail.com wrote: Hi Guys, I want a formula that populates values in a worksheet, on a single row based on two values entered on a different worksheet. The formula should then sum the populated cells and input the result in the cell adjacent to the last cell entry. Example: I want to fill 9 cells in sheet2 with a value of 100 and sum the cell entries in the adjacent cell to give 900. The operations of populating and summing should be contained in a single formula. I have attached an excel file for illustration. Cheers, -- 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/d/optout. -- Thanks Regards Gaurav Devrani -- Thanks Regards Gaurav Devrani -- 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/d/optout. -- *Enock Wangila,* *Intern Analyst* *Umati Capital Ltd* *Eden Square * *Block 1, 7th Floor* *P.O Box 856-00606* *Mobile: +254 708 037 464* *Email: ekwang...@gmail.com ekwang...@gmail.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
Re: $$Excel-Macros$$ Formula to populate cells and sum in adjacent cell
HI Enock, Please check the attached file and let me know if I missed something. Regards Gaurav Devrani On Mon, Feb 23, 2015 at 5:08 AM, Enock Wangila ekwang...@gmail.com wrote: Hi Guys, I want a formula that populates values in a worksheet, on a single row based on two values entered on a different worksheet. The formula should then sum the populated cells and input the result in the cell adjacent to the last cell entry. Example: I want to fill 9 cells in sheet2 with a value of 100 and sum the cell entries in the adjacent cell to give 900. The operations of populating and summing should be contained in a single formula. I have attached an excel file for illustration. Cheers, -- 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/d/optout. -- Thanks Regards Gaurav Devrani -- 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/d/optout. Illustration (1).xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Formula to populate cells and sum in adjacent cell
Try this in B5 of sheet2 and drag right. =IF((COLUMN()-1)=Sheet1!$B$3,Sheet1!$B$2,IF((COLUMN()-1)=Sheet1!$B$3+1,SUM(OFFSET($A$5,,1,,Sheet1!$B$3)),)) On Mon, Feb 23, 2015 at 7:29 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: Yes Sure.. I will get back to you with that formula. No worries. Regards Gaurav Devrani On Mon, Feb 23, 2015 at 7:25 AM, Enock Wangila ekwang...@gmail.com wrote: Hi Gaurav, Thank you for you help. Quick question, is there a way of using a formula instead of a code to do what you have done. Maybe an If statement of some sort. Would appreciate if that were possible. I really need a formula. On Mon, Feb 23, 2015 at 4:42 PM, Gaurav Devrani gauravdev1...@gmail.com wrote: Hi , I guess you also want to merge the header cells in sheet 2 for all entries.. Please refer to this new sheet. Regards Gaurav Devrani On Mon, Feb 23, 2015 at 6:19 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: HI Enock, Please check the attached file and let me know if I missed something. Regards Gaurav Devrani On Mon, Feb 23, 2015 at 5:08 AM, Enock Wangila ekwang...@gmail.com wrote: Hi Guys, I want a formula that populates values in a worksheet, on a single row based on two values entered on a different worksheet. The formula should then sum the populated cells and input the result in the cell adjacent to the last cell entry. Example: I want to fill 9 cells in sheet2 with a value of 100 and sum the cell entries in the adjacent cell to give 900. The operations of populating and summing should be contained in a single formula. I have attached an excel file for illustration. Cheers, -- 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/d/optout. -- Thanks Regards Gaurav Devrani -- Thanks Regards Gaurav Devrani -- 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/d/optout. -- *Enock Wangila,* *Intern Analyst* *Umati Capital Ltd* *Eden Square * *Block 1, 7th Floor* *P.O Box 856-00606* *Mobile: +254 708 037 464* *Email: ekwang...@gmail.com ekwang...@gmail.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
Re: $$Excel-Macros$$ Excel Tip
Superb Vaibhav. Thanks for sharing this with us. Regards Gaurav Devrani On Mon, Feb 23, 2015 at 11:25 PM, Chandan Bisht csb.bi...@gmail.com wrote: Hi. Very nice... Thankx Rgds, Chandra Singh Bisht On Mon, Feb 23, 2015 at 8:36 PM, Vaibhav Joshi v...@vabs.in wrote: Convert all date in same format: While receiving data from different sources many time it happens that data received is not in same format due to various reason. One of the tedious activity is to transforming data to same format. I will share very good technique to convert all dates to same format, suppose you have date in one column A it has different format viz dd-mm- or -mm-dd (it should be in d-m-y or y-m-d format). In column B write formula in cell B1, =A1*1 drag down; you can see all dates will get converted in same format in column b. Also you can apply paste special multiply by 1 operation on data in column A if you don't want to get result through help of column. Also you can perform data text to column operation of column A, select data type as Delimited, delimiter type Tab, data format General. Do share me if you have discovered unique method/trick. Cheers!! -- 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/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Thanks Regards Gaurav Devrani -- 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/d/optout.
Re: $$Excel-Macros$$ Reestructure Excel File and Save as Word file
okay... Thanks Vaibhav. On Sat, Feb 14, 2015 at 5:43 AM, Vaibhav Joshi v...@vabs.in wrote: I mean free file.. On Fri, Feb 13, 2015 at 8:39 PM, Gaurav Devrani gauravdev1...@gmail.com wrote: Hi Vaibhav, What is FF? Can you please tell me ? Dont have any idea about that please. On Fri, Feb 13, 2015 at 8:04 AM, Vaibhav Joshi v...@vabs.in wrote: Cheers, also you could have created FF save it as .doc. On Fri, Feb 13, 2015 at 8:21 PM, Gaurav Devrani gauravdev1...@gmail.com wrote: Cool. :) On Fri, Feb 13, 2015 at 7:06 AM, Eugenio Grant eugenio.gr...@gmail.com wrote: Thaks for the complete answer, it works like a charm! On Thu, Feb 12, 2015 at 7:18 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: Hi, Please check the file , On Wed, Feb 11, 2015 at 10:06 AM, Eugenio Grant eugenio.gr...@gmail.com wrote: Variables identified as type = double should be treated differently in order to adjust to a expected format... On Wed, Feb 11, 2015 at 11:03 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: Why second line need to be restructured in different format. Like Pos3 pos 5 Please let me know. I will work on that. On Wed, Feb 11, 2015 at 8:09 AM, Eugenio Grant eugenio.gr...@gmail.com wrote: I have a Excel Sheet lile this: type Begin End Text Var simple 1 2 Car v43 double 3 5 Ball v50 I want to reestructure and save to Word, (via VBA or Macro) reestructured like this: [v43] Car simple POS 1 to 2 [v50] Ball double POS 3 POS 5 Thanks for your help. -- 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/d/optout. -- Thanks Regards Gaurav Devrani -- 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 a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/ag1HegTY7Hk/unsubscribe . To unsubscribe from this group and all its topics, 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/d/optout. -- *_* *Eugenio Grant MoraData Procesos**eugenio.gr...@gmail.com eugenio.gr...@gmail.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
Re: $$Excel-Macros$$ Reestructure Excel File and Save as Word file
Hi Vaibhav, What is FF? Can you please tell me ? Dont have any idea about that please. On Fri, Feb 13, 2015 at 8:04 AM, Vaibhav Joshi v...@vabs.in wrote: Cheers, also you could have created FF save it as .doc. On Fri, Feb 13, 2015 at 8:21 PM, Gaurav Devrani gauravdev1...@gmail.com wrote: Cool. :) On Fri, Feb 13, 2015 at 7:06 AM, Eugenio Grant eugenio.gr...@gmail.com wrote: Thaks for the complete answer, it works like a charm! On Thu, Feb 12, 2015 at 7:18 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: Hi, Please check the file , On Wed, Feb 11, 2015 at 10:06 AM, Eugenio Grant eugenio.gr...@gmail.com wrote: Variables identified as type = double should be treated differently in order to adjust to a expected format... On Wed, Feb 11, 2015 at 11:03 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: Why second line need to be restructured in different format. Like Pos3 pos 5 Please let me know. I will work on that. On Wed, Feb 11, 2015 at 8:09 AM, Eugenio Grant eugenio.gr...@gmail.com wrote: I have a Excel Sheet lile this: type Begin End Text Var simple 1 2 Car v43 double 3 5 Ball v50 I want to reestructure and save to Word, (via VBA or Macro) reestructured like this: [v43] Car simple POS 1 to 2 [v50] Ball double POS 3 POS 5 Thanks for your help. -- 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/d/optout. -- Thanks Regards Gaurav Devrani -- 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 a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/ag1HegTY7Hk/unsubscribe . To unsubscribe from this group and all its topics, 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/d/optout. -- *_* *Eugenio Grant MoraData Procesos**eugenio.gr...@gmail.com eugenio.gr...@gmail.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
Re: $$Excel-Macros$$ Reestructure Excel File and Save as Word file
Cool. :) On Fri, Feb 13, 2015 at 7:06 AM, Eugenio Grant eugenio.gr...@gmail.com wrote: Thaks for the complete answer, it works like a charm! On Thu, Feb 12, 2015 at 7:18 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: Hi, Please check the file , On Wed, Feb 11, 2015 at 10:06 AM, Eugenio Grant eugenio.gr...@gmail.com wrote: Variables identified as type = double should be treated differently in order to adjust to a expected format... On Wed, Feb 11, 2015 at 11:03 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: Why second line need to be restructured in different format. Like Pos3 pos 5 Please let me know. I will work on that. On Wed, Feb 11, 2015 at 8:09 AM, Eugenio Grant eugenio.gr...@gmail.com wrote: I have a Excel Sheet lile this: type Begin End Text Var simple 1 2 Car v43 double 3 5 Ball v50 I want to reestructure and save to Word, (via VBA or Macro) reestructured like this: [v43] Car simple POS 1 to 2 [v50] Ball double POS 3 POS 5 Thanks for your help. -- 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/d/optout. -- Thanks Regards Gaurav Devrani -- 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 a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/ag1HegTY7Hk/unsubscribe. To unsubscribe from this group and all its topics, 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/d/optout. -- *_* *Eugenio Grant MoraData Procesos**eugenio.gr...@gmail.com eugenio.gr...@gmail.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
Re: $$Excel-Macros$$ Reestructure Excel File and Save as Word file
Hi, Please check the file , On Wed, Feb 11, 2015 at 10:06 AM, Eugenio Grant eugenio.gr...@gmail.com wrote: Variables identified as type = double should be treated differently in order to adjust to a expected format... On Wed, Feb 11, 2015 at 11:03 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: Why second line need to be restructured in different format. Like Pos3 pos 5 Please let me know. I will work on that. On Wed, Feb 11, 2015 at 8:09 AM, Eugenio Grant eugenio.gr...@gmail.com wrote: I have a Excel Sheet lile this: type Begin End Text Var simple 1 2 Car v43 double 3 5 Ball v50 I want to reestructure and save to Word, (via VBA or Macro) reestructured like this: [v43] Car simple POS 1 to 2 [v50] Ball double POS 3 POS 5 Thanks for your help. -- 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/d/optout. -- Thanks Regards Gaurav Devrani -- 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 a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/ag1HegTY7Hk/unsubscribe. To unsubscribe from this group and all its topics, 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/d/optout. -- *_* *Eugenio Grant MoraData Procesos**eugenio.gr...@gmail.com eugenio.gr...@gmail.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/d/optout. -- Thanks Regards Gaurav Devrani -- Are you =EXP
Re: $$Excel-Macros$$ Reestructure Excel File and Save as Word file
Why second line need to be restructured in different format. Like Pos3 pos 5 Please let me know. I will work on that. On Wed, Feb 11, 2015 at 8:09 AM, Eugenio Grant eugenio.gr...@gmail.com wrote: I have a Excel Sheet lile this: type Begin End Text Var simple 1 2 Car v43 double 3 5 Ball v50 I want to reestructure and save to Word, (via VBA or Macro) reestructured like this: [v43] Car simple POS 1 to 2 [v50] Ball double POS 3 POS 5 Thanks for your help. -- 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/d/optout. -- Thanks Regards Gaurav Devrani -- 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/d/optout.
Re: $$Excel-Macros$$ Copy Paste only particular to another sheet
No its new question. having trouble sending email to multiple recipients... When I run my macro. It is sending email individually and pop up every time when sending email. I want to send file to all mailer in just one go. like To , Cc , Bcc. I hope I am explaining it correct. On Mon, Feb 2, 2015 at 1:32 PM, Paul Schreiner schreiner_p...@att.net wrote: Is this related the Copy Paste only particular to another sheet? or is it a new question? *Paul* - *“Do all the good you can,By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - *From:* Gaurav Devrani gauravdev1...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Monday, February 2, 2015 3:01 PM *Subject:* Re: $$Excel-Macros$$ Copy Paste only particular to another sheet Can anyone help me on this? I have a specific data and want to send that data to multiple recipients (have around 50 emails) but when i run my macro. It sends them individually instead of sending in a single Email. So much time consuming. Is there anyway to get it fixed. Please. Hope I was clear enough to explain. Thanks Gaurav On Mon, Feb 2, 2015 at 5:43 AM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Thank you very muc Mr.Vaibhav Mr.Gaurav Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Mon, Feb 2, 2015 at 5:58 PM, Gaurav Devrani gauravdev1...@gmail.com wrote: And Please check the filter again. I guess I dint put that filter on the entire sheet. Please select true values as well and then filter it again. Sorry for the wrong file. On Mon, Feb 2, 2015 at 5:24 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: :) On Mon, Feb 2, 2015 at 5:22 AM, Vaibhav Joshi v...@vabs.in wrote: Great Tip by Gaurav.. On Mon, Feb 2, 2015 at 5:49 PM, Gaurav Devrani gauravdev1...@gmail.com wrote: Please check the attached file, Let me know If I am missing on something. I guess you were trying to copy only those rows. which contains no error.. if not. let me know. Regards Gaurav On Mon, Feb 2, 2015 at 5:09 AM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear Vaibhavji, Thanks to reply, my query to check duplicate value is solved, i was wrong in variable defination. My other query is that I have sheet containing formulas. I want copy paste only those cell which not containing error. Please see attached file for data. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Mon, Feb 2, 2015 at 5:30 PM, Vaibhav Joshi v...@vabs.in wrote: Dear Ashish Bhalara What exactly you are doing, can you pl explain.. On Mon, Feb 2, 2015 at 4:44 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear experts, Below code is not work to check duplicate value, please know me problem in code. For q = 5 To 1000 If Worksheets(BankData).Cells(q, 4).Value = Worksheets(NewEntry).Cells(7, 2).Value Then MsgBox Account number already exist, vbOKOnly, Ashish Exit Sub End If q = q + 1 Next q Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- 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/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles
Re: $$Excel-Macros$$ Copy Paste only particular to another sheet
Can anyone help me on this? I have a specific data and want to send that data to multiple recipients (have around 50 emails) but when i run my macro. It sends them individually instead of sending in a single Email. So much time consuming. Is there anyway to get it fixed. Please. Hope I was clear enough to explain. Thanks Gaurav On Mon, Feb 2, 2015 at 5:43 AM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Thank you very muc Mr.Vaibhav Mr.Gaurav Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Mon, Feb 2, 2015 at 5:58 PM, Gaurav Devrani gauravdev1...@gmail.com wrote: And Please check the filter again. I guess I dint put that filter on the entire sheet. Please select true values as well and then filter it again. Sorry for the wrong file. On Mon, Feb 2, 2015 at 5:24 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: :) On Mon, Feb 2, 2015 at 5:22 AM, Vaibhav Joshi v...@vabs.in wrote: Great Tip by Gaurav.. On Mon, Feb 2, 2015 at 5:49 PM, Gaurav Devrani gauravdev1...@gmail.com wrote: Please check the attached file, Let me know If I am missing on something. I guess you were trying to copy only those rows. which contains no error.. if not. let me know. Regards Gaurav On Mon, Feb 2, 2015 at 5:09 AM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear Vaibhavji, Thanks to reply, my query to check duplicate value is solved, i was wrong in variable defination. My other query is that I have sheet containing formulas. I want copy paste only those cell which not containing error. Please see attached file for data. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Mon, Feb 2, 2015 at 5:30 PM, Vaibhav Joshi v...@vabs.in wrote: Dear Ashish Bhalara What exactly you are doing, can you pl explain.. On Mon, Feb 2, 2015 at 4:44 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear experts, Below code is not work to check duplicate value, please know me problem in code. For q = 5 To 1000 If Worksheets(BankData).Cells(q, 4).Value = Worksheets(NewEntry).Cells(7, 2).Value Then MsgBox Account number already exist, vbOKOnly, Ashish Exit Sub End If q = q + 1 Next q Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- 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/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https
Re: $$Excel-Macros$$ Copy Paste only particular to another sheet
And Please check the filter again. I guess I dint put that filter on the entire sheet. Please select true values as well and then filter it again. Sorry for the wrong file. On Mon, Feb 2, 2015 at 5:24 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: :) On Mon, Feb 2, 2015 at 5:22 AM, Vaibhav Joshi v...@vabs.in wrote: Great Tip by Gaurav.. On Mon, Feb 2, 2015 at 5:49 PM, Gaurav Devrani gauravdev1...@gmail.com wrote: Please check the attached file, Let me know If I am missing on something. I guess you were trying to copy only those rows. which contains no error.. if not. let me know. Regards Gaurav On Mon, Feb 2, 2015 at 5:09 AM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear Vaibhavji, Thanks to reply, my query to check duplicate value is solved, i was wrong in variable defination. My other query is that I have sheet containing formulas. I want copy paste only those cell which not containing error. Please see attached file for data. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Mon, Feb 2, 2015 at 5:30 PM, Vaibhav Joshi v...@vabs.in wrote: Dear Ashish Bhalara What exactly you are doing, can you pl explain.. On Mon, Feb 2, 2015 at 4:44 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear experts, Below code is not work to check duplicate value, please know me problem in code. For q = 5 To 1000 If Worksheets(BankData).Cells(q, 4).Value = Worksheets(NewEntry).Cells(7, 2).Value Then MsgBox Account number already exist, vbOKOnly, Ashish Exit Sub End If q = q + 1 Next q Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- 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/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material
Re: $$Excel-Macros$$ Copy Paste only particular to another sheet
@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Thanks Regards Gaurav Devrani -- 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/d/optout. query.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Copy Paste only particular to another sheet
:) On Mon, Feb 2, 2015 at 5:22 AM, Vaibhav Joshi v...@vabs.in wrote: Great Tip by Gaurav.. On Mon, Feb 2, 2015 at 5:49 PM, Gaurav Devrani gauravdev1...@gmail.com wrote: Please check the attached file, Let me know If I am missing on something. I guess you were trying to copy only those rows. which contains no error.. if not. let me know. Regards Gaurav On Mon, Feb 2, 2015 at 5:09 AM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear Vaibhavji, Thanks to reply, my query to check duplicate value is solved, i was wrong in variable defination. My other query is that I have sheet containing formulas. I want copy paste only those cell which not containing error. Please see attached file for data. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Mon, Feb 2, 2015 at 5:30 PM, Vaibhav Joshi v...@vabs.in wrote: Dear Ashish Bhalara What exactly you are doing, can you pl explain.. On Mon, Feb 2, 2015 at 4:44 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear experts, Below code is not work to check duplicate value, please know me problem in code. For q = 5 To 1000 If Worksheets(BankData).Cells(q, 4).Value = Worksheets(NewEntry).Cells(7, 2).Value Then MsgBox Account number already exist, vbOKOnly, Ashish Exit Sub End If q = q + 1 Next q Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- 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/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group
Re: $$Excel-Macros$$ multi mailer
I have also attached the file. in the attached file we are pulling our file from specific location by browsing and then its sending emails to all . the only concern is sending mail by clubing those emails in the single email. I appreciate you being active on this group and being a good help. Thanks. Thanks Gaurav On Mon, Feb 2, 2015 at 10:04 PM, Anil Gawli gawlianil8...@gmail.com wrote: Dear Gaurav, Pls share the file regards, Anil On Tue, Feb 3, 2015 at 10:25 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: Can anyone help me on this? I have a specific data and want to send that data to multiple recipients (have around 50 emails) but when i run my macro. It sends them individually instead of sending in a single Email. So much time consuming. Is there anyway to get it fixed.(like; Cc, Bcc for 50 or more emails) Please. Hope I was clear enough to explain. -- Thanks Gaurav -- 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/d/optout. -- Thanks Regards Gaurav Devrani -- 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/d/optout. Accessory Master Emails.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$Excel-Macros$$ multi mailer
Can anyone help me on this? I have a specific data and want to send that data to multiple recipients (have around 50 emails) but when i run my macro. It sends them individually instead of sending in a single Email. So much time consuming. Is there anyway to get it fixed.(like; Cc, Bcc for 50 or more emails) Please. Hope I was clear enough to explain. -- Thanks Gaurav -- 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/d/optout.
Re: $$Excel-Macros$$ Wish u all A Merry Christmas
Wish You All Merry X'Mas. On Wed, Dec 24, 2014 at 7:26 PM, amar takale amartak...@gmail.com wrote: Dear All our experts members, Wish u all A Merry Christmas May the Joys of the season Fill your heart with goodwill and cheer. May the chimes of Christmas glory Add up more shine and spread Smiles across the miles Today In the New Year. Regards Amar -- 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/d/optout. -- Thanks Regards Gaurav Devrani -- 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/d/optout.
