password of file is ankur
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Fri, Feb 26, 2010 at 12:34 PM, ankur wrote:
> Have A Nice Time & Enjoy Life
>
> Regards:
> CMA Ankur Pandey
> (Someone Different)
>
> I'm n
hi abhishek
luckily i got
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Fri, Feb 26, 2010 at 12:28 PM, ankur wrote:
> hi abhishek
> thanks for nice words...
> this is downloaded software..i dont have code of this..
hi abhishek
thanks for nice words...
this is downloaded software..i dont have code of thislet me
try to unlock ..if i get i will mail it you...
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Fri, Feb 26, 2
this has solved answer
http://en.kioskea.net/forum/affich-5838-excel-autofilter-stops-filtering
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Fri, Feb 26, 2010 at 12:18 PM, ankur wrote:
> check this link
>
> http:/
check this link
http://excel.tips.net/Pages/T002403_Increasing_the_AutoFilter_DropDown_Limit.html
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Fri, Feb 26, 2010 at 10:09 AM, gurdev singh wrote:
> Dear All,
>
> I h
ya sure
this is the code
127418901528
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Fri, Feb 26, 2010 at 11:43 AM, Harshad K
wrote:
> can you share with me
>
> regards
> harshad
>
> On Fri, Feb 26,
can you share with me
regards
harshad
On Fri, Feb 26, 2010 at 12:21 PM, ankur wrote:
> i got the code
>
> thnks
> Have A Nice Time & Enjoy Life
>
> Regards:
> CMA Ankur Pandey
> (Someone Different)
>
> I'm not the best but i'm not like the rest~~
>
>
>
> On Tue, Feb 23, 2010 at 4:02 PM, ankur
yes,
there is no problem with pirated software
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Tue, Feb 9, 2010 at 11:51 PM, Harpreet Singh Gujral
wrote:
> Hi,
>
> Will this work on pirated software
>
> Just need to
hi umesh
for learning vba , u can download books from our file section
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Tue, Feb 16, 2010 at 4:45 PM, C.G.Kumar wrote:
> Please find attached solution.
>
>
>
>
>
> Regar
our file section has very good material on macros and vba .download
stuff from there
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Wed, Feb 17, 2010 at 3:44 PM, chethan Bhadravathi
wrote:
> Hi,
>
> Can anybody help
check youtube.com.there are very good examples
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Wed, Feb 17, 2010 at 6:00 PM, Puttu wrote:
> Hi Team,
>
> Can you send me any step by step procedure Document to learn Bas
how can we minimize that window?
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Sat, Feb 20, 2010 at 9:54 AM, ankur wrote:
> good one
> Have A Nice Time & Enjoy Life
>
> Regards:
> CMA Ankur Pandey
> (Someone Dif
ATTACHE ARRANGED DATA
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Mon, Feb 22, 2010 at 11:56 PM, Dilip Pandey wrote:
> Hi Sudesh,
>
> Your data is not arranged properly. If this is not an ad-hoc request, then
> y
Hi Markkim,
Would you please send the sample file containing this data?
Best regards,
Ayush Jain
On Feb 26, 6:18 am, Markkim wrote:
> Hi
> I have been trying to make these but have failed. ^ ^;;
> I’d like to create a macro
>
> A21 has a word called ‘Date’
>
> And somewhere down in column A has
nice link
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Mon, Feb 22, 2010 at 9:51 PM, Harpreet Singh Gujral
wrote:
> This is a amasing solution. Works great, have tested a test file
>
> Will try it on a real life si
hi skanda
=1*MID(A1,MATCH(TRUE,ISNUMBER(1*MID(A1,ROW($1:$9),1)),0),COUNT(1*MID(A1,ROW($1:$9),1)))
this is array formula use ctrl+shift+enter
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Mon, Feb 22, 2010 at 10:15
thnks for handy tips
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Tue, Feb 23, 2010 at 11:07 AM, Ayush Jain wrote:
> Ayush Jain has sent you a link to a blog:
>
> Dear Group, An amazing tip to use only visible rows
i got the code
thnks
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Tue, Feb 23, 2010 at 4:02 PM, ankur wrote:
> hi experts,
> i had one pdf file converter
> pdf to different type of file like word, excel etc, i got
use pastespecial and divide by 100
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Wed, Feb 24, 2010 at 1:52 AM, S.Frojen wrote:
> I have a waterfall chart that is built off of a dataset registering
> %'s. My beginni
Dear All,
I have data around 5000 rows in excel file and i am using Microsoft office
2003 and in Microsoft office 2003 filter limit is upto 1000
is there any alternate to extent this filter limit in Microsoft office 2003
i am unable to upgrade Microsoft office 2003 to higher version because this
Hi Anil,
Please find the attached sample sheet for your reference
Regards,
Manoj Kumar
On Thu, Feb 25, 2010 at 8:54 AM, anil kumar wrote:
> Hello Everybody,
>
> My question is that suppose we have the below table
>
> Col A Col B Col C
> x ab 50
> z
Dilip,
I tried searching on the net for the codes, but was not as successfull as I
thought I would be.
If you can help me, can you provide me a link or a source which clearly states:
1) How to use this code?
2) How to make use of its sub properties. Eg: position (this is where more
information
Hi Mahesh,
You may use below macro in Open_workbook procedure of your sheet. Let
us know if any further help is required.
Sub animation()
For i = 1 To 4
ActiveSheet.Range("A1").Value = i
Application.Wait (Now + TimeValue("0:00:10"))
Next
End Sub
Best Regards,
Ayush Jain
hi Daniel
very good use of formula
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Thu, Feb 25, 2010 at 9:00 AM, Excel wrote:
> Thank you so Much
>
> What an idea sir ji,,
>
>
>
>
>
> Amit Jaggi
>
> - Original M
hi alpesh
thanks for reply
can u send me the link of that software
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Fri, Feb 26, 2010 at 9:27 AM, Alpesh Gajjar wrote:
> Hi, Friends,
>
> you can use Abbyy Fine Reader
Hi, Friends,
you can use Abbyy Fine Reader. it's very useful software regarding
converting PDF to any files.
Alpesh Gajjar
On Tue, Feb 23, 2010 at 4:02 PM, ankur wrote:
> hi experts,
> i had one pdf file converter
> pdf to different type of file like word, excel etc, i got that
> software from
*Hi Mike,
Simple function like this
12 Roosevelt Ave* *
=RIGHT(A1,14)* *
=LEFT(A1,2)* 12 Roosevelt Ave Roosevelt Ave 12
Hope it can help
Worawat
2010/2/25 Mike
> Hi folks,
> Looking for a function(if it exists) that will grab the first letter
> in a string and put it in another
hi anil
i think u need this formula for left vlookup
OFFSET(A1,MATCH(B4,B2:B5,0),0)
see the attached file for solution
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Thu, Feb 25, 2010 at 7:24 PM, anil kumar wrote
Hi Billy,
Not quite sure of your actual need.
Here's the syntax for putting time or date into a cell using VBA
Range("A1") = Date
Range("B1") = Time
If you want them to insert automatically, you'll have to let us know the
conditions.
Regards - Dave.
> Date: Thu, 25 Feb 2010 16:11:41 -0800
>
Hi
I have been trying to make these but have failed. ^ ^;;
I’d like to create a macro
A21 has a word called ‘Date’
And somewhere down in column A has a cell with a word ‘FBT Details’.
The location of FBT details depends on the amount of data between
these two headings. I’d like to remove any bla
I just got a new job after a years layoff. By trade I'm a unix person
but have now entered the microsoft world.
I'm currently having to d a lot of work in excel. One thing I
consistantly have to do is to put the current time into 1 cell and the
date into another cell. This has to be an easy func
Dear Grup,
'---naming a range, example
Dim NotCtr1 As Range
Dim IsSameRange as Boolean
Set NotCtr1 = Range("A1:C2")
Range("A1:C2").Name = "Ctr1"
'---refering a named range, example
Range("Ctr1").interior.ColorIndex = 16
IsSameRange = (NotCtr1 = Range("Ctr1"))
MsgBox IsSameRange
On Feb 25,
Hi Mike,
Please use below mentioned formula and also check attached file for example.
=LEFT(A1,FIND(" ",A1,1))
regards,
Vijay
On Thu, Feb 25, 2010 at 5:10 PM, Mike wrote:
>
>
> On Feb 24, 9:53 pm, Mike wrote:
> > Hi folks,
> > Looking for a function(if it exists) that will grab the first l
Hi,
This is not complete, but you could use a nested IF Statement.
Something like this in cell P6
=IF(LEN(N6)>0,N6,IF(LEN(M6)>0,M6,IF(LEN(L6)>0,L6,K6)))
On Jan 14, 11:40 pm, ankur wrote:
> hi Gurmeet
> can i have sample file,then it will be easy
> Have A Nice Time & Enjoy Life
>
> Regard
Dear All
I need macro for when i open workbook, A1 cell value, will display 1 to 4
numbers one by one, time interval should be 15sec.
i want this to create animation effects in pie chart, cell A1 is link with
data by Hlookup, so when value in A1 change
it will change pie chart also.
I will apprec
Hello Everybody,
My question is that suppose we have the below table
Col A Col B Col C
x ab 50
z mt 46
y ct 100
now i am searching value mt corrosponding value in Col A through the vlookup
function, but my conditio
Yes, dear Anand..!!
Let me know if you can do the same OR you need my help to re-vamp the
formula.
Note:- First you need to identify if an date is a fifth Saturday or not, if
yes, then if this falling between your start date and end date, if yes, then
you need to include that because Networkdays f
Dear Harpreet,
I believe this is something related to menu creation using Excel-VBA. Try
searching internet with changed string and you'll get many reasonable
responses. :)
Let me know if you need a sample code to create a menu button.
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Ho
Hi Harpreet Gujral,
Below is the solution for your query. I have used range B1:B10 for name
"Deepak" in the below code. You can customize the syntax as per your
requirement.
Range("B1:B10").Select
ActiveWorkbook.Names.Add Name:="Deepak", RefersTo:=Range("B1:B10")
Hope this is what you ar
On Feb 24, 9:53 pm, Mike wrote:
> Hi folks,
> Looking for a function(if it exists) that will grab the first letter
> in a string and put it in another cell. For example:
>
> '12 Roosevelt Ave.'
>
> Some function that will grab the '12' and put it in another cell, with
> the original cell left
Dear Harpreet Ji
Sorry not to understand your problem,i have try to solve the problem only.
Named range is not new for me that the reason i have given the perfect
exposer in my previous post.
:)
Sorry again.
Happy to help.
On Thu, Feb 25, 2010 at 3:45 PM, Harpreet Gujral
wrote:
> Sorry m
Option Explicit
Sub Macro1()
this will put the the value taking R1C1
Sheet1.Range("A1").Select
ActiveCell.FormulaR1C1 = "last name"
End Sub
Sub Macro2()
this will put the the value taking R2C1
Sheet1.Range("B1").Select
ActiveCell.FormulaR1C1 = "first name"
End Sub
Su
The idea is to name the range and then use it within the macro for ease of
referencing.
ActiveWorkbook.Names.Add Name:="Ctr1", RefersToR1C1:=_ Strshtname &
"R1C1:R2C3"
I am talking about 'referstoR1C1'. For this we have to give range in terms of
R1C1 reference style. Can we name a range
Check MID function.
Regards,
C.G.Kumar
AMW-2
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Mike
Sent: 25/February/2010 8:23 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Need to grab a word from a string
Hi folks,
Please attach sample file explaining your requirement in brief.
Regards,
C.G.Kumar
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of summu
Sent: 24/February/2010 6:47 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Sampl
Dear Harpreet R1C1 is used to declare or use formula file
using macro.
i think if you want to run any formula or function u can directly write in
excel formula window (fx) or in macro difining R1C1.
I hope it will help.
On Thu, Feb 25, 2010 at 11:18 AM, Harpreet Gujral
wrote:
> Thanks for you
46 matches
Mail list logo
