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 other cell. Attached is the sam

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

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

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

$$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 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 same pivot table, usin

Re: $$Excel-Macros$$

r the This workbook module. > > > *From:* Ramkesh Maurya > *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

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 wrote: > A further question: Do you want the date in Col B to

$$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 DATA>Filter>Custom Filter>Top Ten Regards Ramkesh On Tue, Aug 17, 2010 at 11:21 AM, Kal xcel 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?? > > Thanks in adv

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:

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 wrote: > Dear Experts, > > I need to convert Numeric Value in charaters..Is it possible through excel > or Macro. > > Example... > > 25302- *Twenty Five thousand thr

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

Dear Umesh, I will suggest u to line Access and Excel,Data>Import>New Query>Access or Home >Access etc I hope this will help you Regards Ramkesh 9990260398 On Sat, Aug 7, 2010 at 8:46 PM, Umesh Matkar wrote: > **Dear All, > > I need your help > > I have some Mobile nos in 'a' colmn ..and that