$$Excel-Macros$$ daily data into weekly data

> > Columns(1).Insert > With Range("b2", Range("b" & Rows.Count).End(xlUp)).Offset(, -1) > .Formula = "=if(and(weekday(b2,2)),1,)" > .Value = .Value > On Error Resume Next > .SpecialCells(2, 1).Offset(0, 1).Delete Shift:=xlUp > .SpecialCells(2, 1).Of

Fwd: $$Excel-Macros$$ MS Excel 2003 to 2010

Good morning all. Sorry ! I did not used *Please help.* in my earlier mail. Request you to help me. Thanks Prashant. -- Forwarded message -- From: Prashant Pednekar Date: Mon, Oct 14, 2013 at 3:21 PM Subject: $$Excel-Macros$$ MS Excel 2003 to 2010 To: excel-macros@googlegroups.c

$$Excel-Macros$$ Re: Email Trigger ?

Ok Bill, any questions let me know ... Em domingo, 6 de outubro de 2013 17h34min31s UTC-3, Bill Q escreveu: > > Hi, > > I am using Excel 2007 and have Gmail as my primary email account. > > I have a dynamic spreadsheet that monitors different stock prices that is > refreshed ever "x" amount o

$$Excel-Macros$$ Re: Email Trigger ?

My apologies Basole, I was out of town for a few days. I will try out your recommendations tomorrow as it appears that you have been successful. I will keep you posted. Thanks again. On Tuesday, October 8, 2013 5:03:54 PM UTC-4, Basole wrote: > Bill, enable reference, as indicated Ashish

Re: $$Excel-Macros$$ Two spreadsheets , compare and produce a 'difference' spreadsheet

Oops sorry.. A small cut-down example , along with the manually created 3.xlsx output that i'd like to have automated has been added to my original post. -- 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

Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 1 Message in 1 Topic

can u please post ur query with sample file On Mon, Oct 14, 2013 at 12:32 PM, Samuel laryea wrote: > I need help on excel > On Oct 13, 2013 11:34 PM, wrote: > >> Today's Topic Summary >> >> Group: http://groups.google.com/group/excel-macros/topics >> >>- Excel to >> OpenOffice?<#141b5c67

Re: $$Excel-Macros$$ Need some help modifying a copy and paste routine

try this Sub cop_dates() On Error Resume Next Sheets("ATS Data").UsedRange.Clear Dim i As Long Dim dt As Date dt = #4/16/2013# Sheets("Raw ATS Data").Range("a1:s1").Copy Destination:=Sheets("ATS Data").Range("a1") For i = 2 To Sheets("Raw ATS Data").Range("a1048576").End(xlUp).Row If She

Re: $$Excel-Macros$$ Need some help modifying a copy and paste routine

It is somehow attached to the first post in the thread, you'd have to expand all threads to see it. On Saturday, October 12, 2013 7:36:09 AM UTC-7, ashish wrote: > > attachment is missing > > > On Fri, Oct 11, 2013 at 3:48 AM, Justin Pulley > > > wrote: > >> Was the attached file what you were

RE: $$Excel-Macros$$ Two spreadsheets , compare and produce a 'difference' spreadsheet

Give some example..with xlsx file. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of garfin.in...@gmail.com Sent: Monday, October 14, 2013 11:09 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Two spreadsheets , compare and produce a 'differe

$$Excel-Macros$$ MS Excel 2003 to 2010

Dear friends We are migrating from MS Excel 2003 to Excel 2010 Dose any one of you has Menu and commond by command comparion in both version.s i.e. 2003 2010 Data > Validation ??? Else is anyone has related material. Regards Prashant -- Are you =EXP(E

Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 1 Message in 1 Topic

I need help on excel On Oct 13, 2013 11:34 PM, wrote: > Today's Topic Summary > > Group: http://groups.google.com/group/excel-macros/topics > >- Excel to OpenOffice? <#141b42bd163b3328_group_thread_0> [1 Update] > > Excel to > OpenOffice?