Hi all,
Need help on this.
Regards,
Ankit
On Thu, Oct 18, 2012 at 5:21 PM, Ankit Agrawal
wrote:
> 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
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
wrote:
> Dear All,
>
> I have a salary sheets where there are three column i.e. Name, Department
> and salary. I need dep
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
wrote:
> Dear All,
>
> I have a salary sheets where there are three column i.e. Name, Department
> and salary. I need department wise salary she
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,
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 wil
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.
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 wrote:
> 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 generate it
Congratulation Rajan and other excel's mentors.
Regards,
Ankit
On Wed, May 2, 2012 at 9:30 PM, Ayush Jain 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 people through his
*http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
> On Thu, Feb 23, 2012 at 6:22 PM, Ankit Agrawal > wrote:
>
>> Dear Sirs,
>>
>> I have query, plz solve it.
>>
>> Regards,
>> Ankit
>>
>> --
>> FORUM R
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 may
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 wrote:
> Hello Everyone,
>
> Noorain Ansari has been selected as 'Most Helpful Member' for the month of
> Jan'12
> He has posted 175
[?][?][?][?]Congratulation [?] Sir[?][?][?][?]
On Wed, Feb 1, 2012 at 10:11 PM, Ayush Jain 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 his
> expertise. He
t;
>
> On Tue, Jan 17, 2012 at 4:47 PM, Ankit Agrawal > wrote:
>
>> Dear All,
>>
>> I need financial analysis tools file & plz send me.
>>
>> Regards,
>> Ankit
>>
>> --
>> FORUM RULES (986+ members already BANNED for violatio
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
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. Po
lmacroworld.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 > wrote:
>
>> Dear All,
>>
>> Could we use drop down functio
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 Ne
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 Hel
.ClearContents
> Rows(tr + 1).ClearContents
> 'Cells(tr, "b").Select
>
>
> Application.ScreenUpdating = False
>
> End If
> End Sub
>
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
> -Original Message- From: Ankit Agrawal
Dear Sir,
I need manual input.
Regards,
Ankit
On Mon, Dec 12, 2011 at 9:21 PM, Maries 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 > w
(TODAY) function it change 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
wrote:
> Dear Sir,
>
> I had some confusion regarding my sheet now it has been c
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
ile. i hope this will help you.
>
> Regards,
>
> MARIES.
>
> On Sat, Dec 10, 2011 at 1:15 PM, Ankit Agrawal
> wrote:
>
>> Dear Expert,
>>
>> Here I am trying to make a some Text box & control button in excel,I have
>> made four Text Boxes & on
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 B
col B using DV
> col I. “agreement sheet” ?
> col J. populated on what__occurring.
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Ankit Agrawal
> *Sent:* Friday, December 09, 2011 8:40 AM
> *To:* excel-macros
> *Subject
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,
Congratulations Sam... Keep impetus on...!!!
On Mon, Dec 5, 2011 at 4:35 AM, Haseeb Avarakkan 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 member -- start your own.
it
On Tue, Nov 29, 2011 at 12:56 AM, Aamir Shahzad wrote:
> 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,
>>
>
I am in Delhi(Near Laxmi Nagar & Noida)
On Thu, Nov 24, 2011 at 12:22 PM, wrote:
> **
> Where are you located??
>
> Sent on my BlackBerry® from Vodafone
> ------
> *From: * Ankit Agrawal
> *Sender: * excel-macros@googlegroups.com
> *Date
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 Nee
tional
> logical argument that defines the style 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 def
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 wrote:
> Dear Smitha,
>
> Please find & see attached sheet with example of below formula.
>
>
> --
> Thanks & regards,
> Noorain Ansari
> *http://excelmacroworl
gt; dguille...@gmail.com
>
> *From:* Ankit Agrawal
> *Sent:* Thursday, November 03, 2011 1:45 AM
> *To:* excel-macros
> *Subject:* $$Excel-Macros$$ formula for diff. in string
>
> Hi Expert,
>
> Plz give me any formula for diff in string
>
> example-
>
> If cell A1
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. P
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
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. Foll
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 wrote:
> Dear Surya,
>
> Please see attached sheet
>
>
> --
> Thanks & regards,
> Noorain Ansari
> *http://excelmacroworld.blogspot.com/
Congrats Noorain. You deserved it..
On Fri, Oct 14, 2011 at 11:40 AM, Subhash Yadav wrote:
> Congratulations Noorain...
>
>
> Thanks for your helps provided..
>
> Regards,
>
>
> Subhash Yadav
>
> On Thu, Oct 13, 2011 at 8:51 PM, Dilip Pandey wrote:
>
>> Congratulations NOORAIN.
>>
>> sorry for l
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 :
http://twitter.com/e
--
--
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 tutor
-
>> 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 a
> *[Alt]+[D] *
>
> 10. Toggle the upward diagonal border on the selected cells
> [*Alt]+[U] *
>
> --
> Thanks & regards,
> Noorain Ansari
> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
> *http://noorain-ansari.blogspot.com/* <http:/
nsari
> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>
> On Wed, Oct 12, 2011 at 3:17 PM, Ankit Agrawal > wrote:
>
>> Hi,
10. Toggle the upward diagonal border 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.b
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
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
logspot.com/>
> *http://noorain-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.A
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«§ wrote:
> of course
>
> pfa
>
>
> --
> *Great day,*
> *viper
>
> *
> On Fri, Sep 23, 2011 at 10:42 AM, Ankit Agrawal
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«§ wrote:
> of course
>
> pfa
>
>
> --
> *Great day,*
> *viper
>
> *
> On Fri, Sep 23, 2011 at 10:42 AM, Ankit Agraw
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?
Regards,
Ankit
--
--
Some important links for excel users:
Dear Sir,
Please give me any update.
Regards,
Ankit
On Wed, Apr 27, 2011 at 6:07 PM, Ankit Agrawal
wrote:
> 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
> o
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
wrote:
> thank you sir,
>
> Its done dana done.
>
>
> On Sun, Nov 28, 2010 at 11:12 AM, wrote:
>
>> Dear A
; 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
to generate password protected XLS file.
>>
>> Please revert for help.
>>
>> Sent on my BlackBerry® from Vodafone
>> --
>> *From: * Ankit Agrawal
>> *Sender: * excel-macros@googlegroups.com
>> *Date: *Tue, 16 Nov 2010 18:53:55 +0530
>
e 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
> ------
&
gt;
> Sent on my BlackBerry® from Vodafone
> ------
> *From: * Ankit Agrawal
> *Sender: * excel-macros@googlegroups.com
> *Date: *Mon, 22 Nov 2010 14:16:53 +0530
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *$$Excel-Macros$$ Need Suggestion urgent
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
wrote:
> Hello Sir,
>
> I have a problem related to mail through excel. ba
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
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
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 wrote:
> you can attach your excel salary sheet with salary slip through vlookup and
> copy that slip on mail.
> sending you a sample sheet (EMP CODE IS KEY )
>
> W
ge it into text. 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 > wrote:
>
>> Thank you sir for deteil kn
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 wrote:
> Dear Ankit,
>
> There is no Direct formula to convert numbers into text.But there are some
> add-ins available in th
But how
Thanks & regards
Ankit
On Mon, Oct 4, 2010 at 9:15 PM, krishna mummina wrote:
> You may use of macro.
> I am not sure about Password for the file, but You can send
> automatically to the Concerned person.
>
> --
>
> ---
But sir how it add in to excel.
Thanks & Regards
On Mon, Oct 4, 2010 at 1:35 PM, Mahesh 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>
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 on
I have add it But How to use it.
thanks & regards,
ankit
On Mon, Oct 4, 2010 at 4:40 PM, Ankit Agrawal wrote:
> But sir how it add in to excel.
>
> Thanks & Regards
>
> On Mon, Oct 4, 2010 at 1:35 PM, Mahesh wrote:
>
>> Hi ankit,
>>
>> Attached her
icrosoft.com/kb/213360>Hope it serve the purpose.
>
> On Mon, Oct 4, 2010 at 9:22 AM, Ankit Agrawal
> wrote:
>
>> Hello Sir,
>>
>> Plz tell me any formula that convert number to text like
>>
>> 1500/-
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 us
is the use of it,how it be used. and tell me
>> any simple and advance excel free e-book,which increase my domain in excel.
>>
>> Thanks & regards
>>
>> Ankit Agrawal
>>
>> --
>>
>> --
nit & 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 at 11:29 AM, C.G.Kumar wrote:
>
> Could you please attach sample file.
>
> Thanks & Regards,
&g
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
e my 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 grou
like 14.300 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
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
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
de = False
>Selection.Copy
>Windows("as.xls").Activate
>Columns("E:E").Select
>ActiveSheet.Paste
>Windows("a.xls").Activate
>Columns("H:H").Select
>Application.CutCopyMode = False
>Selection.Copy
>Windows(&
' of a.xls will go on column 'F' of the as.xls
Please consider my problem and give me a solution of it.In my opinion it may
solve by macros but i do not know how to use the macros so please suggest me
thank you for your consideration.
with warm regards
Ankit Agrawal
--
80 matches
Mail list logo