You're welcome.
Regards - Dave.
> Date: Sat, 21 Aug 2010 15:22:42 -0700
> Subject: Re: $$Excel-Macros$$ Ageing of data
> From: tonycrazy...@gmail.com
> To: excel-macros@googlegroups.com
>
> Hi Dave,
>
> Thanks a lot for the quick response. Its working perfectly.Thanks
> once again.
>
> R
Hi Dave,
Thanks a lot for the quick response. Its working perfectly.Thanks
once again.
Regards,
Tony
On Aug 21, 11:45 am, Dave Bonallack wrote:
> Hi Antony,
>
> See if the attached contains what you need.
>
> For the catagory column, I've used a nested IF formula. But you could also
> hav
Mr. Dilip,
Mr Jai has; requested only to hide the contents of the cell without
any protection. So is my answer.
This way you can only hide the contents of the cell, but U can't
protect against alteration.
Regards,
Kishan Reddy, K
On Aug 21, 6:20 pm, Dilip Pandey wrote:
> Dear Kishan,
>
> Is i
Thanks PankajMy Pleasure :)
On Sat, Aug 21, 2010 at 6:16 PM, Pankaj Pandey <
pankaj.pan...@firstsource.com> wrote:
> Hi Ayush,
>
>
>
> I really thanks to you for your Help, Really appreciated
> your knowledge n helping nature. Keep it up for all of us.
>
>
>
> Regards
>
> Pan
can you give me some example code
one i have doubt for that
if your name have xyz name can you tell me if i send macro short all users
xyz also same short cut
regards
Vilas
On Sat, Aug 21, 2010 at 6:40 AM, Dilip Pandey wrote:
> Hi Vilas,
>
> Suppose you have a folder containing some macro
To install font
download it copy rupee font file ->
Go To RUN-> TYPE FONTS-> PRESS ENTER-> PASTE THE RUPEE FONT FILE
On Sat, Aug 21, 2010 at 7:44 PM, ashish koul wrote:
> check the attachment
>
> regards
>
> ashish koul
> akoul.blogspot.com
>
>
> On Sat, Aug 21, 2010 at 6:57 PM, Dilip Pan
Quick solution!! Grt answer.
Best Regards,
DILIPandey
On 8/20/10, Soni.Rajender wrote:
> Hi OPS
>
> Simply write 1,0 in any cell, copy it, select the cell whom u want
> to convert, right click --> select paste special, under paste option
> select "values", In operation section select "d
Thanks Mr. Modi..!!
Regards,
DILIPandey
On 8/21/10, L.K. Modi wrote:
> DEAR ALL
>
> paste this font in fonts folder and then you can do.
>
>
> regards
> Modi
>
> --
> --
> Some important links for excel users:
> 1. F
hey friends, i hve just joined this group and want to hve all excel
tips and macro as well. Looking for ur answers. Thanks
On 8/21/10, Dilip Pandey wrote:
> Hi Vilas,
>
> Suppose you have a folder containing some macro files and you want
> users to have a shortcut of the same in their respective
hi
Yes that does exactly what i need to be done... Thank you!!! but
now
I need the all people that have birthday to day or tomorow or day
after to apear on a userform. (take note that there maybe more than
one sharing a birthday)
i use label34 (today) and label35 (tomorow) and label36 (day a
Hi Vilas,
Suppose you have a folder containing some macro files and you want
users to have a shortcut of the same in their respective desktops,
then you can put the same in some shared drive and send the shortcut
of the same to every user which they can store in their respective
desktop. Alternati
Hi Vebhav,
I hope you have checked the signature of your email which has some web
links where you can start your learning. Alternatively, you can use
google for free book / free learning materials as well.
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
Thanks Ashish...!!
Can we do the comma formatting like we can do with the dollar sign?
(Rupee Symbol)1,00,000
Below is what we can do with Dollar sign.
$100,000
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New
Dear Kishan,
Is it diferent for the approach where we can go to "Protection" tab
and check the checkbox against the option "Hidden"?
--
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 8/21
can u give me example sheet??/
On Sat, Aug 21, 2010 at 4:15 PM, Kishan Reddy, K <
kishanreddy.kethire...@gmail.com> wrote:
> Dear Jai,
>
> Select the cells that you want to hide.
>
> On the Format menu, click Cells, and then click the Number tab.
>
> In the Category list, click Custom.
>
> In the
Dear Jai,
Select the cells that you want to hide.
On the Format menu, click Cells, and then click the Number tab.
In the Category list, click Custom.
In the Type box, select the existing codes and press BACKSPACE.
In the Type box, type ;;; (three semicolons).
Select the OK button
Regards,
Kis
I want to do by using a simple click of button as this the problem is the
small part of my complete project and once the report is generated ...I need to
do more calculation ..a vba code is required so that a baby can generate
the qa report
Thanks
Shariq
Sent on my BlackBerry® from Vo
Yes Dave..the solution is very good..but I want to do this by clicking
the bottom and the data could me any length n the only constant thing is the
hours which is not more then 22 but can be less
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Dave Bonallack
Sender
Hi Dave,
Thanks for your help it is very good solution. But I need a macro code as the
problem I shared with the group was the very small part of my vba automation
project..actually my mind is not giving me the solution of this problem
that is why I shared with you allplease send me the
Hello Shariq,
I don't understand why can't you use pivot table.
Actually, it is simple with pivot table.
Just drag the date to the rows header.
drag the hours to the column header.
LoadId to the data area.
If you get sum on loadId, double click on it, and change it to count.
The only differe
Hello Experts
Can you Tell me that how can Hide the One Cell in Excel in Sheet.
--
Thanks For Mail.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.co
Hi All,
I am interested to learn VBA Macros and i know only basics as of now (i.e)
Recording.
Please can you suggest any books or site which will help me to learn
better.
Thanks & Regards,
Vebhav Jain
--
--
Some
Hi
hi friends can you tell me how to make exe of all multiple macro enable file
setup a proper folder and automatically make shortut on user destop
--
With Best Regards,
Vilas Chavan
Email : cvi...@ymail.com, vilaschav...@gmail.com
Mumbai - Maharashtra
--
-
Thanks Andy. You're welcome.
Regards - Dave.
Date: Sat, 21 Aug 2010 15:33:03 +0530
Subject: Re: $$Excel-Macros$$ Need Help in Cross tab
From: aind...@gmail.com
To: excel-macros@googlegroups.com
Hey Dave,
This is great!! you never stop amazing me with your simple solutions to complex
probl
Hey Dave,
This is great!! you never stop amazing me with your simple solutions to
complex problems..
Keep it up man!!
You are a pillar of our group...
Cheers!!!
Andy
On Sat, Aug 21, 2010 at 2:45 PM, Dave Bonallack
wrote:
> Hi Shariq
> I've done this with worksheet functions, not VBA.
> The ori
Hi Antony,
See if the attached contains what you need.
For the catagory column, I've used a nested IF formula. But you could also have
a separate table and use VLOOKUP.
Columns A & B are formatted as Date, while Column C is formatted as Number.
You will have to fill-down the formulas in Colum
Hi Antony,
Assuming that the Header "Start date" is in Cell A1, please use the
following formula in the "Category" column:
=IF(AND(C2>=0,C2<=30),1,IF(AND(C2>=31,C2<=60),2,IF(AND(C2>=61,C2<=90),3,IF(AND(C2>=91,C2<=120),4,IF(C2>=120,5,"")
Please let me know if this helps or u need any further h
Dear,
i think this is based on office latest version.
can this possible in MSOFFICE 2003,
Do the needful
Regards,
Sudhir Ingale
On Sat, Aug 21, 2010 at 8:28 AM, ashish koul wrote:
> Sub bdaymessages()
>
> Dim I, K As Long
>
>
> Dim olApp As Outlook.Application
> Dim olMail As MailItem
>
Hi All,
I need your help, as I’m unable to solve the problem which I’m going
to explain you guys……..
Please refer the attached the excel with two tabs “Data” and “Report”
On Data tab I have three columns loaded and Date and hours. Now I need
a macro code to generate a report actually the cross bet
Hi David,
Have a look at the attached. I hope it meets your needs.
As good as the macro recorder is, it always returns way too much code. Part of
learning VBA is learning how to trim down what we get from the macro recorder.
For example:
We can name a range without actually selecting it
Sub bdaymessages()
Dim I, K As Long
Dim olApp As Outlook.Application
Dim olMail As MailItem
Dim SigString As String
Dim Signature As String
Application.ScreenUpdating = False
Set olApp = New Outlook.Application
'it is counting the non blank cells in col a
K = Appl
Sorry to interrupt, but I found I serious lapse in the macro. That is in
case I am not online (server down etc), then I am not able to know to whom
it was sending the mail. If it is possible to display the message body and
person to whom it is sending the mail , it will be much worthy.
Regar
Divide your issue into two
1. schedule to auto Open an application/file at a particular file.
This is actually part of operating system.
in operating system (for example windows) take Help on SCHEDUAL A NEW
TASK.
2. executing a macro on opening the file.
This is part of excel. Just place your c
Dear Koul,
Thanks for the help extended. But, I would like if possible, the following
modification;
1. Two column for message to be sent. First for b day message and
other for congratulation.
2.Whether it is possible that the macro be scheduled to run
bimonthly.
Mr Pankaj,
1. The code is password protected.
2. Let me Know where is the Submit Button. (in which sheet)
3. Let me know precisely what are the cells that you want to check
for blanks.
Regards,
Kishan Reddy, K
On Aug 21, 10:36 am, Intelligent But Crazy
wrote:
> Hi Experts
>
>
Dear David,
Just carefully replace,
RefersToR1C1:="=Sheet1!R2C1:R12C6"
with
RefersTo:=Selection
You have four ranges, so do the replace four times for each range.
Regards,
Kishan Reddy, K
On Aug 21, 1:04 am, David Stubbs wrote:
> Hello everyone,
>
> I am trying to write a macro to name
check the attachment see if it helps you
Regards
Ashish koul
http://akoul.blogspot.com/
On Sat, Aug 21, 2010 at 10:31 AM, Chandra Gupt Kumar <
kumar.bemlmum...@gmail.com> wrote:
> Could you please share how it is possible.
>
>
>
>
>
>
>
> Regards,
>
>
>
> C.G.Kumar
>
>
>
>
>
> *From:* excel-m
Hi Experts,
Could anyone help me to have difference between two dates into
different categories.
For eg:
Start date End dateDifference Category
6/6/20109/6/201092 4
Categories Values
0-301
31-60 2
61-90 3
91-120 4
>1205
Thanks in advance
Hello, Phillip,
Handle this by step by step.
1. IN column E Put the Heading
Date in the Current Year.
add fomula in E8
=DATE(YEAR($B$2),MONTH(B8),DAY(B8))
2. In column F put
Birthday falls in No. of days
add formula in F8
=E8-$B
Could you please elaborate the problem so that I may suggest a solution.
Regards,
C.G.Kumar
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of hemant shah
Sent: Thursday, August 19, 2010 10:54 PM
To: excel-macros@googlegroups.com
40 matches
Mail list logo
