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 noorain.ans...@gmail.comwrote:
Dear Susan,
Please try it and see attached sheet
)
ActiveSheet.Name = _
Format(DateSerial(Year(Date), 1, i), mmm dd)
Next i
End Sub
‘=
Don Guillett
SalesAid Software
dguille...@gmail.com
*From:* Susan 1 sunni...@gmail.com
*Sent:* Tuesday, December 06, 2011 6:25 PM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros
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 below in a blank spreadsheet and when I
year and adding a
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, December 07, 2011 6:14 PM
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, 2011 at 5:18 AM, Susan 1 sunni...@gmail.com
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
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.
data=import External Data = select datasource=select the appropriate
option=ok
On Tue, Jul 12, 2011 at 8:22 AM, Susan 1 sunni...@gmail.com 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 appropriate
see if it helps
On Tue, Jul 12, 2011 at 6:33 PM, Susan sunni...@gmail.com 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
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:
...@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
.
Thanks,
DILIPandey
On 7/1/11, Susan 1 sunni...@gmail.com wrote:
Hi,
I cannot figure out Excel won't let me select different ranges from multiple
worksheets with same criteria ??
=SUMIF(D2:D6,C Wagner,E2:E6)
This is what I'd like it to do:
=SUMIF(Sheet1!D2:D6,Sheet3!D11:D18
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
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.
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:
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
:=xlToLeft
End Sub
On Thu, May 19, 2011 at 8:59 PM, Susan 1 sunni...@gmail.com wrote:
Hi Jsin -
I've attached an example of the formatted spreadsheet and the raw data txt
file, the macro or VB I need would automatically format the txt file into
the spreadsheet style.
Thanks for you help
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
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
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
~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.com
Subject: Re: $$Excel-Macros$$ Need to count blank cells with CountIF formula
see the forumula
:$E$34,15,$G$5:$G$34,=09:00:00,$G$5:$G$34,=19:00:00)
I tried this but it results with #NAME?,
=COUNTBLANK(IFS($E$5:$E$17,17,$G$5:$G$17,=09:00:00,$G$5:$G$17,=19:00:00
))
Thanks!
~Susan
--
--
Some important links
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 koul.ash...@gmail.com wrote:
see if this helps
=LEFT(INT(U5),2)/24+RIGHT(INT(U5),2)/1440
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
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
that will allow averaging of total amount of blood
pressure numbers
see if it helps
On Sun, Mar 27, 2011 at 10:58 PM, Susan sunni...@gmail.com 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
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 susan.ander...@vmmc.orgwrote:
Hi ,
Can you help me with the formula below? See
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 mga...@sbcglobal.net wrote:
Hi Susan,
U5:U19, Format to mil. time, then paste
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
(($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-macros@googlegroups.com [mailto:excel-macros
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 places
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
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 happens
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
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
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
sure there is some better way to do it, but that is the thing
about excel, the more I learn, the more I realize how little I know.
On Jan 12, 12:20 am, Susan susan.m.ander...@comcast.net wrote:
Hi,
I'm looking for a formula that will add all dates of the month. It will
auto-populate
\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
--
--
Some
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-macros
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, 2011 3:30
this it workslet me know if you have problems.
Good Luck
mdailey
On Dec 14, 1:09 pm, Susan susan.m.ander...@comcast.net wrote:
Hi,
I am doing a month to year, home budget spreadsheet and on tab name RAW
column F1, I have a drop down list that contains about 12 subjects , such
as groceries, home
at 10:14 PM, Susan cow...@aol.com wrote:
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
theBase Scenario reference in the macro's parenthesis with
Sheet12, (Sheet12 is its reference before the name change
calculated from the H2 and B2
columns?
Is there a category or drop down list formula ?
~Susan
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http
wrote:
Hi Susan,
Not sure if this is the problem, but I thought I'd mention it;
When using a sheet name, the syntax is:
Worksheets(Base Scenario) or just Sheets(Base Scenario)
But when using the sheet number, neither quotes, nor the word 'Sheet' are not
used inside the brackets.
So it just
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
theBase Scenario reference in the macro's parenthesis with
Sheet12, (Sheet12 is its reference before the name change) it
creates a #REF error. Any thoughts? Thanks
be great.
Thanks again!
Susan
On Oct 14, 6:05 am, Paul Schreiner schreiner_p...@att.net 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?
For example
From: Susan susan.m.ander...@comcast.net
To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com
Sent: Tue, October 12, 2010 3:36:04 PM
Subject: $$Excel-Macros$$ Incorporating a List into a formula - Excel 2007
Hi,
wondering if someone can help. I'll try to be as specific as I can.
I
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,
Susan
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 and links
51 matches
Mail list logo