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

Hi, I got answer in VBA. Attached is the updated file. Regards, Vijayendra 2017-07-23 6:00 GMT+05:30 who : > Unless the IF() statement has changed, it only allows 7 nested ifs, which > is not sufficient to do this with out the use of VBA. Thanks, David > > > On Monday,

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

Unless the IF() statement has changed, it only allows 7 nested ifs, which is not sufficient to do this with out the use of VBA. Thanks, David On Monday, July 10, 2017 at 4:59:17 AM UTC-7, Vijayendra wrote: > > Hi Experts, > > > Request you to help to resolve this below query. > > Need to change

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

On Fri, 7/21/17, Vijayendra Rao <vijayendrar...@gmail.com> wrote: Subject: Re: $$Excel-Macros$$ Change Cell based on Selection of Other cell To: excel-macros@googlegroups.com Date: Friday, July 21, 2017, 1:09 PM Hi Ramkesh,

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

Hi Ramkesh, Thanks for the reply, I tried to find out the solution as per your suggestion. I couldn't succeed further. Can you please elaborate further. Regards, Vijayendra 2017-07-10 19:52 GMT+05:30 Ramkesh Maurya : > Hi > It is possible by combination of name and data

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$$ Change Cell based on Selection of Other cell

Hi Vijay, Herewith i have attached the completed excel. By, Suresh Cell : 9894585740 On Monday, July 10, 2017 at 5:29:17 PM UTC+5:30, Vijayendra wrote: > > Hi Experts, > > > Request you to help to resolve this below query. > > Need to change the cell based on selection of other cell. Attached

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

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 sample file, in this file Column E3 should contains based on the active cell selected between A2:A14. Is it possible to do with any functions / macros.