simplest way would be by writing formula
A3= IF(B3<>"", A2+1,"")
place this formula in A3 cell. and drag it till bottom. So, whenever you
enter the value.. it will add number in a3
Regards,
Sarfaraz Ahmed
On Sun, Dec 27, 2009 at 4:28 AM, kvc praveen kumar wrote:
>
i took exams at brainbench.com. This is good.
Regards,
Sarfaraz Ahmed
Microsoft Excel and VBA help <http://findsarfaraz.blogspot.com/>
On Sun, Nov 15, 2009 at 4:40 PM, karthikeyan wrote:
> Hi all,
>
> I am from chennai.If any body knows about online excel certificate
> cour
Use google to search VBA codes. there are lot of website, ebooks, forums and
help available.
Each time you have a task in head, try to VBA to resolve it once and all.
So, each day you learn new things. I learnt it this way..
Regards,
Sarfaraz Ahmed
Microsoft Excel help <h
Hello Ankur,
Take a look at the link I have enclosed below
http://findsarfaraz.blogspot.com/2009/06/remove-password.html
<http://findsarfaraz.blogspot.com/2009/06/remove-password.html>Regards,
Sarfaraz Ahmed
On Sat, Jul 18, 2009 at 12:49 PM, ankur wrote:
>
> hi excel gurus
&
You can try using the file undelete utility which restore the file from fat
table.
Regards,
Sarfaraz Ahmed
MS Excel help <http://findsarfaraz.blogspot.com>
On Tue, Jul 7, 2009 at 9:02 PM, Daniel wrote:
>
> Unfortunately, you can't.
>
> Regards.
>
> Daniel
Hello Vikas,
I tried it didn't gave any error. Please recheck from different computer.
Also, let me know the error message.
Regards,
Sarfaraz Ahmed
*MS Excel help <http://findsarfaraz.blogspot.com>*
On Sun, Jun 28, 2009 at 4:13 PM, Vikas Gupta wrote:
> dear sarfaraj
>
> t
Hey friends,
One ebook from my side as well. I own blog http://findsarfaraz.blogspot.com
http://rapidshare.com/files/240639901/2003_Office_-_-_Mspress_--_Excel_Programming_Inside_Out.rar
Regards,
Sarfaraz Ahmed
On Sat, Jun 27, 2009 at 7:29 PM, Prashant Prajapati <
rsprashant2...@gmail.
Hello,
You try putting
declare dtexpire as date
let dtexpire = 'your macro expiry date'
if dtexpire < = date then
your macro code here
else
msgbox "macro date expired contact developer"
endif
Regards,
Sarfaraz Ahmed
http://findsarfaraz.blogspot.com
On Sun,
Hello Saravanan,
Its not good idea to use NOW() function as it more specifically used to get
time not date and the query is about Date not time.
Regards,
Sarfaraz Ahmed
On Tue, Feb 24, 2009 at 7:16 PM, Saravanan Anna wrote:
> Hai,
>
> Try this
>
> =NOW()-WEEKDAY(NOW(),1)+2
>
t every email id so that it could be
> send to all. How can i do it
>
> pl tell help me -.
>
> regards
>
>
>
> --
> Amit Arora
>
> >
>
--
Thanks with regards,
Sarfaraz Ahmed
--~--~-~--~~~---~--~~
ell displays 23/02/09, retains
>> this value thoughout the week and displays 02/03/09 the following
>> monday
>> thanks
>>
>>
>
>
>
>
> >
>
--
Thanks with regards,
Sarfaraz Ahmed
--~--~-~--~~~---~--~~
which version of MS Excel you are using. Also, you can write formula with
increasing the size of the cell and what exactly you mean by connecting to
other cell.
Regards,
Sarfaraz Ahmed
http://findsarfaraz.blogspot.com
On Wed, Feb 18, 2009 at 11:32 PM, Puneet Jain wrote:
> Hi all
>
&g
I guess you get welcome mail when you join any group. If you have not
deleted that email. you will be able to find Date of Joining
Regards,
Sarfaraz Ahmed
MS Excel help <http://findsarfaraz.blogspot.com/>
On Tue, Feb 3, 2009 at 2:19 PM, Ahmedhonest wrote:
> How to find the date of J
,
Sarfaraz Ahmed
On Sun, Jan 25, 2009 at 2:05 PM, Vikash Narnoli wrote:
> Dear Group mates,
>
> Please help me on formula wherein digits are written as figures.
> For eg.
> 25 is written as Twenty Five.
> 2555.55 is written as Two Thousand Fifty five and Paise Fifty Five
>
&
I believe this is enhance security in MS Excel 2007.
Regards,
Sarfaraz Ahmed
Free MS Excel help <http://findsarfaraz.blogspot.com>
On Thu, Jan 22, 2009 at 10:19 AM, Wazza wrote:
>
> I have an application that opens Excel files and loads data into an
> Access database. This app
That's was good common sense... I really really appreciate
Regards,
Sarfaraz Ahmed
MS Excel help <http://findsarfaraz.blogspot.com>
On Thu, Jan 22, 2009 at 7:11 PM, Paul Schreiner wrote:
> You should be able to use:
> =ROUND(A1-0.3,0)
> Paul
>
> -
24
24.80 25
50 50
Regards,
Sarfaraz Ahmed
Excel help
<http://findsarfaraz.blogspot.com/>
On Thu, Jan 22, 2009 at 3:06 PM, Kamran Haider
wrote:
> Dear Group mates,
>
> Please help me on round formula as xl built in formula round the figure on
> general math rule i
being used by 20 reports that are
> > to be mailed to the business users on daily basis. I know this is a
> > small issue, but still, CLIENT IS A CLIENT :P
> >
> > Please help me.
> > Regards,
> > shez.
> >
> > >
>
--
Thanks with regards,
Sarf
ing :)
>>
>>
>> --
>> Regards, Sunil Thacker
>> ¨`·.·´¨) Always
>> `·.¸(¨`·.·´¨) Keep
>> (¨`·.·´¨)¸.·´ Smiling!
>> `·.¸.·´
>> (¨`·.·´¨) (¨`·.·´¨)
>> `·.¸(¨`·.·´¨)¸.·´
>> `·.¸.·«*:·.
>> .·:*
>> *:·.
>> *«*:·
Hello ALL,
I am sending link to download ebook Excel 2007. I have more ebooks
Excel 2007 Bible
Free Excel E-books <http://findsarfaraz.blogspot.com/>
Regards,
Sarfaraz Ahmed
On Sun, Dec 21, 2008 at 7:40 PM, Naveen Sharma wrote:
> Hey sunil,
>
> Thank you very much. I think thi
I think we had enough mails on this. Sunita, is right.. lets and starts
sharing some good knowledge.
Regards,
Sarfaraz Ahmed
http://findsarfaraz.blogspot.com
On Sun, Nov 30, 2008 at 10:00 AM, Sunita Paudel <[EMAIL PROTECTED]> wrote:
> Yeah now lets stop the topic..we have done wh
Prasanna is right... Pivot will solve your problem
Regards,
sarfaraz Ahmed
http://findsarfaraz.blogspot.com
On Sat, Nov 22, 2008 at 6:05 PM, Prasanna <[EMAIL PROTECTED]> wrote:
>
> Why Don't you try Pivot Table It Should Do the trick.
>
>
>
>
>
> On Nov 2
ted by Shivkumar. I really appreciates
shivkumar's help..
Regards,
Sarfaraz Ahmed
http://findsarfaraz.blogspot.com
From: excel-macros@googlegroups.com [mailto:[EMAIL PROTECTED]
On Behalf Of N.Shivkumar
Sent: Tuesday, October 14, 2008 2:29 PM
To: excel-macros@googlegroups.com; [EMAI
Hello,
Does the report and Daily Sales Tracker reside in same excel file or DST
refers the values from different Excel file.
Regards,
Sarfaraz Ahmed
Excel Help <http://findsarfaraz.blogspot.com/>
On Thu, Oct 9, 2008 at 10:49 AM, AJIT NAVRE <[EMAIL PROTECTED]> wrote:
> Need to
24 matches
Mail list logo
