Re: $$Excel-Macros$$ Change Cell based on Selection of Other cell

Hi It is possible by combination of name and data validation Name..The variable cell Apply data validation On 10 Jul 2017 5:29 pm, "Vijayendra Rao" wrote: Hi Experts, Request you to help to resolve this below query. Need to change the cell based on selection of

Re: $$Excel-Macros$$ Drop down button in cell

Dear Rakesh, U can use DataValidation Fill the options in the Range:List Regards Ramkesh On Mon, Apr 11, 2011 at 3:54 PM, rakesh kumar rakeshshail2...@gmail.comwrote: HI Group, I have been trying to put one drop down menu in cell, which should be visible only when the particular cell is

$$Excel-Macros$$ Distribution-Supply Chain/Retail Sector

to consider the priority for Branches ?* Thanks Regards Ramkesh Maurya Cell: 9958723273 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com

$$Excel-Macros$$ Own Formule in Pivot Table

Hi All, Please tell me how i can insert my own formule in Excel. e.g 2 is 5.71% of 35 the Grand Total, in next column I want to sum the percentage of 2( i.ee5.71) + percentage of 3 (i.e. How much 3 is fraction of 35 ?) *Item* *Quantity* *Cumuletive Sum* A 2 5.71% B 3 C 4 D 5 E 6 F 7

Re: $$Excel-Macros$$ dynamic range (table_array) in vlookup formule

Dear Carlo, Select Range Q:R i.e. both entire col and vlookup is enough Regards Ramkesh On Thu, Oct 7, 2010 at 5:48 PM, cg cuoredicapit...@gmail.com wrote: Hi everybody I’ve a big trouble but maybe, for you is an easy trouble. I’m working on excel2003. I’ve to compare two values, in the

Re: $$Excel-Macros$$

, or the This workbook module. *From:* Ramkesh Maurya sunscel...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Thu, September 30, 2010 10:51:38 AM *Subject:* Re: $$Excel-Macros$$ Hi Dave, I copied the code but unable to execute it, Can u please tell me where I am wrong? Regards

Re: $$Excel-Macros$$

Dear Dave, Thanks for paying attention, Yes I am allowed to use Macro I want the date in Col B only when the adjecent cell Col A received some text for the first time Regards Ramkesh On Wed, Sep 29, 2010 at 7:50 AM, Dave Bonallack davebonall...@hotmail.comwrote: A further question: Do you

$$Excel-Macros$$

Dear All, Xl Mania(s) I really appreciate this group for learning I have lrarnet a lot of tricks from this group which enabled me to come of with flying colours.Today i am posting my first query briefing in below lines--- 1- I fill some text in column A (say) 2- I want that the date of

Re: $$Excel-Macros$$ Top ten distributor

Hi Kalyan, Please use DATAFilterCustom FilterTop Ten Regards Ramkesh On Tue, Aug 17, 2010 at 11:21 AM, Kal xcel kalx...@gmail.com wrote: Dear experts, I have SAP sales data, how to get top 10 distributor frm that huge data. One distributor billed many times. Is there any mechanism??

Re: $$Excel-Macros$$ Removing selected letters and symbols from a cell

Dear Cargill, I have prepared formule based on your file Regards Ramkesh On Wed, Aug 18, 2010 at 5:21 PM, Alexander Cargill zanderman1...@googlemail.com wrote: Hi all I was wondering if you could help. I have a sheet with entrys into a cell that looks like this: AAECHO::DELTA

Re: $$Excel-Macros$$ Help for Pick data from access to Excel

Dear Umesh, I will suggest u to line Access and Excel,DataImportNew QueryAccess or Home Access etc I hope this will help you Regards Ramkesh 9990260398 On Sat, Aug 7, 2010 at 8:46 PM, Umesh Matkar matkarum...@gmail.com wrote: **Dear All, I need your help I have some Mobile nos in 'a'

Re: $$Excel-Macros$$ Convert Numeric Value in Character.....

Dear Sudhir, Write =SpellNumber(cell) and press Enter I am sure u will get result On Mon, Aug 9, 2010 at 11:37 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Experts, I need to convert Numeric Value in charaters..Is it possible through excel or Macro. Example... 25302- *Twenty