First Thanks very much Kantilal Sir,But I would like to which I desired
output in sheet (Yellow color) Is it possible?
On Mon, Aug 6, 2012 at 11:01 AM, Kantilal Badale
kantilal.bad...@gmail.comwrote:
Hi,
See if attached sheet is useful.
U can Change month in value field to get the desired
C the attached file. ? u r missing.
From: Kuldeep Singh naukrikuld...@gmail.com
To: excel-macros@googlegroups.com
Sent: Monday, August 6, 2012 12:44 PM
Subject: Re: $$Excel-Macros$$ Sumproduct function to get sum between two date
Dear Lakshman,
Require
Hi Lakshman G,
You're right. But Mr. Ashish says, Require output value 4625000, So I
solved query for required output.
Regards,
Kuldeep Singh
Back Office Executive (MIS)
Info Edge India Limited (naukri.com)
Phone.: +91-120-4763789, Extn.: 789
naukrikuld...@gmail.com || www.naukri.com
*Please*
ok
From: LAKSHMAN PRASAD lakshman_...@yahoo.com
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Sent: Tuesday, August 7, 2012 11:53 AM
Subject: Re: $$Excel-Macros$$ Sumproduct function to get sum between two date
C the attached file. ? u r
Dear Experts,
Good Noon.
Need help in auto filling of Colours to the shapes as well
attached excel sheet for more information.
Kindly Help advise.
Thank you.
JP.
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already
Thanks Kuldeep.
On Monday, 6 August 2012 11:13:45 UTC+5:30, Kuldeep Singh wrote:
Hi,
Please See it.
http://www.wallst-training.com/WST_Financial_Modeling_Steps.pdf
http://www.freefmt.com/
Friends,
I want to run a macro* every day in a give time(say 9.00AM)* when the work
book not open. Then open the work book and show a message if the given
conditions(say two cells have same value) fulfil. see the below written
macro for further explanation.
But the given below macro not working at
Hi Friends.
Please tell me how to create the folder by the names which I have entered
in the sheet.
For more information, please refer the attached sheet.
Please provide me solution.
--
With regards,
MaNgEsH
--
Join official facebook page of this forum @
try this macro:
Sub Make_FolderList()
Dim R, nRows, BaseFldr, fso
Set fso = CreateObject(Scripting.FileSystemObject)
BaseFldr = C:\
nRows = Application.WorksheetFunction.CountA(Range(A1:A65000))
For R = 2 To nRows
If (Not fso.folderexists(BaseFldr Cells(R, A).Value))
I would set up the macro as either a Workbook_open event or name the macro
Auto_Open.
then, create a Scheduled Task in Windows to open the workbook at 9:00am daily.
I do this with several very large macros (and have them run at 11:00pm or
4:00am
so they are complete before I come in)
and they
Hi Friends
I am struggling with one problem and need your help.
I have three columns available like:
*Column A* *Column B* *Column C* 92683 (1 18067.0 1) (8625.11)
1) Now I would like to have a formula in Column D where it will check the
destination of ( (if exist) and merge the data
THank you so much Paul.
On Tue, Aug 7, 2012 at 4:41 PM, Paul Schreiner schreiner_p...@att.netwrote:
try this macro:
Sub Make_FolderList()
Dim R, nRows, BaseFldr, fso
Set fso = CreateObject(Scripting.FileSystemObject)
BaseFldr = C:\
nRows =
Team,
I wan to maintain a log for pivot table.
example - when I click on refresh button that time old data save in log
file.
--
J.Gaurav
Call-7838594954
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for
Try This
=RIGHT(A1,LEN(A1)-FIND((,A1,2)) B1 IF(LEN(C1)FIND(),C1,1),
LEFT(C1,FIND(),C1,1)-1),)
On 7 August 2012 16:48, Shekhar Sharma shekhar1...@gmail.com wrote:
Hi Friends
I am struggling with one problem and need your help.
I have three columns available like:
*Column A*
Team,
I am using excel 2007.
I have one file .i need one icon for all excel work book where i click and
that file need to open.
--
J.Gaurav
Call-7838594954
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for
Hi Jayendra,
You Save file Save as type: - Excel 97-2003 Workwook.
Regards,
Kuldeep Singh
Phone.: +91-120-4763789, Extn.: 789
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*
On Tue, Aug 7, 2012 at 5:36 PM,
=MID(A1B1C1,SEARCH((,A1B1C1),SEARCH(),A1B1C1)-SEARCH((,A1B1C1)+1)
On 7 August 2012 21:45, RAJA SEKAR apkra...@gmail.com wrote:
Try This
=RIGHT(A1,LEN(A1)-FIND((,A1,2)) B1 IF(LEN(C1)FIND(),C1,1),
LEFT(C1,FIND(),C1,1)-1),)
On 7 August 2012 16:48, Shekhar Sharma shekhar1...@gmail.com
Another way without hyperlink using a doubleclick event in the worksheet module
Private Sub Worksheet_BeforeDoubleClick _
(ByVal Target As Range, Cancel As Boolean)
Dim ms As String
Dim mc As String
With Target
ms = Mid(.Formula, 2, InStr(.Formula, !) - 2)
mc = Mid(.Formula, InStr(.Formula, !) +
See the attached sheet
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Jayaprakash S
Sent: 07 August 2012 2:30
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Auto Filling
All Experts
Can anybody give me index sheet example where index sheet is fantastic
presentation view In spreadsheets Example like Company name, stock
price,worksheet name, Other information.
If any look that index sheet they will say O this is Fantastic Presentation
Thanks everyone
Amar
--
Right click sheet tabview codecopy/paste both of these. Now,if you have sheet
name or workbook name typed into a cell and double click that cell you will go
there. (if open it will activate, if not, it will open))
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Replace this one:
.Offset(lngCellLoop, 1).Value =
WorksheetFunction.Text(TimeSerial(Hour(.Offset(lngCellLoop, -1).Value) + (4
* objDic.Count) + 24, Minute(.Offset(lngCellLoop, -1).Value),
Second(.Offset(lngCellLoop, -1).Value)), [h]:mm:ss)
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
Also use this format
[h]:mm:ss
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: Rajan_Verma [mailto:rajanverma1...@gmail.com]
Sent: 07 August 2012 9:06
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Run-time error popup message
Replace this one:
See attached where I added defined names for sumproduct formulas
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Secret Shot
Sent: Tuesday, August 07, 2012 6:13 AM
To: excel-macros@googlegroups.com
Cc: pankaj. pandey
Subject: $$Excel-Macros$$ Excel
Hi Rajan,
Thank you for providing me the VBA code, now i got the accurate result.
Once again thanks for resolving the query. Have wonderful day ahead.
Regards
Lokesh.M
On Tue, Aug 7, 2012 at 9:05 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
*Replace this one:*
* *
*.Offset(lngCellLoop,
result on google search
http://www.youtube.com/watch?v=dBTkl1tnXao
http://www.pcreview.co.uk/forums/scrolling-marquee-t917395.html
http://officeone.mvps.org/powershow/powershow_ticker_show.html ( check
ticker)
thanks Don,
Great Help, but is there any other way to do it without Sumproduct.
Regards
Pankaj k Pandey
On Tue, Aug 7, 2012 at 9:16 PM, dguillett1 dguille...@gmail.com wrote:
See attached where I added defined names for sumproduct formulas
Don Guillett
Microsoft Excel Developer
Rajan - can you please define how shape color is changing.
Aamir Shahzad
On Tue, Aug 7, 2012 at 7:08 PM, dguillett1 dguille...@gmail.com wrote:
Option Explicit
Sub ChangeShapeColorsSAS()
Dim i As Long
Dim ms As String
On Error Resume Next
For i = 2 To 5
ActiveSheet.Shapes(i -
Hi JP
Please see the attachment.
regards
prince
On Tuesday, August 7, 2012 2:30:26 PM UTC+5:30, Jayaprakash S wrote:
Dear Experts,
Good Noon.
Need help in auto filling of Colours to the shapes as well
attached excel sheet for more information.
Kindly Help advise.
Thank you.
Hi Amar,
I think it depends on the creativity of a person you should search on
google for this.
regards
prince
On Tuesday, August 7, 2012 7:26:56 PM UTC+5:30, amar takale wrote:
All Experts
Can anybody give me index sheet example where index sheet is fantastic
presentation view In
Also this formula is giving incorrect output.. :(
On Tue, Aug 7, 2012 at 9:16 PM, dguillett1 dguille...@gmail.com wrote:
See attached where I added defined names for sumproduct formulas
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
*From:* Secret Shot
Formula was tested using the defined names I created. Perhaps you tried
somewhere where you didn’t have the defined names.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Secret Shot
Sent: Tuesday, August 07, 2012 12:57 PM
To: excel-macros@googlegroups.com
Or, if you do not know the name ON the shape and you don’t have the row in
column C
This gets the name and finds it in col c and uses the col d value in that row.
Sub fillcolorSAS()
Dim shp As Shape
Dim mn As String
Dim mr As Long
With ThisWorkbook.Worksheets(sheet1)
On Error Resume Next
For
I've just send you.
Thanks
Pawel
From: dguillett1 dguille...@gmail.com
To: excel-macros@googlegroups.com
Sent: Tuesday, August 7, 2012 7:49 PM
Subject: Re: $$Excel-Macros$$ Re: Auto Filling of Color - Need Help
Or, if you do not know the name ON the
Please visit here for more details
http://www.functionx.com/vbaccess/
On Thu, Aug 2, 2012 at 6:59 PM, wirelesscellularguy
wirelesscellular...@gmail.com wrote:
Hi All,
I am trying to relate Access data queries to excel. The excel will be
the user interface. This excel will contain the
Dear Don Prince
Thanks so much and its working perfectly !!!
Thanks to Rajan too :-)
cheers
Jp
On Tue, Aug 7, 2012 at 7:38 PM, dguillett1 dguille...@gmail.com wrote:
Option Explicit
Sub ChangeShapeColorsSAS()
Dim i As Long
Dim ms As String
On Error Resume Next
For i = 2 To 5
Hi All,
I want to Portable Excel 2007.I had already portable Excel 2007 but one
time it is delete by me.when I have XSLM file then cant open it its
formula.In my PC I used excel 2003 but when I required excel 2007 I also
open it to see file But now it is so hard to look XSLM file .So Pls Send me
Paul,
Thank for your reply. You answer is acceptable up to some extend. But I
don't wan't to open the book every day, I just want to execute the macro
only.
** **
I have a data base of Insurance expiring dates. I wan't to get a message
before the insurance expired.
See the
38 matches
Mail list logo