hi hanum
plz attach a sample file
so it will more easy for us to help u
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 27, 2010 at 5:01 AM, Hanum wrote:
> Both the solutions are not what I am looking for...
My understanding of the way this works is as follows. When a piece of code
starts running, Excel compiles the current VBA code and runs from its
compiled state. When your code alters the VBA with the custom procedure,
it's stored there, but won't run until the current VBA stops executing & the
co
Both the solutions are not what I am looking for...what I am looking
for is my exampleI think it is very clear.
Unlike these solutions, mine are always one-to-one relationship.
On Feb 24, 12:29 am, santosh bahuguna
wrote:
> Create Multiple Range of you data
>
> Let suppose
> we Have
>
> A C
Thanks a lot friends
On 26/02/2010, Paul Schreiner wrote:
>
>
> The date display format is determined by the Personal Settings for the PC
> that opens the file
> (it is not stored in the file)
> that means, IF THE CELL IS A VALID DATE
> then you can have the PC you're using currently display the
hi friends
this is link for download the trail version
and than use code given in earlier msg
http://www.investintech.com/prod_a2e_pro.htm
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 8:43
Hi,
Not sure if sumproduct is faster than sumifs.
But it may be that much of your data is historical (past months or years) and
doesn't update any more.
All non-updating cells that contain formulas, could be replaced with just their
numerical data.
Since your workbook is large, you could write V
This will be helpful for you to enhance your learning.
If you feel suitable provide me codes and their respective deisgn and I'll
create the menu (command bar) for you. But still I want you to try this
first by yourself, just to enhance your learning.. :)
--
Thanks & Regards,
DILIP KUMAR PAND
Dear Chandrabhan,
If this is not late, I would expect you to send a dummy test file and let me
give a try on this. While sending the test file, be specific what you want
as an outcome. If possible, try to provide the snapshot of the expected
result as well.
--
Thanks & Regards,
DILIP KUMAR PA
Dear Harpreet,
Try below link:-
http://www.ozgrid.com/VBA/custom-menus.htm
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On 2/26/10, Harpreet Gujral wrote:
>
> Dilip,
>
> I tried searchi
Hi Putta,
Attached is updated sheet with formulas.
As I have already helped you earlier on same formulas, Please give a try
before you send request to group going forward.
This group is not formed to get your work done but to get technical
assistance only. I hope you understand.
Best regards,
A
For various reasons a user-defined function of mine needs to allow
user input that is interpreted as executable code (in this case any
excel expression).
The most straight forward approach would be for the function procedure
to input code into a module active in the same excel session and
subseque
Thank u so much Christopher !
On Fri, Feb 26, 2010 at 1:48 PM, Christopher Luka <
christopher.l...@gmail.com> wrote:
> See attached.
>
>
> On Thu, Feb 25, 2010 at 7:06 AM, Mahesh parab wrote:
>
>> Dear All
>>
>> I need macro for when i open workbook, A1 cell value, will display 1 to 4
>> numbers
Hi,
I had a look at the file, i think there is some descrepancy between
what data we have on sheet "Goods No1" and "Data Sheet", and similar
is the case with Goods No.2 sheet and data sheet.
The codes that you want to check in Data Sheet are mostly 6 digits
while codes in Goodsno1 sheet and Goods
Hi Guys,
Can somebody post the link for able2extract software. I guess the
software would be helpful in converting pdf to different forms
i.e. .xls or .doc etc.
Thanks
Harpreet
On Feb 26, 2:11 pm, ankur wrote:
> hi anil
> this is not a excel file
> its a software to convert files
>
> able2extr
I am looking for Central Excise Registers, like RG-23A Part-!, II, RG-1
Registers in excel .If anybody have please post
Thanks in advance
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips t
Hello Frnds,
I am using 2007 excel. My file size is 21 MB. I used *sumifs
formulas*extensively in each sheet(total 25 sheets).
My problem is whenever I open the file or close or calculate or save it
takes much time say 20 min. Would like to make my workbook faster. Could
you please guide me.
Hi Ayush,
I need another favour from you.
Please check the attached sheet and provide me the formulas as required in
the table.
Rgds- Madaiah, Bangalore
On Fri, Feb 5, 2010 at 8:47 PM, ayush jain wrote:
> Hi Madajah,
>
> Attached is the updated solution with the new condition.
>
> Best regard
The date display format is determined by the Personal Settings for the PC that
opens the file
(it is not stored in the file)
that means, IF THE CELL IS A VALID DATE
then you can have the PC you're using currently display the date as:
DD/MM/, and then open the file on another PC and display
same to 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, 2010 at 6:10 PM, vikas gupta wrote:
> DEAR ALL
>
> GREETINGS OF HOLI FESTIVAL
>
> I HAD SENT A EXCEL FILE THROUGH E MAIL FROM DELHI TO FRANCE
>
Hi to all,
I am looking for the Fixed Asset Register format, Please send me to help me
Thanks and Regards,
Ashish.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
DEAR ALL
GREETINGS OF HOLI FESTIVAL
I HAD SENT A EXCEL FILE THROUGH E MAIL FROM DELHI TO FRANCE
IN EXCEL FILE A DATE IS WRITTEN IN DD/MM/ FORMAT
BUT WHEN IT REACHED ITS DESTINATION IT SHOWS THE DATE FORMAT
IN MM/DD/ FORMAT
IS IT POSSIBLE IN EXCEL SHEET
PLEASE PROVIDE ME SOLUTION URGENTL
hi sudhir
check this addin
and use formula =num2text(a1)
a1 is cell having number
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 4:11 PM, sudhir kumar wrote:
> Hi Dear all,
>
> Please help me fo
Hi OSAVentures,
Have a look at the attached to see if you can adapt it to your own needs.
Regards - Dave.
Date: Fri, 26 Feb 2010 14:53:14 +0800
Subject: $$Excel-Macros$$ How to select unique values from a list and copy
each unique value to another location of another worksheet
From: osav.
Dear Sudhir,
Please refer to 'Number to Words' workbook in files section of group.
Below is the link.
http://excel-macros.googlegroups.com/web/Numbers_in_Words(Rs).xls?gda=dtwwBU4AAADOQWN3H4SqkkfVkSY0J5hnnXtVRIe6oG84nwDUlUAkbZWbC7dR_Mk0PHssWsfmKiXh0XMtmRH0yYD4x247RFx147Cl1bPl-23V2XOW7kn5sQ&gsc=rxA
hi sachin
im agree with you.
lets find the 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 Fri, Feb 26, 2010 at 3:36 PM, VIRAL PANDYA wrote:
> hit "CTRL + SHIFT + ~" KEY...
>
> Regards,
> Viral Pand
Hi Dear all,
Please help me for below formula.
1. how to convert numbers in text.
2. Example
2000Two thousands
when i m change the number the text changed automatically.
--
Sudhir Verma
Asstt. Mngr. A/c's
9211219649
--
-
hit "CTRL + SHIFT + ~"KEY...
Regards,
Viral Pandya
On Fri, Feb 26, 2010 at 2:53 PM, ankur wrote:
> format the cells of whole sheet in general format...
>
>
> if still problem
> check this link
> http://www.brighthub.com/computing/windows-platform/articles/27366.aspx
> Have A Nice Time & En
Dear Mr. Pandey,
It's happen even I open new sheet. I thiks somewhere problem in setting.
What's your suggestion?.
Thanks
Sachin Shukla
On Fri, Feb 26, 2010 at 2:53 PM, ankur wrote:
> format the cells of whole sheet in general format...
>
>
> if still problem
> check this link
> http://ww
hi puttu
i think vlookup function will solve this...
u can attach file , it will be easy to provide you complete 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 Fri, Feb 26, 2010 at 12:40 PM, Puttu wrote
thanks
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 2:15 PM, Christopher Luka
wrote:
> As a matter of advice, I'd use the offset/match combination even when you
> can use a standard vlookup. I
format the cells of whole sheet in general format...
if still problem
check this link
http://www.brighthub.com/computing/windows-platform/articles/27366.aspx
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
hi OSAVentures Calamba
check this link
http://blogs.techrepublic.com.com/howdoi/?p=111
VBA, the automated way
First, create two ranges: the list’s source data and a target range
for the unique list. Select the source data; in this case, that’s
cells A2:A18. From the Insert menu, choose Name and
you may use the QUERY~
select distinct [list_name] from [list_name]
On Fri, Feb 26, 2010 at 2:53 PM, OSAVentures Calamba wrote:
> How to select unique values from a list and copy each to another location
> of another worksheet? Not using auto-filter or advance filter?
>
> Thanks.
>
> --
>
>
As a matter of advice, I'd use the offset/match combination even when you
can use a standard vlookup. In most cases, it's quite a bit faster than
VLOOKUP, *especially* when you have a large number of rows to process.
On Thu, Feb 25, 2010 at 8:45 PM, Manoj kumar wrote:
> Hi Anil,
>
> Please find
Dear All,
If I put a data on sheet say in cell A1 I put 45 number, cell automatic
convert in Date formate .
How I remove this problem to my entire work book and sheet. I use Excel 2007
Thanks
Sachin Shukla
--
-
Take a look at the example attached. If you press Alt+F11 to view the code,
you'll see that I attached the code to the Worksheet_SelectionChange event.
This fires whenever someone selects a new cell on Sheet1 (in this case).
Additionally, I added two lines to prohibit the timestamp from being
ch
Click on start download
After executing the following link
http://www.microsoft.com/downloads/en/confirmation.aspx?familyId=941b3470-3ae9-4aee-8f43-c6bb74cd1466&displayLang=en
Microsoft by default have a problem to work from higher virson to lower
version.
such example is installing win 98 afte
See attached for example.
On Thu, Feb 25, 2010 at 9:44 PM, Ayush wrote:
> 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
You might also look up 'loan amortization' in online templates in Microsoft
Office. The formulas are all built in so you can study them.
On Thu, Feb 25, 2010 at 9:59 PM, ankur wrote:
> hi umesh
>
> for learning vba , u can download books from our file section
>
> Have A Nice Time & Enjoy Life
>
See attached.
On Thu, Feb 25, 2010 at 7:06 AM, Mahesh parab wrote:
> 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
hi anil
this is not a excel file
its a software to convert files
able2extract professional version
u can download that on from internet
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:04 PM, an
Hi Harpreet,
For this you can use the converter that will convert your 2007 version excel
file into 2003 version.
Thanks & Regards,
Anil Kumar.
On Sat, Feb 6, 2010 at 8:01 AM, Harpreet Singh Gujral <
harpreetguj...@gmail.com> wrote:
> Hi Group,
>
> I work on Office 2003, and it becomes a proble
Hi Team
I need help either in excel formula or macro for the product code need
to splits in different sheets.
1. Data Sheet contains All product codes
2. Goods No.1 & 2 contain selected goods code item.
3. Other Goods sheet blank
I need what ever the product available in Data Sheet it should
hig
Thanks Man...That works.
Regards...Abhishek
On Fri, Feb 26, 2010 at 12:33 PM, ankur wrote:
> 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
Okay friendwaiting ;)
I guess some one in the group (not sure who) is having a working VBA
unlocker. Here's the call"Help Please"
Thanks,
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.
Dear Ankur,
Thanks a lot ! Seems really interesting.
Can I have the vba password of this file or can you send the unlocked
version so that the code can be modified as per my requirements.
Best regards,
Abhishek
On Fri, Feb 26, 2010 at 12:14 PM, ankur wrote:
> hi abhishek
>
> check this file
How to select unique values from a list and copy each to another location
of another worksheet? Not using auto-filter or advance filter?
Thanks.
--
--
Some important links for excel users:
1. Follow us on TWITTER f
Share With Exe File Please
Regards
Anil Kumar
On Fri, Feb 26, 2010 at 12:02 PM, ankur wrote:
> 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
48 matches
Mail list logo
