$$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

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, tanner@gmail.com wrote: Yes, would you please send to me also? Many thanks. Sent from my BlackBerry Smartphone provided by Alltel -- *From: *sudhir kumar

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

$$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 markndawo...@molalla.net 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

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

$$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.

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

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 markndawo...@molalla.netwrote: 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

$$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

$$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$$ 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

$$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$$ 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

$$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$$ 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 --

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$$ 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

$$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

$$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

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 nmaster...@gmail.com 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