r 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
> membe
try ths not tested but shuld work
=SUM(OFFSET(A3,0,1,1,MATCH(ReportPeriod,$A$1:$M$1,0)))
On Thu, Apr 10, 2014 at 6:21 PM, Steve Weaver wrote:
> Thank you Ashish . . . works perfectly. How can I get Col Q on sheet Data
> to show year to date results?
>
> Sent from my iPhone
>
&g
ignore the previous one and try ths one
=SUM(OFFSET(A3,0,0,1,MATCH(ReportPeriod,$A$1:$M$1,0)))
On Thu, Apr 10, 2014 at 7:30 PM, ashish koul wrote:
> try ths not tested but shuld work
>
> =SUM(OFFSET(A3,0,1,1,MATCH(ReportPeriod,$A$1:$M$1,0)))
>
>
> On Thu, Apr 10, 2014 at 6:2
Fexcel%2Fdownloadfile.aspx&h=TAQEit-rd&enc=AZMLNgnrGp9ggxRiSuOJgUHMUCMa4SNXrgVisQk6U6ARpgZeEBLxWw5Sx8-z67s2RYilxKHosxGcUVcrgIDUUOQWpb82ECeR6UWfNwmrADeYx2dP6SgHDr6E25Id8XF8Ntuoeu_ikMOXRWZjTC0b3pxj&s=1>
Dim sURL As String
Dim LocalFilename As String
Dim filename As String
Const folder_na
ost 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.
>
--
*Regards*
*Ashish Koul*
*Visit*
http://www.excelvbamacros.in
Like Us on
Facebook<ht
pls share sample file
On Mon, Apr 7, 2014 at 2:42 PM, Ashish Bhalara wrote:
> Dear experts,
>
> I want merge cell containing text value and want comma(,) between all cell
> value in cocatenate function but my query is that when cell value is blank,
> the comma should not be
edge 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 r
Ashish
On Tue, Apr 8, 2014 at 11:55 PM, ashish koul wrote:
> Hi Matt,
>
> Please try this addin
>
>
>
> On Tue, Apr 8, 2014 at 11:25 PM, Matt Watson wrote:
>
>> I have a formula and macro rich workbook. It has about 21 worksheets that
>> I work in. I mostly
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-mac
1- yes to avoid blank cells n formula's
2 you can try For Each cl In Range("a1:a100")
3 is it small -upper sequence?
On Mon, Apr 7, 2014 at 8:59 PM, Falina Gan wrote:
> Hi Ashish,
>
> Are you there to guide me on the questions below?
>
> Thanks
>
>
> O
Dear experts,
I want merge cell containing text value and want comma(,) between all cell
value in cocatenate function but my query is that when cell value is blank,
the comma should not be display. Is it possible, kindly guide regarding
this.
Thanks & regards.
Ashish Bhalara
9624111822
P*Pl
you need to select the range and then run proper, upper , lower etc as per
your requirement
On Sat, Apr 5, 2014 at 9:54 PM, Falina Gan wrote:
> Hi Ashish,
>
> Good day,
>
> I have tested your codes but the texts are not changes at all. The macro
> have asked me which one to
ups
> "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:
l 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.
>
--
*Regards*
*Ashish Koul*
*Visit*
http://www.excelvbamacros.in
Like Us on
Facebook<http://www.facebook.com/pages/Ex
#x27;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 email
n
> 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.
>
--
*Regards*
*Ash
please share a sample workbook
On Sat, Apr 5, 2014 at 1:18 PM, Ashish Bhalara wrote:
> Dear experts,
>
> I want merge cell containing text value and want comma(,) between all cell
> value in cocatenate function but my query is that when cell value is blank,
> the comma should not
Dear experts,
I want merge cell containing text value and want comma(,) between all cell
value in cocatenate function but my query is that when cell value is blank,
the comma should not be display. Is it possible, kindly guide regarding
this.
Thanks & regards.
Ashish Bhalara
9624111822
P*Pl
th log file in xml which mention below.
- <
recoveryLog xmlns="*http://schemas.openxmlformats.org/spreadsheetml/2006/main
<http://schemas.openxmlformats.org/spreadsheetml/2006/main>*">
error008880_01.xml
Errors were detected in file 'D:\Ashish\Share Document\Account
nd open as [Repaired] file.
This file contain many sheets and conditions of also linking of each
sheets. To complete the task of copy paste in new work book is so hard to
write all conditions & macros. Kindly give the proper solution regarding
this matter.
Thanks & regards.
Ashish Bhalar
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.
-- Forwarded message --
From: Ashish Bhalara
Date: Wed, Apr 2, 2014 at 4:10 PM
Subject: Fwd: $$Excel-Macros$$ Show links which to other Data source
To: "excel-macros@googlegroups com"
-- Forwarded message ------
From: Ashish Bhalara
Date: Tue, Apr 1, 20
wk.Name
wkb.Sheets(1).Range("b" & k).Value = cl.Address
wkb.Sheets(1).Range("c" & k).Value = "'" & cl.Formula
wkb.Sheets(1).Range("d" & k).Value = extlinks(j)
k = k + 1
-- Forwarded message --
From: Ashish Bhalara
Date: Tue, Apr 1, 2014 at 1:23 PM
Subject: $$Excel-Macros$$ Show links which to other Data source
To: "excel-macros@googlegroups com"
Dear experts,
My workbook containing large no. of sheets & formulas, but I want
.Range("b" & k).Value = "'" & cl.Formula
wkb.Sheets(1).Range("c" & k).Value = extlinks(j)
k = k + 1
End If
Next
Next
End Sub
try this for sheet1 only use the loop to go through all worksheets in the
workb
Dear experts,
My workbook containing large no. of sheets & formulas, but I want to show
those formulas which containing links to other data source of file. Kindly
know me how to check it.
--
Regards.
Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely neces
can u share a sample file?
On Sun, Mar 30, 2014 at 9:44 PM, Renata Torquato
wrote:
> Thanks.
>
> That's exactly what I tried before but it doesn't work ... =/
>
> Em domingo, 30 de março de 2014 12h29min52s UTC-3, ashish escreveu:
>>
>> Sub test()
>>
a 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
> e
roup 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
Sub test()
Dim filenm As String, folderpath As String
folderpath = "C:\Documents and Settings\Ashish Koul\Desktop\sample
files\"
filenm = Dir(folderpath)
While (filenm <> "")
If InStr(filenm, ".doc") > 0 Then
Call copytables(folderpat
3:31 UTC+5:30, renuka chari wrote:
>>
>> Hi Ashish/deepak sirs,
>>
>> thanks for your valuable time invested for my query..
>>
>> ashish sir,
>>
>> your code is working like rock
>>
>> my special thanks to you s
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.
>
eived 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 e
Dear Vallinayagam
This sheet are password protected so I can not see the coding of copy paste.
Kindly provide the coding or file containing without password.
Thanks
Ashish
On Thu, Mar 27, 2014 at 3:28 PM, Vallinayagam wrote:
> Hi,
>
> Attached file contains a macro which will be u
thin seconds, and under just
nominal cost. May be most of your basic issues in data cleansing gets
solved.
Thanks.
Ashish Bhatnagar
On Monday, June 4, 2012 8:44:34 PM UTC+5:30, SG wrote:
>
> Hi,
>
> This is my first post in this group.I have learnt many things from this
> group.I'
onds, and under just
nominal cost. May be most of your basic issues in data cleansing gets
solved.
Thanks.
Ashish Bhatnagar
On Wednesday, October 30, 2013 4:36:42 AM UTC+5:30, Diamond Dave wrote:
>
> I have a situation where I down load data and delineate results leaving
> a nam
Hi Priyanka,
PFA
Thanks
Ashish
On 23 March 2014 17:35, Priyanka Sachdeva wrote:
> Thanks Abhishek,
>
> Yes, I did see the formula. Never knew it would be that straight forward
>
> Will give it a try and keep you posted. Really appreciate the help !
>
>
>
> Regards
ote:
>>
>>> Dear Deepak,
>>>
>>> thanks for your great help... it would be working so great...
>>>
>>> but i was found a small problem from Output 2 here i am getting positive
>>> values twice
>>>
>>> and for output 1
l 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" gr
roup, 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
OK, I got it, Thank you very much Mr.Ravinderji.
On Wed, Mar 19, 2014 at 2:33 PM, Ravinder wrote:
> Pfa… put correct formula for B4 and B5 in vba code….
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Ashish Bhalara
&
ubmit my project
today.. please help
Am using excel 2007.
On 17-Mar-2014 12:24 PM, "ashish koul" wrote:
> which version of excel r u using
>
>
> On Mon, Mar 17, 2014 at 12:22 PM, Prabhu Pinky wrote:
>
>> Guys...pls help with my query
>> On 17-Mar-2014
>
> 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 g
/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 ti
; 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
> "
then try left and find function combined
On Sun, Mar 16, 2014 at 1:02 AM, Indrajit $nai wrote:
> Yes Ashish...
>
>
> On Sat, Mar 15, 2014 at 3:39 PM, ashish koul wrote:
>
>> is ACT common in all
>>
>>
>> On Wed, Mar 12, 2014 at 4:45 PM, Indrajit $nai
use this function
http://support.microsoft.com/KB/213360
http://www.yogeshguptaonline.com/2009/07/excel-functions-convert-numbers-into.html
Regards
Ashish
On Sat, Mar 15, 2014 at 7:42 PM, irshad khan wrote:
> Hi Team,
>
> Is it possible to convert numeric value to alpha value.
&g
cel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
--
*Regards*
*Ashish Koul*
*Visit*
http://www.excelvbamacros.in
Like Us on
Facebook<http://www.facebook.com/pages/Excel-VBA-Code
sage 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
el-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
--
*Regards*
*Ashish Koul*
*Visit*
http://www.excelvbamacros.in
Like Us on
Facebook<http://www.facebook.com/pages/Excel-VBA-
p.
> 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 opt
check
chandoo.org
http://office.microsoft.com/en-in/templates/dashboard-TC101915534.aspx
http://www.skilledup.com/learn/business-entrepreneurship/best-free-excel-templates-dashboards/
On Thu, Mar 13, 2014 at 11:50 AM, Soum wrote:
> Dear Ashish,
>
>
>
>Could
mp; rowno).Value
.Range("C21").Value = Sheets("Sheet1").Range("C" & rowno).Value
End With
End Sub
On Mon, Mar 10, 2014 at 2:22 PM, Leo Ruphen wrote:
> Hi ashish,
>
> I dont have any outputs to provide. but i have explained it all in the
> wor
t; but when i insert a hyperlink in the principal worksheet (pasta1), the
>>> other doesn't updates.
>>> Thanks for your help!
>>>
>>>
>>>
>>> *Att. Caroline Campos (21) 8102-4893 <%2821%29%208102-4893>*
>>>
>>> *Preser
g 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 n
Can u share how output will look like
Sent on my BlackBerry(R) from Vodafone
-Original Message-
From: ashish koul
Date: Sun, 9 Mar 2014 22:42:50
To: excel-macros
Subject: Re: $$Excel-Macros$$ Excel Forum available @ discussexcel.com
which row you want to pick how r u going to decide
which row you want to pick how r u going to decide that
On Sun, Mar 9, 2014 at 1:26 PM, Leo Ruphen wrote:
> Hi Ashish,
>
> Thanks for the prompt reply, But i have few columns to be copied to the
> invoice.
> Please refer attachment for more details
>
> Thanks and Regards
oss.
> ---
> 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,
XCEL 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/ex
ead 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 reg
oglegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
--
*Regards*
*Ashish Koul*
*Visit*
http://www.excelvbamacros.in
Like Us on
Facebook<http://www.facebook.com/pages/Excel-VBA-Co
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 and Regards, Rp.
>
> --
> Are you =EXP(E:RT) o
Hi Rupesh, then go with abhishek's formula.
Thanks
Ashish
On 7 March 2014 12:19, Rupesh Patil wrote:
> Thanks your quick reply, but I want cut last 6 characters from column 'A'
> and paste it to column"B"
>
>
> On Fri, Mar 7, 2014 at 12:08 PM, Abhish
Hi Rupesh,
PFA
Thanks
Ashish
On 7 March 2014 11:57, Rupesh Patil wrote:
> Hi Expert,
>
> Please find file in attachment
> --
> Thanks and Regards, Rp.
>
> --
> 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)
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, v
try ths
Sub test()
Dim CL As Range
Dim i As Long
For Each CL In Range("fRUITS")
ActiveSheet.Range("c5").Value = CL.Value
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF,
Filename:="C:\Documents and Settings\Ashish Koul\My Documents\"
Sub test()
Dim myarray As Variant
Dim i As Long
myarray = Array("Apple", "Orange", "Peer")
For i = LBound(myarray) To UBound(myarray)
ActiveSheet.Range("c5").Value = myarray(i)
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF,
Filename:=&
eiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out
Hi Ravinder Sir,
OWSOME..!!!
On 28 February 2014 15:33, Ravinder wrote:
> PFA.
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *amar takale
> *Sent:* Friday, February 28, 2014 3:18 PM
> *To:* excel-macros@googlegroups.com
> *Subject:
Dear Sir,
Query is resolved. no action required.
specially thanks to ravinder sir.
Thanks
Ashish
On 27 February 2014 18:54, Ashish Kumar wrote:
> Hi Ravinder Sir,
>
> If we want the same output for Subjective like MCQ then what to do for
> getting the same output in F column
Hi Ravinder Sir,
If we want the same output for Subjective like MCQ then what to do for
getting the same output in F column.
kindly advise.
Thanks
Ashish
On 27 February 2014 14:46, Ravinder wrote:
> PFA, first select range (already selected ) of data then click on button
>
>
Need your help to resolve this.
Thanks
Ashish
On 27 February 2014 16:22, Ravinder wrote:
> Thanks
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Ashish Kumar
> *Sent:* Thursday, February 27, 2014 4:21 PM
> *To:* e
Dear Ravinder Sir,
Sheet is Working perfect.
Thanks a lot for your valuable support. Genius !!!
Thanks
Ashish
On 27 February 2014 14:46, Ravinder wrote:
> PFA, first select range (already selected ) of data then click on button
>
>
>
> *From:* excel-macros@googlegro
Dear Seniors,
Any updates on the same. kindly reply
Thanks
Ashish
On 27 February 2014 13:16, Ashish Kumar wrote:
> Dear All,
>
> I want do changes in Coloumn F (Sheet 2) like example below mentioned in.
> I want extract the (a) option (b) option C, d Continuesly from the data
ownloadToFile(0, URL, LocalFilename, 0, 0)
If lngRetVal = 0 Then DownloadFile = True
End Function
Sub downfile()
'http://www.cpearson.com/excel/downloadfile.aspx
Dim sURLAs String
Dim LocalFilename As String
Dim filename As String
Const UNC = "C:\Documents and Setti
ers 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+unsub
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@goo
it https://groups.google.com/groups/opt_out.
>>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
>
ng emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
--
*Regard
d 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
>>
try this link
http://oco-carbon.com/2012/03/06/google-excel-distance-function/
On Tue, Feb 18, 2014 at 8:32 PM, Greg Hart wrote:
> Ashish - thank you for posting. I receive a #value! error in the distance
> field. I am using Excel 2013, any assistance is greatly appreciated.
&g
s.
> ---
> 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,
subscribe 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
ooglegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
--
Regards.
Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessary. Spread
environmental üawareness.♣♣♣*
--
s.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
--
*Regards*
*Ashish Koul*
*Visit*
http://www.excelvbamacros.in
Like Us on
Facebook<http://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897&
L 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-mac
rs 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
Hi Ahmed,
PFA..!!!
Thanks
Ashish
On 13 February 2014 20:15, Ahmed Honest wrote:
> Dear All,
>
> Please see below and kindly help.
>
> Requirement : How to get no. of years, months and Dates between 2 dates.
>
> Example :
> Start date : 1-Oct-2012 suppose in cell
u 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-macr
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
--
*Regards*
*Ashish Koul*
*Visit*
http://www.excelvbamacros.in
Like Us
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 t
j)
Sheets("Output").Range("f" & k) = Cells(i, j).Text
Sheets("Output").Range("e" & k) = Cells(1, s)
Sheets("Output").Range("g" & k) = Cells(i, s).Text
k = k + 1
Next
Next
You will not find customised code as per your requirement anywhere. You
have to make changes on your own.
The above link will tell you how to zip one file and then combine it with
mail macro to send that file
Regards
Ashsh
On Thu, Feb 6, 2014 at 5:39 PM, Atul Kesaria wrote:
> Hi Ash
To move outlook mails
http://msdn.microsoft.com/en-us/library/office/aa220127(v=office.11).aspx
On Fri, Feb 7, 2014 at 1:44 AM, Ankit Mehra wrote:
> Hi Ashish,
>
> Thank you for your response. I have been able to write a macro which will
> copy table information from outlook m
hi
You can do it by automating the below
http://msdn.microsoft.com/en-us/library/ff701717.aspx
or
https://developers.google.com/maps/documentation/distancematrix/
but you need to purchase API key
Regards,
Ashish
On Fri, Feb 7, 2014 at 12:41 AM, wrote:
> Hello,
>
> What I'
Hi Ankit
Save the outlook mail as word document and then open the document and copy
content and paste it in excel
You need to automate above steps
Sent on my BlackBerry(R) from Vodafone
-Original Message-
From: Ankit Mehra
Sender: excel-macros@googlegroups.com
Date: Thu, 6 Feb 2014 16
try this code
http://www.rondebruin.nl/win/s1/outlook/amail1.htm
On Wed, Feb 5, 2014 at 12:57 PM, Lakshman P <305laksh...@gmail.com> wrote:
> Plz find the attached
>
> My excel file location is "E:\Lakshman\REPORT_OF_GAUR_CITY_2.xlsx"
>
>
>
>
>
>
check this
http://www.rondebruin.nl/win/s7/win001.htm
http://www.rondebruin.nl/win/section7.htm
On Tue, Feb 4, 2014 at 8:31 PM, Atul Kesaria wrote:
> Hi Ashish,
>
> One more help to earlier macro. Is there a way we can put password to the
> PDF file or make a zip file of respect
you need to add if condition here
if Cells(i, s).value <> 0 then
Sheets("Output").Range("g" & k) = Cells(i, s).text
end if
On Mon, Feb 3, 2014 at 6:28 PM, Umesh Kumar wrote:
> Hi Ashish,
> Thanks a lot for the code, it worked well. It saved lot of my tim
try this
Set Mailrng = Sheets("Sheet1").Range("c2:c" &
Sheets("Sheet1").Range("c1").End(xlDown).Row)
On Mon, Feb 3, 2014 at 12:28 AM, Atul Kesaria wrote:
> Hi Ashish,
>
> You are rockstar. Just one last help. Can the range be set a dynami
401 - 500 of 2224 matches
Mail list logo
