> 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
Hi Noorain,
The macro only worked for the first sheet, after I run it again I receive
this error #: 1004
Sheets(Sheets.Count).Name = Sheet18.Cells(i, "A").Value
On Tue, Dec 6, 2011 at 8:09 PM, NOORAIN ANSARI wrote:
> Dear Susan,
>
> Please try it and
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
sheets
Hello Susan,
Use sheet name as 3 alphabets like, Jan, Feb, Mar, Apr, May, Jun, Jul, Aug,
Sep, Oct, Nov, Dec, not like Sept, Jul, June etc...
This will give the total from Jan to current month (Aug). When next month
comes, this will automatically include Sep. (Jan-Sep), for Oct (Jan-Oct),
etc
I like all those charts and pivot tables ... I agree that the way he has it
layed out is not very functional... too scattered.
Should maybe Adam try PowerPivot??-- at least he could pull all the data
into a more organized structure and then create more efficient and logical
looking charts.
http:/
see if it helps
On Tue, Jul 12, 2011 at 6:33 PM, Susan wrote:
I did that. See the excel spreadsheet I attached. My question was how can
I move over the imported txt file format and into the excel spreadsheet
format under the appropriate column headings… I was thinking I did the
data=>import External Data = >select datasource=>select the appropriate
option=>ok
On Tue, Jul 12, 2011 at 8:22 AM, Susan 1 wrote:
Hi,
Need your help. How can I do this project faster than manually CTRL+ X ,
then CTRL+ V , to delete and paste contact information into approp
Couldn’t you just edit the sheet name “BASE” to the new sheet name, from the
VBA screen?
Or
See this link on how to copy macros to other worksheets.
http://office.microsoft.com/en-us/excel-help/copy-a-macro-module-to-another-
workbook-HP010014116.aspx
~S
From: excel-macros@googlegrou
...@gmail.com
Subject: Re: $$Excel-Macros$$ Sumif across multiple worksheets
Hi Susan,
The result calculated is 2 which is correct as only two rows, mentioned
below, are having the results (i.e., 1) as per your criteria :-
row # 5 of sheet1
row #16 of sheet 2
Now, some of our group members
you use more references here.
>
> Let me know if this works.
>
> Thanks,
> DILIPandey
>
> On 7/1/11, Susan 1 wrote:
>
>
>
>
>
>
>
>
>
> > Hi,
> > I cannot figure out Excel won't let me select different ranges from multiple
> > wo
http://www.excel-vba-easy.com/
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ritesh Jain
Sent: Saturday, June 04, 2011 12:57 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ How to record a macro
Dear Friends,
Can someb
Thank you!
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of GoldenLance
Sent: Monday, June 13, 2011 7:14 AM
To: excel-macros@googlegroups.com
Subject: Re: RE: $$Excel-Macros$$ Please help to make my project good.
=SUM(OFFSET(A5,0,0,MATCH(MAX(A$5:A$999)
Hi,
Please see attached spreadsheet in sheet named Practice OFFSET for my question.
Basically, how do you edit the formula to keep summing the column if you skip
a cell in the column and enter numbers at random cells in the same column.
Thanks
~Sunnie
From: excel-macros@googlegroups.co
I use http://pdftransformer.abbyy.com/
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of vikas gupta
Sent: Tuesday, April 26, 2011 2:46 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Conversion of PDF Data To Excel Sheet
HI BADAL
You have to open up Visual Basic from toolbar and paste in Ashish's coding
in the module. Then save.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Jeannie
Sent: Wednesday, May 25, 2011 8:30 AM
To: MS EXCEL AND VBA MACROS
Subject
ets(1).Cells(i, 3).Value) - 1)
End If
Next i
s.Sheets(1).Columns("D:D").Delete Shift:=xlToLeft
End Sub
On Thu, May 19, 2011 at 8:59 PM, Susan 1 wrote:
Hi Jsin -
I've attached an example of the formatted spreadsheet and the raw data txt
file, the macro or VB I need wo
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
Thank you!:-)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashish koul
Sent: Tuesday, March 29, 2011 10:30 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Useful Link ( Excel, Access, Word, Powerpoint )
VBA
Hi all
To learn ad
Congrats Ashish! I agree that he is most helpful J
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ayush Jain
Sent: Saturday, April 02, 2011 6:25 AM
To: excel-macros
Subject: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - March 2011
Hello Every
t counting the blank cells the answer is 0 or
zero.
How can i tell excel to add on the blank cells to my formula,
=COUNTIFS($E$5:$E$34,15,$G$5:$G$34,">=09:00:00",$G$5:$G$34,"<=19:00:00")
ds that number to any blank cells
from those two criterias.
Thank you! Your help is appreciated J
~Susan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashish koul
Sent: Thursday, March 31, 2011 7:24 PM
To: excel-macros@googlegroups.
will allow averaging of total amount of blood
pressure numbers
see if it helps
On Sun, Mar 27, 2011 at 10:58 PM, Susan wrote:
Hi experts!
I have a project to do given to me by a doctor that has a series of blood
pressure results (numbers) from various patients. And would like me to
You could try Power Pivot to merge and sort your various files into one
pivot table or chart.
~Susan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Jorge Marques
Sent: Thursday, March 10, 2011 5:02 AM
To: excel-macros@googlegroups.com
Subject
averages, without breaking 120/80 into two different cells.
My example file would look like this:
In column A
A1120/80
A2119/79
A3125/60
Average of A1:A2:A3 = 121/73
Thanking you much!
~Susan
with time into one formula
Hi Susan,
Its working in my comp. I am attaching the file see if it is working. I have
made the change to the cell U5.
Regards
Umesh
On Sun, Mar 20, 2011 at 6:11 PM, ashish koul wrote:
see if this helps
=LEFT(INT(U5),2)/24+RIGHT(INT(U5),2)/1440
On Sun, Ma
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
I like your website! Especially the Formula tab. J
Thanks!
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ayush Jain
Sent: Sunday, March 20, 2011 8:51 AM
To: excel-macros
Subject: $$Excel-Macros$$ discussexcel.com Launched today
Dear Excel Grou
March 20, 2011 5:41 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ combining averageif with time into one formula
see if this helps
=LEFT(INT(U5),2)/24+RIGHT(INT(U5),2)/1440
On Sun, Mar 20, 2011 at 1:07 AM, mgaler wrote:
Hi Susan,
U5:U19, Format to mil. time,
7;t post to the group.
~Susan
From: mgaler [mailto:mga...@sbcglobal.net]
Sent: Saturday, March 19, 2011 1:01 PM
To: sunni...@gmail.com
Subject: Here is a start
Take a look at the function in column U. Format column U to mil. time, the
columns holding data to numeric without decimal pl
ried
=(TIME(AVERAGEIF(($F$5:$F$17,"=1",$G$5:$G$17),(11,22,0)
That didn't work.
My formula for =AVERAGEIF($F$5:$F$17,"=1",$G$5:$G$17), works fine. That is
why I attached a copy of the file for someone to look at it and help me.
~Susan
From: excel-macr
Thank you STDEV(i)!. $B$3:B3 is what was needed to lock it. Formula works
in column C as well. Double fixed!! J
~Susan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of STDEV(i)
Sent: Friday, March 11, 2011 11:17 PM
To: excel-macros
Thanks for the reminders! J,,, I know I like it when the Subject box
includes the title of the problem/issue. Very helpful!
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ayush
Sent: Tuesday, March 01, 2011 8:49 AM
To: excel-macros@googlegroups.com
Sub
within you.
~Susan
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of anandydr
Sent: Wednesday, March 02, 2011 2:10 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Re: Excel Interview Q & A
The Favorited question happen
This is excellent idea! Thanks J
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ayush
Sent: Tuesday, March 01, 2011 8:10 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Excel Interview Q & A
Hello Members,
Since Excel skill is tested
Hi,
I’m trying to copy a list from column A2 to A30 (which was created
using Data Validation), on sheet 2 to column C2 to C30 on sheet 1.
I’ve tried everything, but error keeps coming back that I ‘can only
copy filtered data to the active sheet’.
Thanks.
Susan
ous sheet.
>
> >> Not real high tech and because the months have different #'s of days
> >> there is a little fiddling around to make it how you want it but it
> >> works pretty easily.
>
> >> I am sure there is some better way to do it, but that is the
Hi,
If you are using version 2007, you'll need to select the command button from
the active X list.
Then right click on the command button and select Properties.
Then select Backcolor from Alphabetic list and choose from the Palette.
~Susan
-Original Message-
From: excel-m
tings\All
Users\Documents\Budget\Finances\2010"
Workbooks.Open Filename:= _
"C:\Documents and Settings\All
Users\Documents\Budget\Finances\2010\Budget_Estimation_Tys.xls" _
, UpdateLinks:=0
End Sub
~Susan
--
---
Hi,
I paid for the book via Amazon.com... you could check out your local library
perhaps they have it to check out for 'free'.
Susan
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of B Sharma
Sent: Wednesday, January 05,
I use Excel 2007 Visual Basic for Applications, Step by Step. This book was
extremely helpful to me as I am a new in learning VB and wanted to write
more extensive macros.
Susan
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of B
n category
you select. The formula will then compute your "if" statement &
return the correct result.
I have tested this & it workslet me know if you have problems.
Good Luck
mdailey
On Dec 14, 1:09 pm, "Susan" wrote:
> Hi,
>
> I am doing a month to y
I'm looking for the correct replacement
of Base Scenario and replace it with the sheet number reference which
is 12:
Sheet11.Select
Range("N15") = "=SUM('Base Scenario'!AC3403:AC3409)*1000"
Have tried multiple variations. . .Many thanks for a look at it.
Pete
t will change the formula of =IF(RAW!$H$2<=BUDGET!$B$2,"Within
budget","Over budget") , to change the amounts calculated from the H2 and B2
columns?
Is there a category or drop down list formula ?
~Susan
--
--
nge("N15") = "=SUM(" & shtname & "!AC3403:AC3409)*1000"
> *
>
>
>
> On Tue, Dec 14, 2010 at 10:14 PM, Susan wrote:
> > Have a macro to refresh a formula, however, if the sheet named Base
> > Scenario gets renamed, It won't change t
Have a macro to refresh a formula, however, if the sheet named Base
Scenario gets renamed, It won't change the macro. If I replace
the"Base Scenario" reference in the macro's parenthesis with
"Sheet12", (Sheet12 is its reference before the name change) it
creates a #REF error. Any thoughts? Than
that would be great.
Thanks again!
Susan
On Oct 14, 6:05 am, Paul Schreiner wrote:
> There's a couple of things that can be done.
> But it depends on what "control" you have over the other worksheet.
>
> Can you "name" the range on the other worksheet?
&g
e wanting to calculate the average of the selected criteria,
> you could use:
>
> =ROUND(SUMIF(A2:A31,H1,B2:B31)/COUNTIF(A2:A31,H1),2)
>
> is this the kind of thing you're looking for?
>
> Or am I totally off-topic?
>
> Paul
>
> - Original Message
> >
erent category word.
the formula I have now is an AVERAGE of two cells (using the same
category word lets say Groceries), within the same sheet and I want
the formula to change when I select from the drop down selection
function from the category (LIST) cell.
thanks,
ather than the text?
Also, where in the code should this new prompt be inserted. . .should
it be the first line?
Thanks for ideas.
Susan
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks
52 matches
Mail list logo
