Dear Friends,
Please help.
Best Regards,
Amit Desai
+91 98672 32534
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Amit Desai (MERU)
Sent: 25 January 2013 13:57
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Calculate Net TAT / time Gap excl
I ""; "" to ignore the error # N/A if column A MASTER of 2 LIST list
and the elements are not the same, you try.
2013/1/25, amar takale :
> Dear betnmtdongnai,
> what is use of ("";"";) in formula .as like Prince simple vlookup aslo
> got answer
>
> On Thu, Jan 24, 2013 at 9:21 PM, Bé Trần Văn
>
Sorry Kahlid,
I am at zero with VBA. Hope some one here will help you out.
On Friday, January 25, 2013 10:15:29 PM UTC+5:30, Sadia Khalid wrote:
>
>
> *@indu prakashany *
> any VBA code for this
>
>
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RU
*@indu prakashany *
any VBA code for this
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not g
Sub test()
Dim wkb As Workbook
Dim pth As String
Dim myname As String
pth = "C:\Documents and Settings\user\Desktop\"
myname = "ashish"
' or try this
'myname = Application.UserName
' or try this
'myname = Environ("username")
Set wkb = ActiveWorkbook
wkb.SaveAs pth & myname & VBA.Format(Date, "_dd
*@indu prakash I know this.
the point is that i have a too bing file for which , there are missing
values. if i use a formula which is column E. i have to do a lot of eating.
whihc will take a lo lot of time. but if i use a formula which is column D
, my work can be done easily if absolute cell ad
You can't use this formula *INDIRECT(ADDRESS(ROW()-1,COLUMN()) for absolute
sell referencing, because as you will switch to next cell all the
references will change.*
*
*
*If your objective is to get the result of column D as column E, you don't
have to use this formula just enter absolute refer
Hi Vignesh
Have you seen the solution i have given to you.
regards
prince
On Friday, January 25, 2013 6:28:53 PM UTC+5:30, Vignesh S R wrote:
>
> Any updates friends???
>
>
> On Sat, Jan 12, 2013 at 11:24 PM, Vignesh S R
>
> > wrote:
>
>> hi All,
>>
>> Need your help guys.
>>
>> Descr
@indu prakash
thanks for your reply. but how i can use this formula
*INDIRECT(ADDRESS(ROW()-1,COLUMN())
for absolute cell addressing.*
*
*
*Thanks *
*
*
*I want to convert the results of column D as Column E.*
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
We are getting different values in column D and E because the formula used
in column D has relative cell reference because of which references are
changing but in case of column E cells are fixed. Result of which when we
are moving to D24, in case of column D references are $D$23 but it column E
NO
its not doing this
see this file
https://skydrive.live.com/redir?resid=DD0BC148DF66DAC4!176&authkey=!ANSe4WnuJ1fhJHo
I want to get the values like in column E in colored cells , the formulas
in both the columns are same except the relative cell referencing.
--
Join official Facebook
Freeze the cell by pressing F4 once, it wil give you "$" symbol along with
the cell adress
On Fri, Jan 25, 2013 at 5:26 PM, Sadia Khalid wrote:
> SALAM
> Hi Every one Hope that all of you are fine.
>
> How i can use this formula to have the absolute cell address.
> =(ADDRESS(ROW()-1,COLUMN()))
>
I stipulated that you wanted this done without macros.
I do not think it is possible to make this "flexible"
so that you can change the date range and have it automatically update
by using sumproduct & indirect.
I included my recommendation (using multiple "IF")
>> =IF(AND(1>=DAY($E$3),1<=DAY($G$
You can WRITE macro for this.
Fairly simple.
There are LOTS of questions though, in order to make it fit your situation.
Q: Are you wanting to save a COPY of the existing file?
as in:
open a template file,
read data,
perform calculations,
do stuff,
save a copy with current data with today's
Hi Khalid,
This will alwsy gives you absolute address
as i placed this formula In H24 and I got $H$23 which is an absolute
address
Regards
Prince
On Friday, January 25, 2013 5:26:13 PM UTC+5:30, Sadia Khalid wrote:
>
> SALAM
> Hi Every one Hope that all of you are fine.
>
> How i can use th
Hi Suresh,
Just Contaenate the Format(Now,"dd-mmm-yy") in the save as statment
for Example :
wbk.SaveAs ThisWorkbook.Path & "\ Prince" & Format(DateTime.Now,
"dd-mmm-yy") & ".xlsx", 51
Regards
Prince
On Friday, January 25, 2013 5:44:59 PM UTC+5:30, suri wrote:
>
> Hi,
>
> I am trying to sa
Hi,
I am trying to save excel file using macro.. The file name should be
my name followed by today's date.
Is there any macro for this?
/Suresh
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor threa
SALAM
Hi Every one Hope that all of you are fine.
How i can use this formula to have the absolute cell address.
=(ADDRESS(ROW()-1,COLUMN()))
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread ti
Dear,
Price,Rajan,Hilary,Noorin,Ashish..& All Expert,
Pls look this matter for solution.
I got answer 90% but 10% is confused why Excel table not copy paste in word.
Pls try
Regards
Amar
On Fri, Jan 25, 2013 at 12:53 PM, amar takale wrote:
> Dear hartmut,
> It not work,it show error.I attache
Hi,
Use attached file, you just need to change data source of chart and you use if
condition.
Thanks & Regards
--- On Fri, 1/25/13, santosh subudhi wrote:
From: santosh subudhi
Subject: $$Excel-Macros$$ Dynamic Charts
To: "excel-macros"
Date: Friday, January 25, 2013, 1:51 AM
Hello Group,
I
Dear Friends,
Please help me. I need a formula to calculate time gap or Net TAT between work
start time & work end Time. It just need to exclude if any holidays are
declared per list.
The assumption is it has 7 days working in a week except declared holiday.
Sr. No.
work Start Time
Work End
21 matches
Mail list logo
