Hi all,
Need help on this.
Regards,
Ankit
On Thu, Oct 18, 2012 at 5:21 PM, Ankit Agrawal
ankit.agrawal...@gmail.comwrote:
Hi Haseeb,
Thanks for your mail. this is really help me. but I have some point which
can make it more effective and efficient.
- Department code will be written
to write it twice and more time.
Except above point sheet and process is really good and helpful to me
Regards,
Ankit
On Mon, Oct 15, 2012 at 12:21 PM, Ankit Agrawal
ankit.agrawal...@gmail.comwrote:
Dear All,
I have a salary sheets where there are three column i.e. Name, Department
and salary
Dear All,
I have a salary sheets where there are three column i.e. Name, Department
and salary. I need department wise salary sheet but there is one
issue.there are lots of employees whose salary is going in more then 1
department so I am confused how I bind up my salary. I mentioned my method
in
Hi All,
Can it be possible or I have to do same process which I am doing.
Regards,
Ankit
On Mon, Oct 15, 2012 at 12:21 PM, Ankit Agrawal
ankit.agrawal...@gmail.comwrote:
Dear All,
I have a salary sheets where there are three column i.e. Name, Department
and salary. I need department wise
HI,
My name is Ankit Agrawal, I'm from New Delhi. Working as Asst A/c manager
with a SS Kothari Mehta Co.
Apart from my work, I like to travel, music.
Excel plays major supportive role in accounting and reporting.
I am really happy to be a part of this forum.
Thank you Ayush Ji.
Regards,
Ankit
Hi,
I need some budget template. Please share some budget template.
Regards,
Ankit
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
Deal All,
I need your help on the same.
Any Confusion plz let me know.
Regards,
Ankit
On Fri, May 4, 2012 at 2:00 PM, Ankit Agrawal ankit.agrawal...@gmail.comwrote:
Dear all,
I have some data in one sheet and I have to generate report which format
is also on second sheet. How can we
Congratulation Rajan and other excel's mentors.
Regards,
Ankit
On Wed, May 2, 2012 at 9:30 PM, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Rajan Verma has been selected as 'Most Helpful Member' for the month of
April'2012
He has posted 185 posts in April 2012 and helped many
Dear Sirs,
I have query, plz solve it.
Regards,
Ankit
--
FORUM RULES (986+ members already BANNED for violation)
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
://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
On Thu, Feb 23, 2012 at 6:22 PM, Ankit Agrawal ankit.agrawal...@gmail.com
wrote:
Dear Sirs,
I have query, plz solve it.
Regards,
Ankit
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles
HI Ayush,
I think, Mr. Noorain has already achieved this. I do not sure about the
month but indeed, he has achieved it
On Wed, Feb 1, 2012 at 10:11 PM, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Noorain Ansari has been selected as 'Most Helpful Member' for the month of
Jan'12
[?][?][?][?]Congratulation [?] Sir[?][?][?][?]
On Wed, Feb 1, 2012 at 10:11 PM, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Noorain Ansari has been selected as 'Most Helpful Member' for the month of
Jan'12
He has posted 175 posts in Jan'12 and helped many people through
Dear All,
I need financial analysis tools file plz send me.
Regards,
Ankit
--
FORUM RULES (986+ members already BANNED for violation)
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
.asp
On Tue, Jan 17, 2012 at 4:47 PM, Ankit Agrawal ankit.agrawal...@gmail.com
wrote:
Dear All,
I need financial analysis tools file plz send me.
Regards,
Ankit
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
Dear All,
Please suggest me any Business Financial analyst or related group.
Thanks
Regards,
Ankit
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and
Thank you boss!!
On Tue, Dec 20, 2011 at 11:53 PM, Haseeb Avarakkan
haseeb.avarak...@gmail.com wrote:
Hello Ankit,
Another way. See the attached.
___
HTH, Haseeb
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread
://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/
On Tue, Dec 20, 2011 at 1:09 PM, Ankit Agrawal ankit.agrawal...@gmail.com
wrote:
Dear All,
Could we use drop down function using if condition.
Example is attached
Regards
Dear All,
I need financial excel tool for analysis of different situation.
You are requested to send me this kind of sheet.
Regards,
Ankit
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need
Dear All,
Could we use drop down function using if condition.
Example is attached
Regards.
Ankit
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and
, b).Select
Application.ScreenUpdating = False
End If
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message- From: Ankit Agrawal
Sent: Saturday, December 10, 2011 9:54 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help in preparing
on daily basis
Suppose I put this formula =IF(I17=,,TODAY()) then it will change
on daily basis.
Regards,
Ankit
On Sun, Dec 11, 2011 at 9:24 AM, Ankit Agrawal
ankit.agrawal...@gmail.comwrote:
Dear Sir,
I had some confusion regarding my sheet now it has been clear.Please
find my new
Dear Sir,
I need manual input.
Regards,
Ankit
On Mon, Dec 12, 2011 at 9:21 PM, Maries talk2mar...@gmail.com wrote:
Hi Ankit,
Please confirm whether you want it by Auto number or manual input.
Regards,
MARIES.
On Sun, Dec 11, 2011 at 8:15 AM, Ankit Agrawal ankit.agrawal...@gmail.com
Dear Expert,
Here I am trying to make a some Text box control button in excel,I have
made four Text Boxes one Button.
Step 1 :Text Box 1 contain a No. which have to be searched in column A
find out the row.
Step 2 :Text Box 2 contain a value which should be come in column K
Step 3 :Text Box 3
hope this will help you.
Regards,
MARIES.
On Sat, Dec 10, 2011 at 1:15 PM, Ankit Agrawal
ankit.agrawal...@gmail.comwrote:
Dear Expert,
Here I am trying to make a some Text box control button in excel,I have
made four Text Boxes one Button.
Step 1 :Text Box 1 contain a No. which have
Dear experts,
I Need finance related MIS its tutorial.Also need your valeable
suggestion,How we improve our Finance MIS reports.
Please send me who ever having it.
Regards,
Ankit
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread
Dear Expert,
Please help me to solve out query in attached excel.
Here one excel file where I want to do some column automatically.
Regards,
Ankit
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent,
as col B using DV
col I. “agreement sheet” ?
col J. populated on what__occurring.
Don Guillett
SalesAid Software
dguille...@gmail.com
*From:* Ankit Agrawal ankit.agrawal...@gmail.com
*Sent:* Friday, December 09, 2011 8:40 AM
*To:* excel-macros excel-macros@googlegroups.com
*Subject
Congratulations Sam... Keep impetus on...!!!
On Mon, Dec 5, 2011 at 4:35 AM, Haseeb Avarakkan haseeb.avarak...@gmail.com
wrote:
Congratulations Sam... Keep up the excellency!
Hello Lali,
FYI: Please read the forum rules. Rule# 2 says, *Don't post a question
in the thread of another
29, 2011 at 12:56 AM, Aamir Shahzad aamirshahza...@gmail.comwrote:
how to recall this add-inn in working sheet.
Regards,
Aamir Shahzad
On Mon, Nov 28, 2011 at 11:41 AM, Ankit Agrawal
ankit.agrawal...@gmail.com wrote:
Hi Harsh,
Use attached add-inn.
Regards,
Ankit
On Mon, Nov 28
Dear All,
Plz tell me any good institute for excel where I can learn advance excel.
Regards,
Ankit
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and
I am in Delhi(Near Laxmi Nagar Noida)
On Thu, Nov 24, 2011 at 12:22 PM, krishnanm2...@gmail.com wrote:
**
Where are you located??
Sent on my BlackBerry® from Vodafone
--
*From: * Ankit Agrawal ankit.agrawal...@gmail.com
*Sender: * excel-macros@googlegroups.com
of the *Ref_text* reference.
This can be either :
- True - to denote that the reference is in A1 style
- False - to denote that the reference is in R1C1 style
If this argument is omitted, it takes on the default value True
--
On Fri, Nov 18, 2011 at 12:54 PM, Ankit Agrawal
Hi,
Plz tell me what is the use of indirect function what it can do?
Regards,
Ankit
On Tue, Nov 15, 2011 at 2:49 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Smitha,
Please find see attached sheet with example of below formula.
--
Thanks regards,
Noorain Ansari
Hi Expert,
Plz give me any formula for diff in string
example-
If cell A1 contain Ashish B1 contain Ashish
we want to diff in A1 B1 then how we can formulate it
Thanks Regards,
Ankit
--
FORUM RULES (925+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor
...@gmail.com
*From:* Ankit Agrawal ankit.agrawal...@gmail.com
*Sent:* Thursday, November 03, 2011 1:45 AM
*To:* excel-macros excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ formula for diff. in string
Hi Expert,
Plz give me any formula for diff in string
example-
If cell A1 contain
Dear Expert,
Plz solve out attached query.
Regards,
Ankit
--
--
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
Hi Noorain,
Could you plz make me understand how has it been done?
Thanks
Regards,
Ankit
On Mon, Oct 17, 2011 at 5:27 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Surya,
Please see attached sheet
--
Thanks regards,
Noorain Ansari
Dear Sirs,
Please provide me sumproduct functions sheet which having different example
in it.
@Noorain Ansari sir, Looking your help also.
Thanks Regards,
Ankit
--
--
Some important links for excel users:
1.
Congrats Noorain. You deserved it..
On Fri, Oct 14, 2011 at 11:40 AM, Subhash Yadav scy2...@gmail.com wrote:
Congratulations Noorain...
Thanks for your helps provided..
Regards,
Subhash Yadav
On Thu, Oct 13, 2011 at 8:51 PM, Dilip Pandey dilipan...@gmail.comwrote:
Congratulations
on the selected cells
[*Alt]+[U] *
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/*
http://noorain-ansari.blogspot.com/
On Wed, Oct 12, 2011 at 12:49 PM, Ankit Agrawal
ankit.agrawal
--
--
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=1871310
3. Excel
Dear All,
could anyone have formula sheet with its illustration. I need it
Thanks
Regards,
Ankit
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Dear All,
I need shortcut key for all border.plz help me.
Regards,
Ankit
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our
Hi,
How can I insert one Header footer for entire workbook.
Regards,
Ankit
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/
On Wed, Oct 12, 2011 at 12:49 PM, Ankit Agrawal
ankit.agrawal...@gmail.com wrote:
Dear All,
I need shortcut key for all border.plz help me
://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/
On Wed, Oct 12, 2011 at 3:17 PM, Ankit Agrawal ankit.agrawal...@gmail.com
wrote:
Hi,
How can I insert one Header footer for entire workbook.
Regards,
Ankit
-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/
On Fri, Sep 23, 2011 at 10:42 AM, Ankit Agrawal
ankit.agrawal...@gmail.com wrote:
Dear All,
I want to show a messge when we enter value which is more than 50k.As we
type 6 at that time a message show approval need.
Could it possible
Dear Sir,
It is not working.and plz tell how we can apply it on other sheet too.
Regards,
Ankit
On Fri, Sep 23, 2011 at 3:55 PM, §»VIPER«§ viper@gmail.com wrote:
of course
pfa
--
*Great day,*
*viper
*
On Fri, Sep 23, 2011 at 10:42 AM, Ankit Agrawal
ankit.agrawal
Dear Sir,
This is not working plz tell me how we can do it another files.
Regards,
Ankit
On Fri, Sep 23, 2011 at 3:55 PM, §»VIPER«§ viper@gmail.com wrote:
of course
pfa
--
*Great day,*
*viper
*
On Fri, Sep 23, 2011 at 10:42 AM, Ankit Agrawal
ankit.agrawal...@gmail.com
Dear Sir,
Please give me any update.
Regards,
Ankit
On Wed, Apr 27, 2011 at 6:07 PM, Ankit Agrawal
ankit.agrawal...@gmail.comwrote:
Dear All,
I really appriciate your valuable help.you all are really ameging peson.
I have two different sheets.First is used for giving the PO/SOW(Statement
in
that folder.
Pl note folder name is Payslips and not payslip.
The location and name of folder can be also changed by editing cell in red
colour on sheet Form which contains C:/payslips.
Please revert.
Sent on my BlackBerry® from Vodafone
--
*From: * Ankit Agrawal
Again a recommendation, if it is transfer in to the PDF with password.can it
possible.
Regards,
Ankit
On Mon, Nov 29, 2010 at 11:19 AM, Ankit Agrawal
ankit.agrawal...@gmail.comwrote:
thank you sir,
Its done dana done.
On Sun, Nov 28, 2010 at 11:12 AM, in.vaib...@gmail.com wrote:
Dear
: * Ankit Agrawal ankit.agrawal...@gmail.com
*Sender: * excel-macros@googlegroups.com
*Date: *Tue, 16 Nov 2010 18:53:55 +0530
*To: *excel-macros@googlegroups.com
*ReplyTo: * excel-macros@googlegroups.com
*Subject: *$$Excel-Macros$$ Salary sending problem
Hello Sir,
I have a problem related
the instruction sheet. If format and everything is OK then I will
work for your other requirement.
Pl note that I will able to generate password protected XLS file.
Please revert for help.
Sent on my BlackBerry® from Vodafone
--
*From: * Ankit Agrawal ankit.agrawal
Dear All,
I did not get any solution from your side so it mean it does not have
solution or no body knows about it.
at least any body can give any suggestion on it
On Tue, Nov 16, 2010 at 6:53 PM, Ankit Agrawal
ankit.agrawal...@gmail.comwrote:
Hello Sir,
I have a problem related to mail
Hello Sir,
I have a problem related to mail through excel. basically I have to make
salary slip. and forward it to the employees. I manage the data into the
excel and use mail merge in MS word. now the problem is, I have to make
separate file for each employee and have to send one by one on their
Hello Sir,
I have a problem related to mail through excel. basically I have to make
salary slip. and forward it to the employees. I manage the data into the
excel and use mail merge in MS word. now the problem is, I have to make
separate file for each employee and have to send one by one on their
Hi all,
Please send me shortcut keys file of excel. I need it
Thanks regards
Ankit
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
Thank you sir for deteil knowledge but again same problem *how we can use
add-in? plz tell me *
**
Thnanks Regards
Ankit
On Tue, Oct 5, 2010 at 8:30 AM, P.VIJAYKUMAR vijay.4...@gmail.com wrote:
Dear Ankit,
There is no Direct formula to convert numbers into text.But there are some
add-ins
. In this
way you can have both the number and also you converted text.Hope this
clarifies your doubt.
Regards,
Vijaykumar
On Tue, Oct 5, 2010 at 11:38 AM, Ankit Agrawal ankit.agrawal...@gmail.com
wrote:
Thank you sir for deteil knowledge but again same problem *how we can use
add-in? plz
But Sir there are more than hundred employee than how we can make only
single sheet
On Tue, Oct 5, 2010 at 1:04 PM, prabhakar jain prabhakar.kj...@gmail.comwrote:
you can attach your excel salary sheet with salary slip through vlookup and
copy that slip on mail.
sending you a sample sheet
://support.microsoft.com/kb/213360Hope it serve the purpose.
On Mon, Oct 4, 2010 at 9:22 AM, Ankit Agrawal
ankit.agrawal...@gmail.comwrote:
Hello Sir,
Plz tell me any formula that convert number to text like
1500/-
one thousand five hundered only
Thanks Regards,
Ankit
I have add it But How to use it.
thanks regards,
ankit
On Mon, Oct 4, 2010 at 4:40 PM, Ankit Agrawal ankit.agrawal...@gmail.comwrote:
But sir how it add in to excel.
Thanks Regards
On Mon, Oct 4, 2010 at 1:35 PM, Mahesh mahender.bi...@gmail.com wrote:
Hi ankit,
Attached herewith
Hello Sir,
I have a problem related to mail through excel. basically I have to make
salary slip. and forward it to the employees. I manage the data into the
excel and do mail merge in MS word. now the problem is start, I have to make
saperately file for the each employee and have to send one by
But sir how it add in to excel.
Thanks Regards
On Mon, Oct 4, 2010 at 1:35 PM, Mahesh mahender.bi...@gmail.com wrote:
Hi ankit,
Attached herewith is the add in.
hope this will solve the issue.
On Mon, Oct 4, 2010 at 12:04 PM, Ankit Agrawal
ankit.agrawal...@gmail.com wrote:
Thank
But how
Thanks regards
Ankit
On Mon, Oct 4, 2010 at 9:15 PM, krishna mummina lovemekris...@gmail.comwrote:
You may use of macro.
I am not sure about Password for the file, but You can send
automatically to the Concerned person.
--
Hello Sir,
Plz tell me any formula that convert number to text like
1500/-
one thousand five hundered only
Thanks Regards,
Ankit
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks
Hello siti,
thanks for your solution. but i did not get it how it has happened. please
can you brief it.and tell me any solution which may forever in excel.
with regard,
Ankit
--
--
Some important links for excel
.
thanks regards
Ankit Agrawal
On Fri, Aug 27, 2010 at 11:29 AM, C.G.Kumar kumar.bemlmum...@gmail.comwrote:
Could you please attach sample file.
Thanks Regards,
C.G.Kumar
On Fri, Aug 27, 2010 at 10:21 AM, Ankit Agrawal
ankit.agrawal...@gmail.com wrote:
Hello Sir,
I have a data
:48 AM, Ankit Agrawal ankit.agrawal...@gmail.com
wrote:
Hello Sir,
I am newly in the excel. I know only simple excel, But I wanna know about
advance excel. I have hared most Hlook Vlook but how to use i dont know.
so plz tell me what is it, what is the use of it,how it be used. and tell me
I am attaching a sample file, in this file, there are two column one for qty
second one for the rate. I have to separate the qty column in qty its
unit again in rate column.I have written in attach copy what format i
required in the sheet.
thanks regards
Ankit Agrawal
On Fri, Aug 27, 2010
in one column
and kg in second column.
Plz help me in this criteria.
thanks regards
Ankit Agrawal
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com
domain in excel.
Thanks regards
Ankit Agrawal
--
--
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
Hello Sir,
I need help in separate the num alpha value in the one cell into another
two cells.so i am attaching a sample file in it, in sample file I have two
column and having the num and alpha value like 14.300kg or 23.30/kg so on...
and I have to separate these value in two column like 14.300
to separate in unit
name and the price.
plz consider it and tell me.
Thanks to you all.
Ankit Agrawal
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com
(A1).Select
MsgBox (done)
End Sub
On 11 Лип, 20:45, Ankit Agrawal ankit.agrawal...@gmail.com wrote:
hello sir,
I am newly in excel. I need your help. I have two files name a.xls
as.xls.
File a.xls having some data and as.xls having a structure. now problem is
that I want to copy
but i do not know how to use the macros so please suggest me
thank you for your consideration.
with warm regards
Ankit Agrawal
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks
77 matches
Mail list logo