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=
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
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
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
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-
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
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$
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))
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