PFA
Is this what you are looking for. If not send an example file.
Regards
Deepak
On Thu, Aug 1, 2013 at 10:26 PM, RJQMAN wrote:
> 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 corre
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
> > wrote:
>
>> in this file, there is sheet
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 wrote:
> in this file, there is sheet named "Sale Summary".
>
> In the column labels, I have put Year and below that i put month.
> but the mont
Pl put it in cell E8 and drag below
=IFERROR(VLOOKUP(C8,$I$7:$J$12,2,0)*($G$3%),"")
Regards
Pravin Gunjal.
-- Forwarded message --
From: xlstime
Date: Thu, Aug 1, 2013 at 8:19 PM
Subject: Re: $$Excel-Macros$$ Auto Rate taking- !!! HELP PLZ !!!
To: excel-macros@googlegroups.c
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 wrote:
>
>
> I u
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 corr
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 Co
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 c
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 fol
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 wrote:
> Dear Experts,
>
> My project in last stage, just your little co-operation I will complete my
> project.
> please give
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, अनिल नारायण गवली wrote:
> Dear All,
>
> Pls see the attached sheet.
>
>
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
=TIME(2
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)
wrote:
> Dear Masters,
>
> ** **
>
> I am about put below article in one of the news letter being publis
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 workshee
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 the
Ups Sorry, my fault, i haven't change a variable to fit yours
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
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 01/
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 is
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, he
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 chan
Hi Priti,
it is not working
On Thu, Aug 1, 2013 at 3:05 PM, priti verma wrote:
> 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 wrote:
>
>>
>> I have 3 sheets in my e
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 wrote:
>
> 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
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 wrote:
>
> I have 3 sheets in my excel book.
>
> First sheet is Menu sheet.
>
> I want that, Menu sheet is to be open ev
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 @
https://www.fac
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 preve
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"
ho
de premor, it's too easy !
thank you so much
On Thu, Aug 1, 2013 at 11:33 AM, De Premor 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 absolutely fi
27 matches
Mail list logo
