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 santoshkumar.subu...@gmail.com wrote:
From: santosh subudhi santoshkumar.subu...@gmail.com
Subject: $$Excel-Macros$$ Dynamic Charts
To: excel-macros
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 amartak...@gmail.com wrote:
Dear hartmut,
It not work,it
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
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 save excel file
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 this
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
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)
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 sadiakhalid...@gmail.comwrote:
SALAM
Hi Every one Hope that all of you are fine.
How i can use this formula to have the absolute cell address.
NO
its not doing this
see this file
https://skydrive.live.com/redir?resid=DD0BC148DF66DAC4!176authkey=!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
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
@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
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
srvign...@gmail.comjavascript:
wrote:
hi All,
Need your help
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
*@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
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,
*@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
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 RULES
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 amartak...@gmail.com:
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
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
19 matches
Mail list logo