Dear Ashish,
I have copied it but when i am running the code it showing error msg pls
help.
On 3 November 2011 10:53, ashish koul koul.ash...@gmail.com wrote:
Sub copy_first_sheet_from_different_workbooks_to_single()
Application.DisplayAlerts = False
Application.ScreenUpdating = False
Dim
Hi Expert,
Plz give me any formula for diff in string
example-
If cell A1 contain Ashish B1 contain Ashish
we want to diff in A1 B1 then how we can formulate it
Thanks Regards,
Ankit
--
FORUM RULES (925+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor
in which format ur files are saved .xls or xlsx
On Thu, Nov 3, 2011 at 11:56 AM, sandeep chhajer
chhajersand...@gmail.comwrote:
Dear Ashish,
I have copied it but when i am running the code it showing error msg pls
help.
On 3 November 2011 10:53, ashish koul koul.ash...@gmail.com wrote:
My files are saved in .xls format. But I am working in .xlxs.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: ashish koul koul.ash...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 3 Nov 2011 13:04:02
To: excel-macros@googlegroups.com
Sub copy_first_sheet_from_different_workbooks_to_single()
Application.DisplayAlerts = False
Application.ScreenUpdating = False
Dim fld As Object, fil As Object
Dim ask As Workbook, ask2 As Workbook
With Application.FileDialog(msoFileDialogFolderPicker)
.Title = Choose the folder
.InitialFileName =
Haseeb,
Is it possible to apply when I have records of two or more than two
column?
Thanks
Akhilesh
--
FORUM RULES (925+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and
Haseeb,
Thank you for that. That solved an unrelated issue and was very helpful,
thank you.
John
On Wed, Nov 2, 2011 at 8:22 PM, Haseeb Avarakkan haseeb.avarak...@gmail.com
wrote:
Hello John,
If the Arrival Date Time is 09/08/2011 2310 Length is 343 (Row 3
data) Finish date time is
THANKS A LOT
On Thu, Nov 3, 2011 at 3:56 PM, ashish koul koul.ash...@gmail.com wrote:
check the attachment
On Thu, Nov 3, 2011 at 3:50 PM, Jai jaihumtu...@gmail.com wrote:
HOW CAN INSERT THE PLEASE GIVE THE VBA CODE OR FORMULA
--
FORUM RULES (925+ members already BANNED for violation)
Sam,
Thank you for that, it saves a column.
John
On Wed, Nov 2, 2011 at 9:25 PM, Sam Mathai Chacko samde...@gmail.comwrote:
If you only want the finish time without splitting it in to Date and Time,
you could also use
=LEFT(TRIM(A23),10)+TEXT(RIGHT(TRIM(A23),4),00\:00)+(B23/(60*24)) in
If?? I understand your question then
=if(a1b1,”diff”,””)
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Ankit Agrawal
Sent: Thursday, November 03, 2011 1:45 AM
To: excel-macros
Subject: $$Excel-Macros$$ formula for diff. in string
Hi Expert,
Plz give me any formula for diff in
HI,
If both string are same then 1 or anything else like true otherwise false o
anything else/
Regards,
Ankit
On Thu, Nov 3, 2011 at 5:56 PM, dguillett1 dguille...@gmail.com wrote:
If?? I understand your question then
=if(a1b1,”diff”,””)
Don Guillett
SalesAid Software
Save your file as .xls or .xlsM and run this
Sub inserttworows()
For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -1
Rows(i).Resize(2).Insert
'MsgBox i
Next i
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Jai
Sent: Thursday, November 03, 2011 5:20 AM
To:
Hi Expert,
I Need the formula here to calculate from 1st of Nov to current day on
daily basis automatically. attached file your reference.
--
*Regards*
**Sunil B.N
***9035858585
--
FORUM RULES (925+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread
Please read the rules at the bottom about subject lines and “nee ur help:
This formula will do it
=SUM(B2:OFFSET(A2,MATCH(TODAY(),A:A)-2,1,1))
Don Guillett
SalesAid Software
dguille...@gmail.com
From: sunil bn
Sent: Thursday, November 03, 2011 8:13 AM
To: excel-macros@googlegroups.com
Subject:
check the attachment
On Thu, Nov 3, 2011 at 6:12 PM, Ankit Agrawal ankit.agrawal...@gmail.comwrote:
HI,
If both string are same then 1 or anything else like true otherwise false
o anything else/
Regards,
Ankit
On Thu, Nov 3, 2011 at 5:56 PM, dguillett1 dguille...@gmail.com wrote:
Thanks sir.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: ashish koul koul.ash...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 3 Nov 2011 13:16:56
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re:
i have a excel sheet in which real time stock quotes gets updated
automatically every second.
I would like to highlight the value as red if the new stock quote is
greater than the previous one.
And highlight the quote as blue if the new stock quote is lesser than
the previous one.
thanks.
--
For that you'll have to first tell how your sheet gets refreshed? Is it
linked to a web query? Normally, you'd want to save the existing values in
a second sheet, and make the conditional comparison based on the current
value.
Regards,
Sam
On Thu, Nov 3, 2011 at 8:20 PM, ajjw123
2011/11/3 ashish koul koul.ash...@gmail.com
check the attachment
On Thu, Nov 3, 2011 at 6:12 PM, Ankit Agrawal
ankit.agrawal...@gmail.comwrote:
HI,
If both string are same then 1 or anything else like true otherwise false
o anything else/
Regards,
Ankit
On Thu, Nov 3, 2011 at
Dear Ankit,
For exact match you can use
=EXACT(A1,B1)
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Thu, Nov 3, 2011 at 12:15
Here's a simulated refresh to give you the idea of how it can be done. Now,
my trigger is the click of a button. But in your case, it could be the
query refresh.
Regards
Sam
On Thu, Nov 3, 2011 at 8:23 PM, Sam Mathai Chacko samde...@gmail.comwrote:
For that you'll have to first tell how your
Dear Jai,
Please use below code as per your requirement.
*Sub InsertSpecificRows()
Dim InsQuan As Integer
On Error Resume Next
InsQuan = InputBox(Enter number of rows to insert, Your Call)
If InsQuan = 0 Then
MsgBox Invalid number entered, vbCritical, Stop!
Exit Sub
End If
To make it more simple try A1=B1
Sent on my BlackBerryŽ from Vodafone
-Original Message-
From: NOORAIN ANSARI noorain.ans...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 3 Nov 2011 20:50:01
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject:
I ve to add points scored in each table. When the points are NA, total is
not possible. Plz see attached file.
Mahreen
On Thu, Nov 3, 2011 at 4:49 AM, Haseeb Avarakkan haseeb.avarak...@gmail.com
wrote:
Mahreen,
If you have multiple ratio values define a name for them each, like
Table1,
Sub PasteStat()
Sheets(start).Select
Range(h6:l6).Select
Selection.Copy
Sheets(Sheet1).Select
Range(f Selection.Row).Select
ActiveSheet.Paste
End Sub
Hi,
How do I edit the above so that the selected sheet (in this case
Sheet1) is the active sheet. I.e. if i was
replace sheet1 with ur Sheet30 in the ur code like
Sheets(Sheet30).Select
On Thu, Nov 3, 2011 at 9:25 PM, Eddie eddiejame...@googlemail.com wrote:
Sub PasteStat()
Sheets(start).Select
Range(h6:l6).Select
Selection.Copy
Sheets(Sheet1).Select
Range(f
Sub PasteStat()
Sheets(start).Range(h6:l6).Copy Sheets(Sheet1).Range(f
Selection.Row)
End Sub
Regards,
Sam Mathai Chacko
On Thu, Nov 3, 2011 at 9:25 PM, Eddie eddiejame...@googlemail.com wrote:
Sub PasteStat()
Sheets(start).Select
Range(h6:l6).Select
Selection.Copy
Selections could be removed.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: NOORAIN ANSARI
Sent: Thursday, November 03, 2011 10:49 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ INSERT THE ROW
Dear Jai,
Please use below code as per your requirement.
Sub
What do you want when one or the other is NA and how is the cell populated with
NA
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Mahreen Ellahi
Sent: Thursday, November 03, 2011 10:33 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help
I ve to add points
Sub cc()
Sheets(start).Range(h6:l6).Copy cells(activecell.row,”f”)
end sub
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Sam Mathai Chacko
Sent: Thursday, November 03, 2011 11:18 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Copy and Paste Macro (into
=N(E8)+N(K8)
Score=IF(ISNUMBER(Sheet1!$E$2),(IF(Sheet1!$E$2=2,3,IF(Sheet1!$E$2=3,1,IF(Sheet1!$E$2=4,0,IF(Sheet1!$E$24,-3,0),0)
Score1=IF(ISNUMBER(Sheet1!$J$2),(IF(Sheet1!$J$2=0.5,-2,IF(Sheet1!$J$2=0.75,0,IF(Sheet1!$J$2=1,1,IF(Sheet1!$J$21,2,0),0)
Regards,
Sam Mathai Chacko
On Thu, Nov
Thanks,
However, can you automate this so I dont have to edit the sheet number
everytime i use a differnt sheet?
On Nov 3, 4:17 pm, ashish koul koul.ash...@gmail.com wrote:
replace sheet1 with ur Sheet30 in the ur code like
Sheets(Sheet30).Select
On Thu, Nov 3, 2011 at 9:25 PM, Eddie
I want the user either to have score or NA. When all boxes are marked by NA
or score, all scores should be added for final score.
On Thu, Nov 3, 2011 at 9:30 PM, dguillett1 dguille...@gmail.com wrote:
What do you want when one or the other is NA and how is the cell
populated with NA
Don
This looks good but gettin a run time error 1004!
On Nov 3, 4:36 pm, dguillett1 dguille...@gmail.com wrote:
Sub cc()
Sheets(start).Range(h6:l6).Copy cells(activecell.row,”f”)
end sub
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Sam Mathai Chacko
Sent: Thursday, November
Did you try this?
Sub PasteStat()
Sheets(start).Range(h6:l6).Copy Sheets(Sheet1).Range(f
Selection.Row)
End Sub
Sam
On Thu, Nov 3, 2011 at 10:16 PM, Eddie eddiejame...@googlemail.com wrote:
This looks good but gettin a run time error 1004!
On Nov 3, 4:36 pm, dguillett1
So did you check my post?
Sam
On Thu, Nov 3, 2011 at 10:03 PM, Mahreen Ellahi mahreen.acc...@gmail.comwrote:
I want the user either to have score or NA. When all boxes are marked by
NA or score, all scores should be added for final score.
On Thu, Nov 3, 2011 at 9:30 PM, dguillett1
Yes, works great on sheet1 but doesnt work on others...
On Nov 3, 5:21 pm, Sam Mathai Chacko samde...@gmail.com wrote:
Did you try this?
Sub PasteStat()
Sheets(start).Range(h6:l6).Copy Sheets(Sheet1).Range(f
Selection.Row)
End Sub
Sam
On Thu, Nov 3, 2011 at 10:16 PM, Eddie
So what exactly are you trying to do? Want to copy from start to any of the
active sheets?
Sub PasteStat()
Sheets(start).Range(h6:l6).Copy Activesheet.Range(f
Selection.Row)
End Sub
Sam
On Thu, Nov 3, 2011 at 10:54 PM, Eddie eddiejame...@googlemail.com wrote:
Yes, works great on sheet1
Hi Friends,
i need to find out scope of the name range i.e. if the defined name is has a
scope of worksheet or workbook.
below is my code
sub test
dim namerange as name
for each nameange in thisworkbook.names
a = namerange.name
'here i want to find out th scope of the name range.
lets say
That's what I get for NOT testing
Sheets(start).Range(h6:i6).Copy Range(f ActiveCell.Row)
Sheets(start).Range(h6:l6).Copy cells(activecell.row,”f”)
end sub
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Eddie
Sent: Thursday, November 03, 2011 11:46
Hello Sunil;
Also, you can use SUMIF,
=SUMIF(A2:A11,=TODAY(),B2:B11)
_
HTH
Haseeb
--
FORUM RULES (925+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need
Akhilesh,
Please attach a dummy sheet with your desired result. So the members can
look on it.
__
Haseeb
--
FORUM RULES (925+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code
try
=4+(DAY(B$1+34)WEEKDAY(B$1-6))
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: DaveO
Sent: Thursday, November 03, 2011 12:58 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Formula to count Fridays in a month mis-reports
February
I've
Just a small modification to your original formula
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(DATE(YEAR(A1),MONTH(A1),1):DATE(YEAR(A1),MONTH(A1)+1,0=6))
Regards
Sam Mathai Chacko
On Thu, Nov 3, 2011 at 11:43 PM, dguillett1 dguille...@gmail.com wrote:
try
=4+(DAY(B$1+34)WEEKDAY(B$1-6)**)
Since 2/30/2012 is not a valid date,
it evaluates the DATE(2012,2,30)
as 3/1/2012 instead of 2/30/2012
It would have similar issues with each month with 30 days
(April, June, September, November)
if the first day of the following month were to fall on the day being tallied
(For instance, the
Sub NameInMe()
Dim nm As Name
For Each nm In ThisWorkbook.Names
If nm.Parent.Name = ThisWorkbook.Name Then
MsgBox nm.Name is workbook level
Else
MsgBox nm.Name is sheet level
End If
Next
End Sub
Regards,
Sam Mathai Chacko
On
Thanks, Don and Sam- I appreciate your responses and I'll study them
to understand them fully.
--
FORUM RULES (925+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need
Your original post said that you would use the FIRST DAY of each month.
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: DaveO
Sent: Thursday, November 03, 2011 1:53 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Formula to count Fridays
I thought the same thing. If anything, I figured it would pass an #INVALID
value
to Sumproduct.
But I tested it..
I suspect what's happening is that it normally takes a date and converts it
to
an integer.
then does the calculation.
I think what it's actually doing here is converting the
So to ensure only the correct number of days are added, use
=SUMPRODUCT(--(WEEKDAY(DATE(YEAR(B1),MONTH(B1),ROW(INDIRECT(1:DAY(DATE(YEAR(B1),MONTH(B1)+1,0))=6))
Regards,
Sam Mathai Chacko
On Fri, Nov 4, 2011 at 12:48 AM, Paul Schreiner schreiner_p...@att.netwrote:
He's using the first day
Or, another one;
=INT((WEEKDAY(B1-DAY(B1)+1-6)+EOMONTH(B1,0)-(B1-DAY(B1)+1))/7)
Even if B1 is not the first day of the month, it will work. If you are
using XL2003 or prior versions, EOMONTH function require Analysis ToolPak
Addins to be installed activated.
__
HTH
Haseeb
--
FORUM
For a text comparison along the lines of a Diff utility, that highlights
cell character differences in color, see the highlightDifferences() UDF by
Mike Rickson at http://www.mrexcel.com/forum/showthread.php?t=390953
Read all the comments to see how it works, and use the version from the last
Thnq very much
On Thu, Nov 3, 2011 at 11:23 PM, Haseeb Avarakkan
haseeb.avarak...@gmail.com wrote:
Hello Sunil;
Also, you can use SUMIF,
=SUMIF(A2:A11,=TODAY(),B2:B11)
_
HTH
Haseeb
--
FORUM RULES (925+ members already BANNED for violation)
1) Use concise, accurate thread
53 matches
Mail list logo