Search results

Hi Iam Sure I don't understand, Moreover please be elaborate or upload ur workbook for getting assistance For Your Q, Scroll bar and Option button can be added using control tool box Senthilkumar_rm

Hi Nuetrino, You can also try this as well ="00"&RIGHT(A1,2)&AND(D1="dec")*12+(D1="Nov")*11+(D1="Oct")*10+(D1="Sep")*9+(D1="Aug")*8+(D1="Jul")*7+(D1="Jun")*6+(D1="May")*5+(D1="Apr")*4+(D1="Mar")*3+(D1="Feb")*2+(D1="Jan")*1&RIGHT(E1,2) Thanks Senthilkumar_rm

Hi all, I have data as Column A Column B 1 Wallpaper some picture object 2 Logo Picture 3 Personalities Picture In Cell D1 , i have done data validation with list >source > A1 to A3 in cell E1, i need the corresponding picture when i choose D1

Hi Ya i got it thanks Senthil

Hi Hui, Thanks for reply Data (From A2 to A5) A2 - Sales A3 - Profits A4 - Percentage A5 - Quantity In C1 , I have used data validation (route : Data > Validation > List > Source(A2 : A5) In E1 , I have used Match formula =MATCH($C$1,$A$2:$A$5,0), when i selected Sales...

Hi Experts, What is the use of Match type in Match formula, For any Value/ Not given entered , It gives same result Thanks

Hi Hui, Thanks for Encouraging ! Ya, Interested with pictures etc., Sorry, I dont find ur mail ID Thanks

Hi Solvers, Greetings !! We are in phase of creating a form - Date is one of the field , User has to enter from and to date , For that i want to show a calendar with condition Past - 3 Years from today's date and upto present date, User is not allowed to choose beyond these dates Thanks

Hi Helpers, We have completed "MOS Specialist" exam for Excel 2007, We would like to do more learning and get expertises with second level "MOS - Expert" We are unable to find Training Institute for learning !! We are In Chennai, India Thanks

Dear Solvers, Help Me in solving this !! I have an sheet, In which user will enter name of person whom he wants to send Mail for Eg; senthilkumar . The Lotus notes(what we are using) should open and search the address book or directory and show result in To"field automatically Thanks...

Dear Readers, I would like to share my learning!! Scenario: For check list we often use Check box (For actions completed We will tick those check box) What if you want to change the cell colour to green when check box is enabled Here is step By step Method to do : 1. Place a check box in...