thank you so much ravinder.
it's working absolutely fine.
On Thu, Aug 1, 2013 at 11:15 AM, ravinder negi ravi_colw...@yahoo.comwrote:
you can use
=SUM(INDIRECT(CELL(address,INDIRECT(r7cMATCH(B2,F6:M6,0)+5,FALSE)):CELL(address,INDIRECT(rMATCH(B3,E7:E10,0)+6cMATCH(B2,F6:M6,0)+5,FALSE
You can also use this
=SUM(OFFSET(E6,1,MATCH(B2,F6:M6,0),MATCH(B3,E7:E10,0)))
Pada 01/08/2013 13:00, Waseem Saifi menulis:
thank you so much ravinder.
it's working absolutely fine.
On Thu, Aug 1, 2013 at 11:15 AM, ravinder negi ravi_colw...@yahoo.com
mailto:ravi_colw...@yahoo.com wrote:
de premor, it's too easy !
thank you so much
On Thu, Aug 1, 2013 at 11:33 AM, De Premor d...@premor.net wrote:
You can also use this
=SUM(OFFSET(E6,1,MATCH(B2,F6:M6,0),MATCH(B3,E7:E10,0)))
Pada 01/08/2013 13:00, Waseem Saifi menulis:
thank you so much ravinder.
it's working
Hi guys,
I have developed a macro to open files and copy data from 1 workbook to
another, this is a report, but now I need to send this to everyone in my
department, the path i use for opening the file is
Workbooks.Open
Filename:=C:\Users\marquesj\Desktop\data_source\week_to_date-export.xls
how
Thanks Lalit. Can you point me to any resource I can use to understand this?
Regards,
Aashish
On Thu, Aug 1, 2013 at 10:16 AM, Lalit Mohan Pandey
mohan.pande...@gmail.com wrote:
I am not sure about this becuse Microsoft excel vba doesn't work in
Openoffice and if you really want to prevent
I have 3 sheets in my excel book.
First sheet is Menu sheet.
I want that, Menu sheet is to be open every time when I open excel file.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
Hi Hemlal,
You can use below code:
Private Sub Workbook_Open()
Application.Sheets(sheet1).Select
End Sub
*Suman Kumar*
On Thu, Aug 1, 2013 at 2:53 PM, hemal shah hemali...@gmail.com wrote:
I have 3 sheets in my excel book.
First sheet is Menu sheet.
I want that, Menu sheet is
Hi Priti,
it is not working
On Thu, Aug 1, 2013 at 3:05 PM, priti verma pritiverma1...@gmail.comwrote:
you can use workbook open event to active worksheet
Private Sub Workbook_Open()
Worksheets(Menu).Activate
End Sub
On Thu, Aug 1, 2013 at 2:23 AM, hemal shah hemali...@gmail.com
Hi Hemal, in your first email you said:
*I want that, Menu sheet is to be open every time when I open excel file.*
Thaat why Priti give a code like this !
Worksheets(Menu).Activate
But in your real workbook, you dont have a sheet named *Menu*m but you
have sheet named *INDEX*
Try to change
Thanks.
On Thursday, 1 August 2013 16:04:01 UTC+5:30, suman kumar wrote:
Hi
You should use below code in ThisWorkbook in OPEN event. Please find the
attached file now its working as well.
*Suman Kumar*
On Thu, Aug 1, 2013 at 3:53 PM, hemal shah
Sorry ignore my last email, i just opening the macros code in your
workbook, and find that you have do it right, but in wrong place
Try to place that code in ThisWorkbook not in Sheet1
Pada 01/08/2013 17:34, De Premor menulis:
Hi Hemal, in your first email you said:
*I want that, Menu sheet
Try this
Sub tes()
Dim oWSHShell As Object, OpenFile As String
Set oWSHShell = CreateObject(WScript.Shell)
OpenFile = oWSHShell.SpecialFolders(Desktop)
\data_source\week_to_date-export.xls
Set oWSHShell = Nothing
Workbooks.Open Filename:=SaveDest
End Sub
Pada
Just trying to imagine with your problem since there is no file attached
to explore the other scene.
PFA my first approach, is that close with your ?
Pada 01/08/2013 8:54, RJQMAN menulis:
I have a complex program I wrote in Excel 2003 about six years ago,
and I am working to update it. In
Dear Masters,
I am about put below article in one of the news letter being published in our
organization. Could you please validate if they are true?
What are some interesting facts about Microsoft excel?
1. You can undo the last 100 actions
2. Each worksheet holds 1,048,576 rows
3. Each
visit this link for more intersting facts
http://office.microsoft.com/en-in/excel-help/excel-specifications-and-limits-HP010073849.aspx
On Thu, Aug 1, 2013 at 6:46 PM, Amit Desai (MERU)
amit.de...@merucabs.comwrote:
Dear Masters,
** **
I am about put below article in one of the news
Dear Experts,
My project in last stage, just your little co-operation I will complete my
project.
please give me positive response, awaiting...
Regards
Sajid Memon
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
try this add this in thisworkbook module
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Sheet1.Activate
ThisWorkbook.Save
End Sub
Private Sub Workbook_Open()
Sheet1.Activate
End Sub
On Thu, Aug 1, 2013 at 4:40 PM, अनिल नारायण गवली gawlianil8...@gmail.comwrote:
Dear All,
Pls see the
If i am correct
Please find below formula
=VLOOKUP(C8,$I$7:$J$9,2,0)*(1+$G$3%)
.
Enjoy
Team XLS
On Thu, Aug 1, 2013 at 7:51 PM, SAJID MEMON sajidwi...@hotmail.com wrote:
Dear Experts,
My project in last stage, just your little co-operation I will complete my
try this
Public Const oldnm As String = f1
Public Const newnm As String = test_f1
Sub renam_folders()
Dim fldpath As String
Dim fso As Object, folder1 As Object
fldpath = C:\Users\admin\Desktop\sample ' choose folder
Set fso = CreateObject(Scripting.FileSystemObject)
Set folder1 =
Great! Excellent!
Perfect work!
Thanks again Deepak,
you are a genius.
Regards
Vijay Yadav
On Friday, 26 July 2013 14:17:30 UTC+5:30, vijay yadav wrote:
Dear Excel experts,
I have to sort data in two columns ,first column contains name and second
column contains salary.
The new
I am not sure if this is the proper way to reply, so forgive me if I am not
doing this correctly. I thought I posted the code but perhaps I did not do
it correctly.
My cell formula was simple in column C - I just use Isnumber to check and
make sure that there was a number in both column A and
Thanks a lot dear for your kind co-operation, Now i am complete my project with
your help.thanks againRegardsSajid memon
Date: Thu, 1 Aug 2013 20:19:34 +0530
Subject: Re: $$Excel-Macros$$ Auto Rate taking- !!! HELP PLZ !!!
From: xlst...@gmail.com
To: excel-macros@googlegroups.com
If i am
You can change your code line where there is copy criteria as given below
Make sure to change sheet and range references accordingly
Sheet2.Range(C24).Copy
Sheet2.Range(C25).PasteSpecial xlPasteValues, xlPasteSpecialOperationNone
On Fri, Aug 2, 2013 at 6:01 AM, Steve Weaver
Respected Hemal,
Create a custom List and sort moths according to that custom list.
Regards,
Vijaykumar
On Fri, Aug 2, 2013 at 10:33 AM, hemal shah hemali...@gmail.com wrote:
in this file, there is sheet named Sale Summary.
In the column labels, I have put Year and below that i put month.
how to create custom list
On Friday, 2 August 2013 11:03:32 UTC+5:30, vijay wrote:
Respected Hemal,
Create a custom List and sort moths according to that custom list.
Regards,
Vijaykumar
On Fri, Aug 2, 2013 at 10:33 AM, hemal shah hema...@gmail.comjavascript:
wrote:
in this file,
25 matches
Mail list logo