> 7 days so you would have 52 sheets.
> I have changed it to use Jan 1, 2012 as the starting date, adding a week
> for each sheet. See attached,
>
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
> -----Original Message- From: Susan 1
> Sent: Wednesday,
t; SalesAid Software
> dguille...@gmail.com
>
> From: Susan 1
> Sent: Wednesday, December 07, 2011 2:10 PM
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Formula or macro to add names to sheets in one
> workbook
>
> I copied and pasted your code from b
uot;).Copy After:=Sheets(Sheets.Count)
> ActiveSheet.Name = _
> Format(DateSerial(Year(Date), 1, i), "mmm dd")
> Next i
> End Sub
>
>
> ‘=
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Susan 1
> *Sent:* Tuesday, December 06, 2011
remove Formula Cell range under Formula range.
> --
> Thanks & regards,
> Noorain Ansari
> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>
> On Wed, Dec 7, 2011 at 5:55 AM, Susan
Thank you Chethan!
On Wed, Nov 23, 2011 at 10:17 PM, B.N.Chethan Kumar <
chetankumar1...@gmail.com> wrote:
> Hi Sunnie,
>
> The attached file with the condition format. Hope these is what your
> requirment was.
>
> Regards
> Chethan Kumar BN
> On Thu, Nov 24, 2
I’m having trouble using the conditional formatting.
I’m trying to get a calculated value (would like to use the IF function),
on the YTD spreadsheet from Cells D17 through M28, to become Red Font,
based on the value of the Cell in C18 through C28, "2011 Unit Target"
Currently I am updating the sp
Hi ~
Wondering if you could assist me with the Text import wizard to configure
the columns and tab delimiter for the attached txt file. And then send me
the steps.
I will be needing to do this every week to the same types of txt files,
importing into Excel and I’d like to create a Macro for th
No need to answer I have the formula, thanks!
{=IF(ISERR(MEDIAN(IF($F$5:$F$17=4,$H$5:$H$17))),"No Minutes Done for This
Unit",MEDIAN(IF($F$5:$F$17=4,$H$5:$H$17)))}
On Thu, Mar 24, 2011 at 9:01 AM, Anderson, Susan wrote:
> Hi ,
>
> Can you help me with the formula below? See Tab Mar 05, column AB
