$$Excel-Macros$$ Data Validation and Unique Array Values

2016-06-09 Thread 'The Frog' via MS EXCEL AND VBA MACROS
Hi Everyone, I have a question relating to data validation formulas: I have two columns that I am using for defining details for products. The first column is called Category. The data validation for this is done from a simple named range called "Category" and is working properly. The second c

$$Excel-Macros$$ Help to create data table

2016-06-09 Thread Rabindra Thapa
Dear Excel guru, Can you give a idea how to create date enter sheet as per attach file.. i.e when i entry data on sheet 1 and entry press button, that data automatically go to sheet 2 . kindly see the attach file. Regards, Rabin -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wa

Re: $$Excel-Macros$$ Re: Excel is showing different data on other sharing computer

2016-06-09 Thread Pravin Gunjal
Thanks for reply. The path and file is unique. One sheet was hidden at the time of screenshot taken on other computer. *With regards,**Pravin Gunjal* *Mobile: 77100 * *97250* On Wed, Jun 8, 2016 at 5:14 PM, B Sharma wrote: > Hiii Pravin,, > From your screen shot I think that both the files

$$Excel-Macros$$ Re: How to convert Pivot

2016-06-09 Thread Suresh Kumar B
Hi, Herewith i have attached the Completed file. Please check and ask, If any. Thanks&Regards, Suresh Kumar.B Mobile # :9894585740 On Thursday, May 26, 2016 at 3:49:59 PM UTC+5:30, sonu wrote: > > > Dear Expert, > > I want a macro to convert data from pivot form to normal form. > > > > -- >