Hello Sreejith,
As Seema said, not sure about how do you want to compare due to duplicate
trade ID's. If you are looking to total the headings based on TradeID's use
SUMIF.
In C11, then copy down. Assume Trade Id always be in column A in detailed
sheet
*
: Domain Admin [mailto:domainqu...@gmail.com]
Sent: Monday, March 19, 2012 6:13 PM
To: Asa Rossoff
Subject: Re: $$Excel-Macros$$ Need help with VBAfor Excel naming and using
column names for looping
And I forgot one question (not sure how to get all this back to the
forum but will try to stay
...@gmail.com]
Sent: Monday, March 19, 2012 6:08 PM
To: Asa Rossoff
Subject: Re: $$Excel-Macros$$ Need help with VBAfor Excel naming and using
column names for looping
I can see my C programming background (yes I am old) is not a big help
here. I need some object oriented experience to get
...@gmail.com]
Sent: Monday, March 19, 2012 11:58 AM
To: Asa Rossoff
Subject: Re: $$Excel-Macros$$ Need help with VBAfor Excel naming and using
column names for looping
thanks, sure wish there was a way to have it be position relative so
could insert new columns without affecting the name
Rossoff
Subject: Re: $$Excel-Macros$$ Need help with VBAfor Excel naming and using
column names for looping
thanks, sure wish there was a way to have it be position relative so
could insert new columns without affecting the name on column C but
does not appear
the simplest is
sub nameit
cells(7,4).name=whateveryouwanttonameit
end sub
=whaeveryounamedit
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: tangledweb
Sent: Sunday, March 18, 2012 5:22 AM
To: MS EXCEL AND VBA MACROS
Subject:
Asa
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of dguillett1
Sent: Sunday, March 18, 2012 1:26 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need help with VBAfor Excel naming and using
column names
Aamir,
Thx for both gr8 people. ( Norain / Aamir )
Rgds,
Iqbal Shaikh
On 17 March 2012 10:10, Aamir Shahzad aamirshahza...@gmail.com wrote:
Another soluction
Aamir Shahzad
On Fri, Mar 16, 2012 at 11:44 PM, NOORAIN ANSARI noorain.ans...@gmail.com
wrote:
On Fri, Mar 16, 2012 at
On Fri, Mar 16, 2012 at 3:32 PM, Shaikh Iqbal iqbal.hp...@gmail.com wrote:
Hi, Friends
Go through attachment, need your help for formula.
Thx Rgds,
Iqbal Shaikh
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles,
Another soluction
Aamir Shahzad
On Fri, Mar 16, 2012 at 11:44 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
On Fri, Mar 16, 2012 at 3:32 PM, Shaikh Iqbal iqbal.hp...@gmail.comwrote:
Hi, Friends
Go through attachment, need your help for formula.
Thx Rgds,
Iqbal Shaikh
--
HI ranjan,
go to tools in vb editor.. in reference select microsoft outlook
options... run the program it works fine
Thanks...
On Thu, Mar 15, 2012 at 4:54 PM, Deba Ranjan drdeva...@gmail.com wrote:
*
*
Dear Expert,
Please help to create a programing such that the attached file
FYI.
Regards
karthik.N
On Wed, Mar 7, 2012 at 1:05 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Kartik,
Can you share sample workbook.
On Tue, Mar 6, 2012 at 6:35 PM, karthik N n.karthi...@gmail.com wrote:
Kindly help me
To allocate the data in macro branch wise and every
Dear Kartik please use below codeand Change red color path
Sub Sheet_Creater_Deptwise()
Dim rng As Range
Dim rng1 As Range
Set rng = Sheet1.Range(G1:G Sheet1.Range(G65536).End(xlUp).Row)
rng.Copy Sheet1.Range(H1)
Set rng1 = Sheet1.Range(H1:H Sheet1.Range(H65536).End(xlUp).Row)
rng1.Select
see attached sheet..
On Wed, Mar 7, 2012 at 3:12 PM, karthik N n.karthi...@gmail.com wrote:
Kindly help me
To allocate the data in macro branch wise and every branch shouid be
save in new book ,
Regards,
karthik.N
--
FORUM RULES (986+ members already BANNED for violation)
1)
please send the sheet with example
On Tue, Mar 6, 2012 at 6:14 AM, sherif azat sherifazat...@hotmail.comwrote:
what i want in the sheet
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need
Thank You
Regards
karthik.N
On Thu, Mar 8, 2012 at 9:56 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
see attached sheet..
On Wed, Mar 7, 2012 at 3:12 PM, karthik N n.karthi...@gmail.com wrote:
Kindly help me
To allocate the data in macro branch wise and every branch shouid be
Dear Kartik,
Can you share sample workbook.
On Tue, Mar 6, 2012 at 6:35 PM, karthik N n.karthi...@gmail.com wrote:
Kindly help me
To allocate the data in macro branch wise and every branch shouid be
save in new book ,
Regards
Karthik
--
FORUM RULES (986+ members already BANNED
Hi
Don Guillett
is there any way to keep subject line also while opening that link
thanks for every one
On Feb 14, 8:44 pm, dguillett1 dguille...@gmail.com wrote:
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Renukachari Kasee
Sent: Tuesday, February 14, 2012 6:21 AM
To:
Glad to hep
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: renuka chari
Sent: Wednesday, February 15, 2012 12:27 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ need help for hyperlink execution without
using mouse PFA
Hi
dguillett1
Its
You have to be a little more clear. 'Average columns values using
remaining column values' doesn't ring a bell.
Maybe post an expected output to make your requirement clear.
Sam
On Wed, Feb 15, 2012 at 1:40 AM, KAMASANI RAJESH BABU
kamasaniraj...@gmail.com wrote:
Hi Team,
Need help on
http://www.meadinkent.co.uk/xlwtdavg.htm
On Wed, Feb 15, 2012 at 9:04 PM, Sam Mathai Chacko samde...@gmail.comwrote:
You have to be a little more clear. 'Average columns values using
remaining column values' doesn't ring a bell.
Maybe post an expected output to make your requirement clear.
Right click sheet tabview code insert this. Now when you select col G (no need
for col H)
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
On Error GoTo nomo
If Target.Column = 7 And Target Then
ActiveWorkbook.FollowHyperlink Address:= _
mailto:; Target ?bcc=$J$1, Target ),
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Renukachari Kasee
Sent: Tuesday, February 14, 2012 6:21 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ need help for hyperlink execution without using mouse
PFA
Hi
All experts
good evening
here one sheet is having
Hi
Do you want to send bulk emails to respective person from that worksheet ?
HTH
Mahesh
On Tue, Feb 14, 2012 at 9:14 PM, dguillett1 dguille...@gmail.com wrote:
Don Guillett
SalesAid Software
dguille...@gmail.com
*From:* Renukachari Kasee jva.ch...@gmail.com
*Sent:* Tuesday, February
ya, sending on daily basis
On Feb 14, 12:25 pm, Mahesh parab mahes...@gmail.com wrote:
Hi
Do you want to send bulk emails to respective person from that worksheet ?
HTH
Mahesh
On Tue, Feb 14, 2012 at 9:14 PM, dguillett1 dguille...@gmail.com wrote:
Don Guillett
SalesAid Software
Hi
dguillett1
Its working Good Thank you so much
On Feb 14, 10:44 am, dguillett1 dguille...@gmail.com wrote:
Right click sheet tabview code insert this. Now when you select col G (no
need for col H)
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
On Error GoTo nomo
If
thanks maries And All
On Feb 14, 2:02 pm, Maries talk2mar...@gmail.com wrote:
Hi,
Find the attached file.
Regards,
MARIES.
On Tue, Feb 14, 2012 at 9:25 PM, Mahesh parab mahes...@gmail.com wrote:
Hi
Do you want to send bulk emails to respective person from that worksheet ?
Dear Renuka
kindly check the below link , it might be helpful to u
http://www.rondebruin.nl/mail/folder2/mail5.htm
On Wed, Feb 15, 2012 at 11:55 AM, renuka chari jva.ch...@gmail.com wrote:
ya, sending on daily basis
On Feb 14, 12:25 pm, Mahesh parab mahes...@gmail.com wrote:
Hi
Do
Dear Sriram,
Look attached...as required...
On Thu, Feb 2, 2012 at 6:38 PM, sriram ji sriramg...@gmail.com wrote:
Dear Excel Guru,
Kindly provide the solution for the attached file.
Thanks Regards,
Sriram G
Chennai
--
FORUM RULES (986+ members already BANNED for violation)
1)
go through the attachment
On Thu, Feb 2, 2012 at 9:25 PM, sriram ji sriramg...@gmail.com wrote:
Dear Excel Guru,
Kindly provide the solution for the attached file.
Thanks Regards,
Sriram G
Chennai
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise,
Dear Sriram
Kindly find the attached file
On Thu, Feb 2, 2012 at 9:25 PM, sriram ji sriramg...@gmail.com wrote:
Dear Excel Guru,
Kindly provide the solution for the attached file.
Thanks Regards,
Sriram G
Chennai
--
FORUM RULES (986+ members already BANNED for violation)
1) Use
This looks like classroom “homework” which you need to do yourself.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: vvkgupta tycoon
Sent: Wednesday, February 01, 2012 5:23 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ need help in the following excel
Its not a class room home work, using these functions I need to do my
professional tasks.
-Thanks,
Gupta.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem,
You can use this for text also
Sub isExist()
On Error Resume Next
If WorksheetFunction.Match(Range(rngValues).Text,
Worksheets(Sheet2).Range(d4:d10), 0) Then
If Err.Number = 1004 Then
Err.Clear
On Error GoTo 0: On Error GoTo -1
MsgBox Values not found
try
Option Explicit
Sub Look2()
Dim mf As Range
Set mf = Sheet2.Columns(D).Find(What:=Range(b4), _
LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows, _
searchDirection:=xlNext, SearchFormat:=False)
If Not mf Is Nothing Then MsgBox mf.Row
End Sub
Don Guillett
SalesAid Software
fyi
regards
jitendra singh
9015340017
On Fri, Jan 20, 2012 at 12:57 PM, PrIyAnKa p.dhamsa...@gmail.com wrote:
Dear Sunita
Kindly give one example of what u want in your sheet as to study the data
and analyse the same and preparing format as per your requirement takes a
lot time
So kindly
Dear Sunita
Kindly find the attached file
Hope this is as per your req
2012/1/20 सुनिता पौडेल tosune...@gmail.com
Dear Priyanka,
Thank you for the interest shown. Please find attached the example of what
I required.
On Fri, Jan 20, 2012 at 1:12 PM, PrIyAnKa p.dhamsa...@gmail.com
Thank you very much for the prompt action. It works as per my requirement.
Have a wonderful day!
On Fri, Jan 20, 2012 at 2:56 PM, PrIyAnKa p.dhamsa...@gmail.com wrote:
Dear Sunita
Kindly find the attached file
Hope this is as per your req
2012/1/20 सुनिता पौडेल tosune...@gmail.com
Try this one:
Sub isExist()
On Error Resume Next
If WorksheetFunction.Match(Range(rngValues).Value, Range(List), 0)
Then
If Err.Number = 1004 Then
Err.clear
On error goto 0:on Error Goto -1
MsgBox Values not found
Else
MsgBox Range(rngValues).Value
End
Dear Sunita
Kindly give one example of what u want in your sheet as to study the data
and analyse the same and preparing format as per your requirement takes a
lot time
So kindly provide one output example in output format
2012/1/20 सुनिता पौडेल tosune...@gmail.com
Dear all,
Can you please
Dear Priyanka,
Thank you for the interest shown. Please find attached the example of what
I required.
On Fri, Jan 20, 2012 at 1:12 PM, PrIyAnKa p.dhamsa...@gmail.com wrote:
Dear Sunita
Kindly give one example of what u want in your sheet as to study the data
and analyse the same and
Hi Rekha
Try :
Sub Mtest()
On Error Resume Next
'delete existing pivot sheet
Application.DisplayAlerts = False
Sheets(Pivot West).Delete
Application.DisplayAlerts = True
Sheets(West).Select
ActiveSheet.UsedRange.Select
'Count the column
colcount = Selection.Columns.Count
'Add Dynamic Name Range
Dear Ashish,
Please try below code...
Function check_value(rng As Range) As String
Dim cell, rng1 As Range
Set rng1 = Sheet2.Range(D4:D10)
For Each cell In rng1
If cell.Value = rng.Value Then
MsgBox Bill is made of this Chassis, vbInformation
End If
Exit Function
Next cell
End Function
see
Dear Ashish,
Excel 2007 File Type Extension
- xlsx - Excel http://en.wikipedia.org/wiki/Microsoft_Excel 2007 XML
Workbook
- xlsm - Excel 2007 XML Macro-Enabled Workbook
- xltx - Excel 2007 XML Template
- xltm - Excel 2007 XML Macro-Enabled Template
- xlsb - Excel 2007 binary
Dear Ashish,
Please ignore previous mail..use it
Function check_value(rng As Range) As String
Dim cell, rng1 As Range
Set rng1 = Sheet2.Range(D4:D10)
For Each cell In rng1
If cell.Value = rng.Value Then
MsgBox Bill is made of this Chassis, vbInformation
Exit Function
End If
Next cell
End
December 2011 11:03
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Need help
** **
it is resulting wrong result please help
for example i gave word abc it should come 123
but it is coming like this
333435
** **
On Tue, Dec 27, 2011 at 11:00 AM, Maries
Rossoff
Sent: Monday, December 26, 2011 7:08 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Need help
Hi Rekha,
Here's one method. It will return 1-26 for A-Z, whether upper or lower
case. If any other character, it will give an error:
=FIND(UPPER(A1
Sent: Tuesday, 27 December 2011 8:37 AM
Subject: RE: $$Excel-Macros$$ Need help
Hi Rekha,
Here's one method. It will return 1-26 for A-Z, whether upper or lower case.
If any other character, it will give an error:
=FIND(UPPER(A1),ABCDEFGHIJKLMNOPQRSTUVWXYZ)
Here's another method
-Macros$$ Need help
Hi Rekha,
Here's one method. It will return 1-26 for A-Z, whether upper or lower
case. If any other character, it will give an error:
=FIND(UPPER(A1),ABCDEFGHIJKLMNOPQRSTUVWXYZ)
Here's another method, it will return a number for any character. If the
charcater is A-Z
but what about for this
acb =132
Regards
LAKSHMAN
*From:* Asa Rossoff a...@lovetour.info
*To:* excel-macros@googlegroups.com
*Sent:* Tuesday, 27 December 2011 8:37 AM
*Subject:* RE: $$Excel-Macros$$ Need help
Hi Rekha,
Here's one method. It will return 1-26 for A-Z, whether upper
2011 8:37 AM
*Subject:* RE: $$Excel-Macros$$ Need help
Hi Rekha,
Here's one method. It will return 1-26 for A-Z, whether upper or lower
case. If any other character, it will give an error:
=FIND(UPPER(A1),ABCDEFGHIJKLMNOPQRSTUVWXYZ)
Here's another method, it will return a number for any
Function
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of rekha siri
Sent: 27 December 2011 11:03
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need help
it is resulting wrong result please help
for example i gave word abc it should
Assumes xl2010. =WORKDAY.INTL(B6,A6,6,D1:D2) d1etc for holidays
WORKDAY.INTL function
Show AllHide AllReturns the serial number of the date before or after a
specified number of workdays with custom weekend parameters. Weekend parameters
indicate which and how many days are weekend days.
Guys, Cant figure out what these files do. Please explain with
example, how exactly do you use these two excel files.
Regards,
Rohan.
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help,
*From:* B.N.Chethan Kumar chetankumar1...@gmail.com
*Sent:* Tuesday, November 29, 2011 5:03 PM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Need Help
Hi,
Thanks these help.
But need some additional input. these work only PST or OST file...can u
help with any
Hi,
Thanks these help.
But need some additional input. these work only PST or OST file...can u
help with any file pattern..like .DOC, XLS,.XL.PPT ,etc
Regards
Chethan Kumar BN
On Wed, Nov 30, 2011 at 4:16 AM, dguillett1 dguille...@gmail.com wrote:
Here is a file that should help
Don
: B.N.Chethan Kumar
Sent: Tuesday, November 29, 2011 5:03 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need Help
Hi,
Thanks these help.
But need some additional input. these work only PST or OST file...can u help
with any file pattern..like .DOC, XLS,.XL.PPT ,etc
Thank you!
On Tue, Nov 22, 2011 at 10:30 AM, Jedi Spencee jedi.spen...@gmail.comwrote:
Hello- I am trying to write a formula that would return the COUNT and
SUM, with 3 criteria elements.
IF(AND(data!F:F = A),and(data!B:B, = 04 - Closed Won), and(data!
D:D, = Oct-11),count, 0)
Can this
Hi,
If you are using Excel 2007 or 2010, then you can use the SUMIFS or
COUNTIFS to achieve the same.
Cheers
Andy
On Tue, Nov 22, 2011 at 11:00 PM, Jedi Spencee jedi.spen...@gmail.comwrote:
Hello- I am trying to write a formula that would return the COUNT and
SUM, with 3 criteria elements.
You can also try...
=SUMPRODUCT((data!F:F = A)*(data!B:B=04 - Closed
Won)*(data!D:D=Oct-11)*(data!K:K=0))
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On
If you are using Excel 2007+, use COUNTIFS for count and SUMIFS for sum.
If using an older Excel, use SUMPRODUCT for either.
IF(AND(data!F:F = A),and(data!B:B, = 04 - Closed Won), and(data!
D:D, = Oct-11),count, 0)
=COUNTIFS(data!F:F,A,data!B:B,04 - Closed Won,data!D:D,DATE(2011,10,1))
I think
-Original Message-
From: Asa Rossoff [mailto:a...@lovetour.info]
Sent: Tuesday, November 22, 2011 7:38 PM
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ Need Help with IF(AND formula
If you are using Excel 2007+, use COUNTIFS for count and SUMIFS for sum.
If using an older Excel
Hello kavita,
I don't have Outlook 2010 installed, but I checked the Outlook 2010 object
reference on MSDN @ and noticed MAPIFOLDER isn't listed at all.
At
http://msdn.microsoft.com/en-us/library/microsoft.office.interop.outlook.map
ifolder.aspx it is specified as deprecated, and to use
Object Library, for the 2010 version?
** **
Aas
** **
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI
*Sent:* Tuesday, November 15, 2011 5:15 AM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros
-Macros$$ Need help on Access VBA automating outlook
Hi Kavita,
See attachement.
On Tue, Nov 15, 2011 at 11:46 AM, kavita ahuja kavitaahuja2...@gmail.com
wrote:
Hi Group members,
I have one access tool which is automating outlook. Earlier it was working
fine on all the systems in our
hi kavita,
you should add outlook reference in your excel workbook, which contains
this code
open visual basic editor (press Alt+f11)
go on tool menu
click on reference... option
Microsoft Outlook 12.0 object library
Divaker
9582060233
On Tue, Nov 15, 2011 at 11:46 AM, kavita ahuja
Use this code in Sheet1 VBA code module
Private Sub CommandButton1_Click()
ActiveSheet.Range(B4:B32).EntireRow.Hidden = Not
ActiveSheet.Range(B4:B32).EntireRow.Hidden
End Sub
Private Sub CommandButton2_Click()
ActiveSheet.Range(B35:B50).EntireRow.Hidden = Not
Hey Thanks Sam It's working..
*
*
*Regards,*
*Jocky*
On Mon, Nov 14, 2011 at 8:30 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Use this code in Sheet1 VBA code module
Private Sub CommandButton1_Click()
ActiveSheet.Range(B4:B32).EntireRow.Hidden = Not
Hi Sean
you can use it will all xls or all xlsx
On Fri, Oct 21, 2011 at 9:20 AM, Sean flanagan.se...@gmail.com wrote:
Hi sir, and thank you for your assistance.
I like your macro very much. Sadly, it does not bring joy. However,
it has helped me to discover that the problem is not with
May be best to post your code and even your file.
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Sean
Sent: Thursday, October 20, 2011 3:38 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Need help resolving runtime errors and crashes (or
Although vastly off topic, Excel 2010 is Excel 14. MS skipped one number 13,
probably because of all the beliefs associated with that number :D
Regards,
Sam Mathai Chacko (GL)
On Fri, Oct 21, 2011 at 6:26 PM, dguillett1 dguille...@gmail.com wrote:
May be best to post your code and even your
hi Sean
try this macro. select the folder which is having all the excel files.
On Fri, Oct 21, 2011 at 2:08 AM, Sean flanagan.se...@gmail.com wrote:
Hi and thanks for your interest in my post.
I'm using in MSExcel 2007 and using code I've found in various forums
and published by MVPs, to
As a follow-up, running the macro against files which have been
converted (using OpenOfficeCalc) to .xls files produces a spreadsheet
that is very useful, proving that my difficulty is not in the macro.
And oh, how I wish I could use it against all the .xlsx files!
Warm regards,
-Sean-
On Oct
are you wanting all sub-folders within the folder?
or do you want to progress down through all the nested sub-folders?
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
-
From: Rajasekhar Praharaju rajasekhar.prahar...@gmail.com
To: excel-macros@googlegroups.com
Sent: Fri, October 14, 2011 11:18:13 AM
Subject: Re: $$Excel-Macros$$ Need help
Hi Paul,
Thanks for your quick reply, Only the first sub folder names and their
respective sizes.
Thanks,
Raj
On Fri
:18:13 AM
*Subject:* Re: $$Excel-Macros$$ Need help
Hi Paul,
Thanks for your quick reply, Only the first sub folder names and their
respective sizes.
Thanks,
Raj
On Fri, Oct 14, 2011 at 8:45 PM, Paul Schreiner schreiner_p...@att.netwrote:
are you wanting all sub-folders within
Subject: Re: $$Excel-Macros$$ Need help
hi Paul,
i am getting bug here,
ub List_Folder_Size()
Dim fso, fldr, sfldr, FolderName
Dim Sht, R
FolderName = D:\C-backup
Sht = FolderList
Set fso = CreateObject(Scripting.FileSystemObject)
Sheets(Sht).Range(A2:Z65000
:* Rajasekhar Praharaju rajasekhar.prahar...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Fri, October 14, 2011 11:31:34 AM
*Subject:* Re: $$Excel-Macros$$ Need help
hi Paul,
i am getting bug here,
ub List_Folder_Size()
Dim fso, fldr, sfldr, FolderName
Dim Sht, R
See if it helps :
https://sheet.zoho.com/excelviewer
On Tue, Oct 4, 2011 at 9:33 AM, syed aliya raza hashim
hashim...@gmail.comwrote:
Can excel file such as reports be access from web or can be acccess as web
pages suppose we have 10 sheets but from some url we want to see the reports
--
Not clear as to what you want. Pls provide sample sheet and urls and what you
need.
From: syed aliya raza hashim
Sent: Monday, October 03, 2011 11:03 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need Help
Can excel file such as reports be access from web or can be acccess as
It looks like you are forecasting daily ship $ correctly. Is the
problem in summing up the total for the month or in showing cumulative
totals in your month-to-date (column L)? If the latter is the case,
you can simply use an if function to grab from column M when column
E has a null value.
Try
=FORECAST(O8,$E$6:E7,$O$6:O7) in M8 and drag down
HTH,
Sam Mathai Chacko (GL)
On Sun, Sep 25, 2011 at 11:12 PM, Steve Weaver steveweave...@comcast.netwrote:
Each day I update the attached spreadsheet with with our previous days
shipments. I would like to use the daily ship data to
Thank you Sam for your suggestion but I still can't get the formula to
work. In case it makes a difference, I'm using Excel 2002 with SP3
installed.
What am I missing?
Steve
On 9/25/2011 2:48 PM, Sam Mathai Chacko wrote:
Try
=FORECAST(O8,$E$6:E7,$O$6:O7) in M8 and drag down
HTH,
Sam
Simply deleting the un-needed rows and columns reduced the file by one half.
Combining like sheets with an extra column and using autofilter would help. Etc.
From: syed aliya raza hashim
Sent: Sunday, September 25, 2011 1:32 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need
Thanks noorain, It solved my prb...
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @
Hi Haseeb,
Thanks for you help on this query but recently I noticed onething, this
formula works when we have to match strings from left. In this case it works
fine. But when I have the below scenario, it doesnt work properly.
For example, in source sheet I have Analex Corporation and in
You've created the userform,
but it looks like you don't have ANY of the code behind it.
I thought your question was how to ensure that each trip is entered
sequentially,
now I am not so sure.
Are you familiar with VBA?
Are you wanting specific assistance? or are you looking for some one to
*Dear friend,
=VLOOKUP(*A1*,Sheet1!A:A,1,0)
please help me after vlookup*,a1*
Thanks with
Mothilal
*
On Tue, Jul 12, 2011 at 7:31 PM, Anish Shrivastava anish@gmail.comwrote:
Thanks Ankur, Rajan, Haseeb and Ashish for helping me.. :)
On Tue, Jul 12, 2011 at 5:37 PM,
You could use a combination of Haseeb's formula and this array formula
=INDEX(Sheet1!$A:$A,MIN(IFERROR(MATCH(RIGHT(A2,ABS(LEN(A2)+1-ROW(INDEX($A:$A,1):INDEX($A:$A,LEN(A2)*,Sheet1!$A:$A,0),)))
The trick would be to identify *when* you would use either...
Sam Mathai Chacko (GL)
On Wed, Sep
try this
select any rep name in col a and run the macro
Sub filter()
Application.ScreenUpdating = False
If ActiveCell.Column = 1 Then
Z = Sheets(Input Data).Range(a1).End(xlDown).Row
On Error Resume Next
Sheets(Input Data).AutoFilterMode = False
Sheets(Input Data).Range($A$1:$I Z).AutoFilter
Did you get what I sent?
From: Steve Weaver
Sent: Saturday, September 10, 2011 1:56 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need help with advance filter
Thank you very much Ashish!!!
How would you modify the code below to place the appropriate data from
Thank you dguillett!!
I'm not real sure how this works or what to do with it. Could you please
explain to me each step in baby talk ?
Thank you!
Steve
On 9/10/2011 10:31 AM, dguillett1 wrote:
From what I can see, it
Your Worksheet Doesnt have any Code to Calculate on Click.
On Sun, Aug 28, 2011 at 12:20 PM, jocky Beta jocky6...@gmail.com wrote:
Hi Team,
I had create Compound Calculator in Excel VB sheet , i had already set
the Formula in VB but when i Click on the Calculate Button it shows error,
Hi,
Can you create same for me?
The Formula is given below.
*FORMULA - A = P* (1 + r/12)12
*P* is the principal (the initial amount you borrow or deposit) - *TextBox1*
*r* is the annual rate of interest (percentage) - *TextBox2*
*n* is the number of years the amount is deposited or
Hey Jocky,
please find the attachment.
On Sun, Aug 28, 2011 at 7:08 PM, jocky Beta jocky6...@gmail.com wrote:
Hi,
Can you create same for me?
The Formula is given below.
*FORMULA - A = P* (1 + r/12)12
*P* is the principal (the initial amount you borrow or
add this macro to each box
Sub test()
Application.DisplayAlerts = False
Application.ScreenUpdating = False
' method 1 in this u have to change the shape names as per the sheet names
'For i = 2 To Sheets.Count
'Sheets(i).Visible = True
'If Sheets(i).Name Application.Caller Then
'
Aug 2011 11:35:59
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need help in maro
add this macro to each box
Sub test()
Application.DisplayAlerts = False
Application.ScreenUpdating = False
' method 1 in this u have to change the shape
Hi Prasad,
Ashish's Code working fine..See the attached Sheet.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Suryaprasad
Sent: Tuesday, August 23, 2011 10:56 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need help in maro
Hi All,
Hi Erick,
Please see attached sheet...
--
Thanks regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Fri, Aug 12, 2011 at 12:34 AM, Erick C boricua2...@gmail.com wrote:
Hi everybody -
I am hoping someone can help me out. I
Hi Erick,
Look attached..see if helps...
*Best Regards,*
*Venkat *
*Chennai*
*
*
On Fri, Aug 12, 2011 at 12:34 AM, Erick C boricua2...@gmail.com wrote:
Hi everybody -
I am hoping someone can help me out. I have a spreadsheet that I am
currently making a macro in VBA. I would like to
401 - 500 of 656 matches
Mail list logo
