Re: $$Excel-Macros$$ VBA - how to account for weekends?

2014-01-11 Thread ashish koul
can u share excel file On Tue, Jan 7, 2014 at 2:08 AM, June Scanlon wrote: > Using Excel 2010 & 2013 (will be used in both versions), what is the best > way to create a variable date that excludes weekends (and holidays, if > possible)? > > My scenario, where PrevDate= 2014-Jan-02 and LastDate=

Re: $$Excel-Macros$$ Importing Excel Files

2014-01-11 Thread ashish koul
so only dates in middle will be changing right? On Thu, Jan 9, 2014 at 9:06 AM, Linda C wrote: > There are around 40 files in the folder, but not all of them are needed. > > The names are like > "COUNTY_CALIFORNIA_01350143_Main.xlsx": If the file name starts with > "COUNTY_CALIFORNIA" and end

Re: $$Excel-Macros$$ Re: help!!! creation code from data in cells

2014-01-11 Thread ashish koul
can u share excel file On Thu, Jan 9, 2014 at 5:07 PM, pmyk wrote: > In an excel file, > Change Sheet1 Name as Report and type these: > Sr. Center Name Course Date of Enrol Code > 1 Alma Computer Training Institute Suraj basic computer Course 31/12/13 > 2 Center3 Name1 Course 5 1/1/2014 > 3 Cen

Re: $$Excel-Macros$$ Mouse Hover custom tool tip on chart data label.

2014-01-11 Thread ashish koul
you can use chart events http://peltiertech.com/WordPress/chart-event-class-module-to-highlight-a-series/ http://msdn.microsoft.com/en-us/library/office/bb211434(v=office.12).aspx http://www.databison.com/interactive-chart-in-vba-using-mouse-move-event/ On Fri, Jan 10, 2014 at 2:01 PM, Divaker

Re: $$Excel-Macros$$ Power Pivot

2014-01-11 Thread renuka chari
thank you sir.. On Saturday, 30 November 2013 23:45:11 UTC+5:30, ashish wrote: > > visit below links > > you can create maps , etc in Excel 2013 > > > http://office.microsoft.com/en-in/excel-help/what-s-new-in-excel-2013-HA102809308.aspx > > http://www.techrepublic.com/blog/10-things/10-best-

$$Excel-Macros$$ Excel to Import from SmartSheet

2014-01-11 Thread Cab Boose
I want to use an Excel workbook with 2 or 3 sheets with different small databases. One of the databases is to come from the web, from a SmartSheet spreadsheet. Once the data into the .xls sheet I will run a macro to run a report using vlookup etc To run the report I want a one button press to

Re: $$Excel-Macros$$ Macro Code??

2014-01-11 Thread Deepak Rawat
Thanks Ravi its working fine! On Fri, Jan 10, 2014 at 3:29 PM, Ravinder wrote: > PFA > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Deepak Rawat > *Sent:* Thursday, January 09, 2014 10:55 AM > *To:* excel-macros > *Subject:* $$Excel-Macros$

Re: $$Excel-Macros$$ Macro to replace cell reference or addresses with their individual calculated values

2014-01-11 Thread ashish koul
try this Sub test() Range("d2:d8").Value = Range("d2:d8").Value End Sub On Sat, Jan 11, 2014 at 1:38 PM, Mukesh Kumar wrote: > Hello Experts > > Please provide me solution for the query given in attached file. > > Thanks & Regards, > Mukesh Kumar > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT))

$$Excel-Macros$$ Macro to replace cell reference or addresses with their individual calculated values

2014-01-11 Thread Mukesh Kumar
Hello Experts Please provide me solution for the query given in attached file. Thanks & Regards, Mukesh Kumar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel F