RE: $$Excel-Macros$$ Formula for calculate max number for unique values

2013-11-03 Thread Ravinder
PFA with two solution, if you are looking for this. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ali Abbas Sent: Saturday, November 02, 2013 2:33 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Formula for calculate max number for unique

Re: $$Excel-Macros$$ Halp Neede in Sheet Protection Macro

2013-11-03 Thread Secret Shot
Thanks Team XLS, It works for me, Thanks you so much.. On Sun, Nov 3, 2013 at 6:37 PM, xlstime wrote: > As desired, Please find attached sample sheet > > . > > Enjoy > Team XLS > > > > On Sun, Nov 3, 2013 at 2:06 AM, Secret Shot wrote: > >> Dear Experts, >> >> I am

$$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST

2013-11-03 Thread Basole
Hi Sandeep, what is the error message that appears? Basole. Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar Baranwal escreveu: > > Hi > > Kindly note that sql.request is functional in MS Excel 2007 but not in MS > Excel 2010. Could you please let me know any VBA code t

Re: $$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST

2013-11-03 Thread Sandeep Kumar Baranwal
Hi Basole Thanks for the file. Just wanted to continue with the discussion. Actually , I am trying on an another version of this VBA using worksheet_calculate, just to, do away with the shape "Import" and use dropdown list in MS Excel (based on Primary key of MS Access) and import data from MS Ac