Hi Team,
Problem Statement - I have an excel with multiple rows which contains data
of employee-wise rent paid details for a date range. I need to split data
in such a way that employee-wise monthly rent paid details are available.
Please help.
Regards
Atul
--
Are you =EXP(E:RT) or
Hi Team,
Just wanted to check if you have found any solution.
Regards
Atuk
On Wed, Apr 27, 2016 at 10:35 PM, Atul Kesaria <atul.kesa...@gmail.com>
wrote:
> Hello Team,
>
> I need a help to fit in a formula to find if there are any overlapping
> dates for multiple date
Hello Team,
I need a help to fit in a formula to find if there are any overlapping
dates for multiple date range. Please note that column can increase or
decrease.
Attached is the sample spreadsheet.
Thanking in advance.
Regards
Atul
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do
Hi Team,
Can you help me to fix this small thing.
Regards
Atul
On Sun, Mar 9, 2014 at 7:04 PM, Atul Kesaria atul.kesa...@gmail.com wrote:
Hi Team,
Thanks for the help. However just found one bug in macro. If the status is
N in the AE column then the macro stops at that row and does
mr.exce...@gmail.com wrote:
Hi Atul,
PFA...
Thanks regards,
www.MrExcel4U.com http://mrexcel4u.blogspot.com/
On Mon, Feb 17, 2014 at 1:15 PM, Atul Kesaria atul.kesa...@gmail.comwrote:
Hi Team,
Can some one help.
Regards
Atul
On Wed, Feb 12, 2014 at 1:46 PM, Atul Kesaria
Hi Team,
Can some one help.
Regards
Atul
On Wed, Feb 12, 2014 at 1:46 PM, Atul Kesaria atul.kesa...@gmail.comwrote:
Hi Team,
I need a help in creating a macro for attached sheet
Process Brief:-
1) Need to send email to people based of status as per column AE. If
status is Y: then mail
Hi Team,
I need a help in creating a macro for attached sheet
Process Brief:-
1) Need to send email to people based of status as per column AE. If status
is Y: then mail should be send to people as per email ID To CC and
attachement should be done based on file name in column AB, AC AD.
2) If
/win001.htm
http://www.rondebruin.nl/win/section7.htm
On Tue, Feb 4, 2014 at 8:31 PM, Atul Kesaria atul.kesa...@gmail.comwrote:
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 respective pdf file with a password
On Mon, Feb 3, 2014 at 1:25 PM, Atul Kesaria atul.kesa...@gmail.com wrote:
Thanks Ashishreally helpfull...
On Mon, Feb 3, 2014 at 10:50 AM, ashish koul koul.ash...@gmail.comwrote:
try this
Set Mailrng = Sheets(Sheet1).Range(c2:c
Sheets(Sheet1).Range(c1).End(xlDown).Row)
On Mon
Hi Team,
Any luck of my earlier mail.
Regards
Atul
On Sat, Feb 1, 2014 at 10:34 PM, Atul Kesaria atul.kesa...@gmail.comwrote:
Hi
PFA fileplease note that the attachment which need to go with each
mail would be a PDF file.
On Sat, Feb 1, 2014 at 10:33 PM, Atul Kesaria atul.kesa
problem\ flname .XLSX
.display 'or use .send
End With
On Error GoTo 0
Set OutMail = Nothing
Set OutApp = Nothing
End Sub
On Sun, Feb 2, 2014 at 6:23 PM, Atul Kesaria atul.kesa...@gmail.comwrote:
Hi Team,
Any luck of my earlier mail.
Regards
Atul
On Sat, Feb 1, 2014 at 10:34 PM, Atul
Thanks Ashishreally helpfull...
On Mon, Feb 3, 2014 at 10:50 AM, ashish koul koul.ash...@gmail.com wrote:
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 atul.kesa...@gmail.comwrote:
Hi Ashish
PFA
On Sat, Feb 1, 2014 at 7:45 PM, ashish koul koul.ash...@gmail.com wrote:
please share a sample file
On Sat, Feb 1, 2014 at 5:19 PM, Atul Kesaria atul.kesa...@gmail.comwrote:
Hi Team,
I need a help in getting a macro which will help sending email with
attachment to list of person
Hi
PFA fileplease note that the attachment which need to go with each mail
would be a PDF file.
On Sat, Feb 1, 2014 at 10:33 PM, Atul Kesaria atul.kesa...@gmail.comwrote:
PFA
On Sat, Feb 1, 2014 at 7:45 PM, ashish koul koul.ash...@gmail.com wrote:
please share a sample file
On Sat
:
http://www.timeatlas.com/5_minute_tips/chunkers/mail_merge_tutorial_using_microsoft_word_and_excel#.Ubcqfvn7AqI
Thanks
On Tue, Jun 11, 2013 at 7:15 PM, VBA VABZ v...@vabs.in wrote:
Hi,
Why you need output in word?
On Tue, Jun 11, 2013 at 7:09 PM, Atul Kesaria atul.kesa...@gmail.comwrote
Hello Team,
I need a macro which can send multiple file to individual person.
For eg. If 1 folder has files basis name of person for year 1
2 folder has files basis name of peron for Year 2
then macro should send both this files.
Please help.
Thanks and Regards
Atul Kesaria
Hello Team,
I am preparing chart basis certain data. However wanted to check some
way to prepare the chart only on the data which reflect in the excel
sheet post i do a filter. So as soon as I change the filter the chart
should change.
Do let me know if that can be done.
Cheers
Atul
--
you will apply filter in Pivot table it will Show Only Filter Summary
Data,
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Atul Kesaria
Sent: Thursday, July 07, 2011 1:18 PM
To: excel-macros@googlegroups.com
Subject: Re
and Regards
Atul Kesaria
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid
Hello Team,
I am using macro for mail merge and wanna know how to make changes in font
type and how to bold a particular line/word while doing mail merge.
Can you please help me.
Thanks and Regards
Atul Kesaria
Hello Team,
I am using macro for mail merge and wanna know how to make changes in font
type and how to bold a particular line/word while doing mail merge.
Can you please help me.
Thanks and Regards
Atul Kesaria
Hello Team,
Please help me.
Thanks and Regards
Atul Kesaria
On Fri, May 21, 2010 at 9:35 AM, Atul Kesaria atul.kesa...@gmail.comwrote:
Hello Team,
I am using macro for mail merge and wanna know how to make changes in font
type and how to bold a particular line/word while doing mail merge
Hello Team,
I am using macro for mail merge and wanna know how to make changes in font
type and how to bold a particular line/word while doing mail merge
Thanks and Regards
Atul Kesaria
On Wed, May 12, 2010 at 11:18 PM, Harpreet Singh Gujral
harpreetguj...@gmail.com wrote:
FYI
Hello Team,
Can some one please help me.
Thanks and Regards
Atul Kesaria
On Sun, May 9, 2010 at 6:20 PM, Atul Kesaria atul.kesa...@gmail.com wrote:
Hello Andy,
I can use mail merge, but thats a manual process and I want to use
different format for for preparing letters which might go above
forwad for the help.
Thanks and Regards
Atul Kesaria
On 5/7/10, Aindril De aind...@gmail.com wrote:
Hi atul,
Why dont u use mail merge.
Regards,
Andy
On Fri, May 7, 2010 at 12:38 PM, Atul Kesaria atul.kesa...@gmail.comwrote:
Hello Team,
I am looking at a macro to write letter in word
Hello Team,
I am looking at a macro to write letter in word (a predefine letter format)
with certain field to be picked from an excel-sheet source.
Request you to send me macro code.
Thanks and Regards
Atul Kesaria
Hello Suresh,
Please find the attached sheet, hope this is what you are looking for.
Thanks and Regards
Atul Kesaria
On Thu, Jul 16, 2009 at 1:29 PM, Ayushj jainayus...@gmail.com wrote:
Dear Members,
Can anyone assist Suresh on his query ?
Thank you.
On Jul 16, 12:57 pm, suresh k
Sorry, Please find the revised file
On Thu, Jul 16, 2009 at 2:27 PM, Atul Kesaria atul.kesa...@gmail.comwrote:
Hello Suresh,
Please find the attached sheet, hope this is what you are looking for.
Thanks and Regards
Atul Kesaria
On Thu, Jul 16, 2009 at 1:29 PM, Ayushj jainayus
Hello Ashish,
Can you help me to do the same in office 2007. new to 2007 hence need help.
Thanks and Regards
Atul Kesaria
On Tue, Jul 7, 2009 at 11:45 AM, Ashish Pradhan ashlyprad...@gmail.comwrote:
Hi All
Not sending this tip in the best tip for the week format as this is not
my original
Hello Venkat,
Can you provide me with the excel sheet? Or against correponding code in
second sheet. Apply formula =SUMIF('Sheet1'!(range of your data)'(code name
cell number)
Thanks and Regards
Atul Kesaria
On Wed, May 27, 2009 at 9:19 AM, venkat sudhakar sudhakar...@gmail.comwrote:
Dear
Hello Dave,
One small issue in the macro, the cell number b2 in the formula remain
the same across all the row when we run the macro, however it should changes
as the row changes.
Please help.
Thanks and Regards
Atul Kesaria
On Wed, May 27, 2009 at 11:11 AM, Atul Kesaria atul.kesa
to write a macro. Two things
that i am unable to add. 1 )The macro should able to apply the formula till
the last line
2) It should copy and paste special value all the formula applied.
Thanking you once again in advance.
Thanks and Regards
Atul Kesaria
On Tue, May 26, 2009 at 2:47 PM, Dave Bonallack
))
The number of rows are not fixed and hence the macro should be able to run
till the last record in that coloumn.
It would be great if some one can provide me with a macro for the same.
Thanks and Regards
Atul Kesaria
))
The number of rows are not fixed and hence the macro should be able to run
till the last record in that coloumn.
It would be great if some one can provide me with a macro for the same.
Thanks and Regards
Atul Kesaria
Lavprasad Kori- If you add trim function for the name it would remove any
additional unwanted space
On Mon, Apr 13, 2009 at 7:42 PM, Harmeet Singh harmeet.hew...@gmail.comwrote:
attached file has the solution
assuming that ID will be of 5 digits only
On Mon, Apr 13, 2009 at 5:24 PM,
35 matches
Mail list logo