Re: $$Excel-Macros$$ Damage Files

2010-05-29 Thread Harpreet Singh Gujral
Siva, Would you like to share your knowledge on how to recover a damaged file wit the group Thanks in advance Harry On May 28, 10:34 am, Siva Kumar Vemula wrote: > hi, > > please find attached recovered file with some data lost. > > regards, > siva > > On 5/27/10, Parag Dafal wrote: > > > > >

$$Excel-Macros$$ Convert 2007 to 2003

2010-05-29 Thread Harpreet Singh Gujral
Hi Group, Please suggest a software to convert an excel 2007 file to excel 2003 version Alternative which is free to use :) Thanks Harry -- -- Some important links for excel users: 1. Follow us on TWITTER for tips

$$Excel-Macros$$ Re: Hi!!!!!!!!! to all Member

2010-05-29 Thread Harpreet Singh Gujral
I also faced the same issue, As of now, if i need to reply to a post, i copy the subject of the post and then set it as a subject of my email to the group, and within that email i attach the files(if any) If there is any other way to attach files to the replies, please let us know Harry On May

Re: $$Excel-Macros$$ PAID LIST TRACER

2010-05-29 Thread Aindril De
Hi Siva, It would be great if you can send a sample file explaining the issue. REgards, Andy On Fri, May 28, 2010 at 3:37 PM, siva wrote: > Dear Team, > > Please help me . I HAVE LAST YEARS STUDENT PAID LIST . > i have NEW paid list of students NOW I WANT TO COMPARE IT THE BOTH > PAID LIST.

$$Excel-Macros$$ Re: Unable to open workbooks from custom functions?

2010-05-29 Thread Ashish Jain
Hi Mike, You cannot use Event Methods like Open, Activate, Select etc in Custom Functions. Regards Ashish Jain Microsoft Certified Application Specialist (Excel) http://www.excelitems.com http://www.openexcel.com __ On May 28, 9:11 pm, Mike Ratcliffe wrote:

$$Excel-Macros$$ Institutions in Hyderabad (India)

2010-05-29 Thread Omer Syed
Hello, I will be visiting Hyderabad for a few months and would like to know the best institutions teaching Advanced Excel & VBA Macros there. -- -- Some important links for excel users: 1. Follow us on TWITTER for ti

$$Excel-Macros$$ AUTOMATIC UPDATE IN SHEET1 ON NEW DATA ENTRY IN SHEET 2

2010-05-29 Thread OPSHARMA
Dear Experts, I have two excel sheet, one main sheet and 2nd summary sheet. I want to add the data of a colomn when new item has been added in main sheet. Pls guide. Regards O.P.Sharma -- -- Some important links

RE: $$Excel-Macros$$ How to insert sheets name in cells

2010-05-29 Thread nilaratna
The macro crashes with an error and then when I try to look at the code, I cann’t because there is a password on it. Could you please post the password and in future it would be more useful to most members if your attachments were not password protected so we can see how it works. Thanks

$$Excel-Macros$$ Formula required

2010-05-29 Thread Aamir Shahzad
Dear all, Vlookup pick only one value from desired sheet but I want to pick multiple values. Is there any formula to pick values & automatically insert rows without any micro because I don't have idea. Sheet attached. Regards, Aamir Shahzad -- --

$$Excel-Macros$$ help in excel formula

2010-05-29 Thread Surendra saxena
Hi All, need you help to fix the formula in excel like below- (-Today+End.date) i want to fix the formula in excel which reflect always previous day value instead on today. -- Your's Surendra -- -- Some important

$$Excel-Macros$$ Unable to open workbooks from custom functions?

2010-05-29 Thread Mike Ratcliffe
I have a custom function that needs to read data from an external worksheet. To make sure that the workbook is open I use the following method: Sub EnsureWorkbookOpen(ByVal fPath As String, ByVal fName As String) On Error Resume Next Err.Clear Workbooks(fName).Activate If Err.Numb

$$Excel-Macros$$ Need connection String of oracle in Excel VBA

2010-05-29 Thread shariq khan
Hi All Macro Champs, I need your help, can some one provide me an example to connect to the oracle server using excel VBA. Note: I’m creating one macro for my office use so I can’t install any addin on my system. Thanks in -- Thanks and Reagrd’s Shariq Shazad Khan -- ---

$$Excel-Macros$$ PAID LIST TRACER

2010-05-29 Thread siva
Dear Team, Please help me . I HAVE LAST YEARS STUDENT PAID LIST . i have NEW paid list of students NOW I WANT TO COMPARE IT THE BOTH PAID LIST. AND IN THE NEW PAID LIST I HAVE TO ADD SECTION FROM THE LAST YEARS PAID LIST AND HIGHLIGHT THOSE ARE NOT PAID.I THINK I AM NOT VERY CLEAR BUT I DON'T N

$$Excel-Macros$$ Re: Erro facing in attached file

2010-05-29 Thread Naveen Sharma
Sorry forgot to attache file. Here it is. Naveen On 5/28/10, Naveen Sharma wrote: > > Dear All, > > I have attached an excel contain Macro for converting number in word. > > Problem- I have saved this macro in an excel file but when some one other > open that file from their computer that forum

$$Excel-Macros$$ Erro facing in attached file

2010-05-29 Thread Naveen Sharma
Dear All, I have attached an excel contain Macro for converting number in word. Problem- I have saved this macro in an excel file but when some one other open that file from their computer that forumula shows error "Name#". What I can do to solve this problem. Please suggest. Naveen 98219 80081

$$Excel-Macros$$ Re: eliminating repetitive code in a macro

2010-05-29 Thread Stuart Redmann
On 27 Mai, 17:08, molinari wrote: > I have a macro for which I want to eliminate repetitive code. I have > two sets of sheets, which match in different ways and are > systematically labelled. There are sheets with numbers 1 to n, which > also have a postfix "a" or "b". Different things need to b

$$Excel-Macros$$ Hi!!!!!!!!! to all Member

2010-05-29 Thread saggi
Kindly let me know how to attach file here, Many of guys are facing same issue -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join

Re: $$Excel-Macros$$ New to the group - basic question

2010-05-29 Thread C.G.Kumar
It is aimed to calculate markup. On Fri, May 28, 2010 at 12:15 AM, markndawoods wrote: > what is this formula designed to provide? > > =F24/(1-F25) > > where cell F24 is a dollar figure of $18.25 > and cell F25 is a percent 65% > > It is in a spreadsheet I use at work and am just courious as to w

Re: $$Excel-Macros$$ How to insert sheets name in cells

2010-05-29 Thread WizExcel
Hi Rahul, is it possible to do the reverse?, Suppose i create a new sheet and paste some data in it . Now i want to name this sheet with the contents of a particular cell, say, cell D15 is 'May 15- Action Points', I want to name my sheet as this 'May 15- Action Points' thanks Sameer On May 2

$$Excel-Macros$$ Re: New to the group - basic question

2010-05-29 Thread saggi
what is this 65% of some value yaa 35% of the value hmmm need details of this If 18.25 is portion 35% of the then it will give u 100% of the value by this formula -- -- Some important links for excel users: 1. Fol

Re: $$Excel-Macros$$ Help breaking out data on single worksheet to multiple worksheets

2010-05-29 Thread WizExcel
Paul , it would be really helpful if you let me know if there is any way in which we can do this : Filter a data on say Column A (column A data has 10 unique values ) first, then on Column B (But this column No. of values keep on changing, sometimes 9 , sometimes 10, 11,) and then prepare separat

$$Excel-Macros$$ Re: New to the group - basic question

2010-05-29 Thread Yogesh Kudva
Hi, 1 - 65% = 100% - 65% = 35% 18.25 / 35% = 52.14 Regards, Yogesh On May 27, 11:45 pm, markndawoods wrote: > what is this formula designed to provide? > > =F24/(1-F25) > > where cell F24 is a dollar figure of $18.25 > and cell F25 is a percent 65% > > It is in a spreadsheet I use at work and

Re: $$Excel-Macros$$ New to the group - basic question

2010-05-29 Thread Swapnil Palande
Hi, =F24/(1-F25) In above formula (1-F25) will give you 35%. So basically you are dividing $18.25 by 35%. It will give you the value of 100% (i.e. if $18.25 is 35% then what is 100%) For ex: If I purchase xyz product for $18.25 with 65% discount on it. Now I want to calculate the original price o

Re: $$Excel-Macros$$ Ms-Excel Bible2007 by john walkenbach

2010-05-29 Thread Viraj Bhatia
Could you please send me the file .. thanks in advance.. On Sat, May 15, 2010 at 12:19 AM, wrote: > Yes, would you please send to me also? Many thanks. > > Sent from my BlackBerry Smartphone provided by Alltel > -- > *From: *sudhir kumar > *Date: *Fri, 14 May 2010

$$Excel-Macros$$ Re: New to the group - basic question

2010-05-29 Thread Harpreet Singh Gujral
Hi, What it is doing is, mathmatically it may look like as follows: = 18.25/(1-.65) which is again equal to =18.25/0.35 Oh, i think your formula wants to achieve this 1) Lets assume a figure as X, while the figure 18.25 is 35% of X, in order to know what the figure X is, you will apply the form