Hi Experts
Pls Help Mee
Regards
Pankaj k Pandey
On 8/20/10, Intelligent But Crazy wrote:
> hi Experts,
>
> I m working on a project, I required a help that in
> Audit form if any one click on Submmit button so first it check thatis
> there any box left blank, if
how we can schedule to auto open excel application on given time and run macro.
Please let me knw and knw the solution on that.
--
With Best Regards,
Vilas Chavan
Email : cvi...@ymail.com, vilaschav...@gmail.com
Mumbai - Maharashtra
--
--
Could you please share how it is possible.
Regards,
C.G.Kumar
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Vasant
Sent: Friday, August 20, 2010 1:43 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ sending e mail base
Hi Phillip,
Please find attached the solved workbook.
Do let me know if it helps or you need further help.
I have added some other features other than your requirement which I felt
might come handy, as well, which will predict the following:
Today (As required)
Tomorrow (As required)
Day After (A
Hi all
Attached is a sample work book.
In column b down i got birthdays. next to that the persons name.
B2 will be either =today() or =now() (or something else that will trigger
the days date...
how can i display in a column who has a birthday today or tomorrow?
Phillip Swanepoel
pswa...@g
Hi there,
I a have a work book with 10 sheets I need to make an identical copy
of the sheet summary in a new workbook, can you help me with the code
to copy (copy special value) only the summary sheet.
thank you,
--
-
Hello everyone,
I am trying to write a macro to name four ranges in a sheet. The
ranges will have the same width every time, and the ranges below the
two at the top with always be separated by 1 blank row but more or
less rows. I thought it would work by using:
Range(Selection, Selection.End(xlDo
Hi
Please add this line to your function. Adding on the first line will be good.
Application.Volatile
This will cause recalculation of the function when any value change in
the sheet. (So directly affect the speed if you use function on many
cell)
Thanks & Regards
Sandeep
On Fri, Aug 20, 2010 a
Thanks for getting back to me. I have attached a demo workbook. Row
14 contains one of the formulas in questions.
http://excel-macros.googlegroups.com/web/TestWkb.xlsm?gda=xZn4GD4o61zD5UnH__xR-dBifwHhv_d2uiRDKQGL8zFE3ZFTfWRBti8nExtn9c0KYrNRRjDjsKXVs-X7bdXZc5buSfmx&gsc=brmZ0QsAAACht2TsvJ2a1
I am needing to create a project that needs to talk to other users
that are woring from a common file.
I have found the following code that loos lie it may be a good place
to start, but I keep getting errors.
Compile error: "can't find project or library
and it highlights wschat
I run from 2 system
Are you using it as a function in a cell with something like:
=rre_Salary(celladdress,celladdress,##,##)
??
If so, whenever the sheet recalculates,
it's using the Active Cell as a reference location.
If you enter a date and hit "tab", then the active cell is the cell to the right
(unless you've
I have a user defined function that is not updating. The way it works
is based on HireDate. It looks at the hiredate and compares it to the
budget year. IF the budget year is in the same year as the hire date
then it looks at the row which could C:N or Jan-Dec. It works fine
until I actually i
Much appreciated! I am upgrading next week!
From: excel-macros@googlegroups.com
[mailto:excel-mac...@googlegroups.com] On Behalf Of Dave Bonallack
Sent: Friday, August 20, 2010 9:04 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Need help with
Define ltext as string instead of long.
-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
Subject: $$Excel-Macros$$ Problem New1
Hi Team,
I nee
Oops. Did I say COUNTIF? I meant SUMPRODUCT... And 0 (zero) means id associated
with only one name. Greater than zero means multiple associations.
Sorry.
Regards - Dave.
Date: Fri, 20 Aug 2010 14:14:58 +0530
Subject: Re: $$Excel-Macros$$ Unique id to name
From: aftab.ala...@gmail.com
To: ex
Dear Aftab
Check the attach file as per your requirement
i think it solve your query
Sudhir Ingale
On Fri, Aug 20, 2010 at 9:56 AM, ALAM wrote:
>
> Dear all,
>
> Solve my poblems
>
> Note:- I want to all details in excel sheet (like *NAME IN-TIME
> DATE
> ) *JUST
Can you be more precise what you want ?
Regards
Vasant
9880533187
On 8/20/10, ALAM wrote:
>
>
> Dear all,
>
> Solve my poblems
>
> Note:- I want to all details in excel sheet (like *NAME IN-TIME
> DATE
> ) *JUST CLICK OF *EMP ID*.
> ALSO WE ENCL
On 8/19/10, None wrote:
>
> Dave,
>
> Can I trouble you for an example? I'm not sure how the COUNTIF would work
> here. Thanks.
>
>
> --
> *From:* Dave Bonallack
> *To:* "excel-macros@googlegroups.com"
> *Sent:* Wed, August 18, 2010 7:34:17 PM
> *Subject:* RE: $$E
Dear all,
Solve my poblems
Note:- I want to all details in excel sheet (like *NAME
IN-TIME DATE
) *JUST CLICK OF *EMP ID*.
ALSO WE ENCLOSED EXCEL SHEET FOR ALL OF U
--
Regards&Thanks,
AFTAB ALI
9310903589
--
-
Great Solution ...
With Warm Regards,
CA. Ajay Mittal
Finanace Manager
Pipelines Division,
Noida - 201 301
Tel: 0120-2448324
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On
Behalf Of Soni.Rajender
Sent: 20/08/2010 11:53 AM
To: MS EXCEL
Yes, it is possible to do
Regards
Vasant
On 8/20/10, Chandra Gupt Kumar wrote:
>
> Dear All,
>
>
>
> My requirements are as follows;
>
>
>
> 1. Based on date of birth (Col D), mail to be sent on particular day
> to respective office for good wishes.
>
> 2. Based on date of joining
Change this line
Dim ltext As LOng, curRow As Long
AS
Dim ltext As String, curRow As Long
Regards,
Kishan Reddy, K
On Aug 19, 10:24 pm, hemant shah wrote:
> Hi Team,
>
> I need your help in the attched excel.
>
> I have explained everything in attached sheet.
>
> Regards
> Hemant shah
>
> Pr
Dear All,
My requirements are as follows;
1. Based on date of birth (Col D), mail to be sent on particular day
to respective office for good wishes.
2. Based on date of joining , congratulation mail to be sent if the
concerned completes 5,10,15,20,25,35,40 years of service.
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 "divide", click on ok.
Regards
Rajender Soni | 7503225550
On Aug 20, 8:53 am, OPSHARMA wrote:
> Dear Ex
You can use the following OPERATORS in excel
+addition,
- substraction
* multiplication
/ division
for example if your data is in Column B1, Just Type this column C
=B1/10
Your values in lacks will be available in column C
If you want round it (Restrict the number of decim
25 matches
Mail list logo
