Re: $$Excel-Macros$$ Dynamic Charts

2013-01-25 Thread ravinder negi
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

Re: $$Excel-Macros$$ VBA Help:Excel table copy paste in word (with formatting as it)

2013-01-25 Thread amar takale
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

$$Excel-Macros$$ Save excel with date

2013-01-25 Thread suresh k
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

$$Excel-Macros$$ Re: Save excel with date

2013-01-25 Thread Prince
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

$$Excel-Macros$$ Re: Cell Referencing

2013-01-25 Thread Prince
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

Re: $$Excel-Macros$$ Save excel with date

2013-01-25 Thread Paul Schreiner
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

Re: $$Excel-Macros$$ Consolidate data from 31 sheets to one master sheet

2013-01-25 Thread Paul Schreiner
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)

Re: $$Excel-Macros$$ Cell Referencing

2013-01-25 Thread Shaik Waheed
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.

$$Excel-Macros$$ Re: Cell Referencing

2013-01-25 Thread Sadia Khalid
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

$$Excel-Macros$$ Re: Cell Referencing

2013-01-25 Thread indu prakash
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

Re: $$Excel-Macros$$ Re: Cell Referencing

2013-01-25 Thread Sadia Khalid
@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

Re: $$Excel-Macros$$ Macro to send data from one master sheet to multiple sheets

2013-01-25 Thread Prince
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

Re: $$Excel-Macros$$ Re: Cell Referencing

2013-01-25 Thread indu prakash
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

Re: $$Excel-Macros$$ Re: Cell Referencing

2013-01-25 Thread Sadia Khalid
*@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

Re: $$Excel-Macros$$ Save excel with date

2013-01-25 Thread ashish koul
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,

Re: $$Excel-Macros$$ Re: Cell Referencing

2013-01-25 Thread Sadia Khalid
*@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

Re: $$Excel-Macros$$ Re: Cell Referencing

2013-01-25 Thread indu prakash
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

Re: $$Excel-Macros$$ Formula to Replace 2nd List with Master List

2013-01-25 Thread Bé Trần Văn
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

FW: $$Excel-Macros$$ Calculate Net TAT / time Gap excluding Holidays as per list

2013-01-25 Thread Amit Desai (MERU)
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