Hi Group,
This might be a unique question to ask, but need to when the form is active
on my screen and i want switch between form and other excel sheet , but it
is not happening is there any possibility that when the form is opened and
can switch between the windows, usally the need of swtching
Dear Ananta,
Please find attached sheet, if it help to u..
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Fri, Sep 16, 2011 at 12:25 PM, Ananta Sapkota
try this
Sub Create_sheet_index()
Dim I As Long
' http://cloford.com/resources/colours/500col.htm FOR RGB COLOR LISTING
' create a new table of content
Sheets(1).Select
Sheets.Add
' give a name to your index sheet
ActiveSheet.Name = Index
ActiveWindow.DisplayGridlines = False
With Range(a1)
Dear Ananta,
Consider my this sheet..
On Fri, Sep 16, 2011 at 12:25 PM, Ananta Sapkota
sapkota.ana...@gmail.comwrote:
Hi Friends
I have more than 100 worksheets in workbook. I used to open these
worksheets by using input box. But there is problems to remember many
worksheets.
I am exporting a file from online which automatically includes dates.
This interferes with my Pivot tables. How do I convert an entire
column of dates with the time to dates without the time.
--
--
Some important
Hi,
Just try it..
=SUMPRODUCT(--($A$1:A10=A1)--($A$1:A10=A2)*(B1:B10=B1))
On Thu, Sep 15, 2011 at 9:09 AM, ArtySin kenstrain...@gmail.com wrote:
Hi
I have two columns as below using Excel 2000 (unfortunately, corporate
no spend policy): These columns have been exported from a database and
*Try
Ctrl + PageDown
or
Ctrl + PageUp
*
On Fri, Sep 16, 2011 at 9:28 AM, Mr Excellent suryaprasad...@gmail.comwrote:
Hi Group,
This might be a unique question to ask, but need to when the form is active
on my screen and i want switch between form and other excel sheet , but it
is not
THANK YOU SO MUCH SAM.
On Fri, Sep 16, 2011 at 6:50 AM, Sam Mathai Chacko samde...@gmail.comwrote:
Not sure if you can. But you can use this
Private Sub ComboBox9_Change()
Dim dtmStart As Date
Dim dtmEnd As Date
If Day(CDate(TextBox1.Text)) 12 Then
dtmStart =
Dear Experts,
I am facing a problem when using sumifs formula, not getting desired result.
Plase help me to rectify the problem or better solution.
Thanks in advance
--
*Kalyan Chattopadhyay*
*Executive Sales Coordinator*
*R. S. H. Pvt. Ltd.*
--
I have a workbook with more than 300 sheets and 1 main sheet. I had tried to
create a macro considering the objective to add a new worksheet before the
main sheet.
And my macro is below:
‘Sheets(main).Select
‘ Worksheets.Add
‘ ActiveSheet.Name = new
I m facing a problem when the “new “sheet
I have formatted a column in a spreadsheet as Text. With VBA i am
writing a string variable into a cell of that column. The string
variable happens to contain a number and i get the green triangle in
the particular cell indicating that i am writing a number as text.
However, it is formatted as a
Dear Naanu,
Please use below code instead of your red Color code.
**
*Sheets.Add after:=Sheets(Sheets.Count)
Sheets(Sheets.Count).Name = main
*
On Fri, Sep 16, 2011 at 4:48 PM, naanu v naanu2...@gmail.com wrote:
I have a workbook with more than 300 sheets and 1 main sheet. I had tried
to
Dear naanu,
Please try...
Excel Option-Prepare-Inspect Document-Click on Hidden Rows and
Column-Press Inspect Button
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/*
Dear Naanu,
I think, you can group all sheets, then you update in Single sheet all sheet
will be updated...
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/*
Hello James,
I think for using any forms/running any quires, the access has to be
opened.
Also I think Connection method only used to share the data from the
table/queries.
Try the following code.
Sub MyOpenDb()
Dim appAccess As Object
Set appAccess = CreateObject(Access.Application)
Dear Kalyan
why don't you use
*
=SUMPRODUCT(($A$2:$A$37=F11)*($B$2:$B$37=$G$7)*(--SUBSTITUTE(C2:C37,MOC,)=--SUBSTITUTE(G8,MOC,))*(--SUBSTITUTE(C2:C37,MOC,)=--SUBSTITUTE(G9,MOC,))*$D$2:$D$37)
*
pfa
--
*Great day,*
*viper
*
On Fri, Sep 16, 2011 at 4:11 PM, Kal xcel kalx...@gmail.com wrote:
Dear Kalyan,
Please see attached sheet..
=SUMIFS($E$2:$E$37,$A$2:$A$37,G11,$B$2:$B$37,H7,$C$2:$C$37,=INT(RIGHT(H8,LEN(H8)-FIND(
,H8,1))),$C$2:$C$37,=INT(RIGHT(H9,LEN(H9)-FIND( ,H9,1
--
Thanks regards,
Noorain Ansari
’makes a list, in column 1 of all sheetsnames the rangesets up data validation
option explicit
Sub makesheetlistSAS()
Dim i As Long
For i = 1 To Sheets.Count
Cells(i, 1) = Sheets(i).Name
Next i
Cells(1).Resize(Cells(Rows.Count, 1).End(xlUp).Row) _
.Name = SheetList
Range(b1).Validation.Add
Guys,
Thanks to all for your help. Problem now solved and working a
treat. :-)
ArtySin
On Sep 15, 5:09 pm, ArtySin kenstrain...@gmail.com wrote:
Hi
I have two columns as below using Excel 2000 (unfortunately, corporate
no spend policy): These columns have been exported from a database and
Dear Group,
I have written a poem on MS Excel, Please read Injoy..
कौन कहता है यारों Excel एक समस्या है.
मेरा मानना है की, Excel एक तपस्या है.
भूल जाओगे स्वाद, दोस्त तुम रसगुल्लों का.
लत अगर लग जाए, Excel के फर्मुल्लों का.
उतने ही पावोगे हीरे, जितने घुसोगे अंदर.
थकने नहीं
Both are working perfectly.
Thank u Viper
Thanks a lot Noorain
On Fri, Sep 16, 2011 at 5:48 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Kalyan,
Please see attached sheet..
=SUMIFS($E$2:$E$37,$A$2:$A$37,G11,$B$2:$B$37,H7,$C$2:$C$37,=INT(RIGHT(H8,LEN(H8)-FIND(
Try this function :
date(year(yourdate),month(yourdate),day(yourdate))
text(yourdate,dd/mm/yy)
you can go for custom date format in format cell option
another way to do this ,insert a column after date column and use
text to column put a space character in delimite
On 16/09/2011, Shaik
*Experience:* 2 - 6 Years
*Location:* Hyderabad / Secunderabad
*Compensation:* Rupees 3,00,000 - 6,00,000
Open
*Education:* UG - Any Graduate - Any Specialization,Graduation Not Required PG
- Any PG Course - Any Specialization,Post Graduation Not Required
*Industry Type:* Banking/Financial
Mr Excellent,
In the properties of the user form, you will have to change the showmodal
property to False
Regards,
Sam Mathai Chacko (GL)
On Fri, Sep 16, 2011 at 2:57 PM, Mr Excellent suryaprasad...@gmail.comwrote:
*DID YOU GET MY QUESTION AS THE ANSWER IS NOT RELEVANT*
On Fri, Sep 16,
Hi use this when showing your user form :
userform1.show 0
user form will show modelless andit allow user to interect with worksheet
regards
rajan
On 17/09/2011, Sam Mathai Chacko samde...@gmail.com wrote:
Mr Excellent,
In the properties of the user form, you will have to change the
*Experience:* 4 - 8 Years
*Location:* Mumbai
*Compensation:* Rupees 4,00,000 - 5,50,000
*Education:* UG - Any Graduate - Any Specialization,Graduation Not Required PG
- Any PG Course - Any Specialization,Post Graduation Not Required
*Industry Type:* BPO/ITES
*Role:* HR Exec.
*Functional Area:* HR
Hi Kalyan,
Try the below formula.
=SUMPRODUCT((TRIM(A2:A37)=TRIM(F11))*(TRIM(B2:B37)=TRIM(G7))*(LEFT(TRIM(C2:C37),3)=LEFT(TRIM(G8),3))*(--MID(TRIM(C2:C37),FIND(
,TRIM(C2:C37))+1,255)=--MID(TRIM(G8),FIND(
,TRIM(G8))+1,255))*(--MID(TRIM(C2:C37),FIND(
,TRIM(C2:C37))+1,255)=--MID(TRIM(G9),FIND(
Good afternoon,
I have 20,000 workbooks that are going to be returned to me shortly
and i need a template from which i can open the workbooks
(individually) and have a marco to perform three necessary functions
on all of these workbooks (each workbook will have a unique name). My
objective is to:
Good afternoon,
I have 20,000 workbooks that are going to be returned to me shortly
and i need a template from which i can open the workbooks
(individually) and have a marco to perform three necessary functions
on all of these workbooks (each workbook will have a unique name). My
objective is to:
After digging around a bit, I found the following code that seems to
work fine for getting the file list from a particular directory. I
just need to figure out how to pull the data from the comment line in
the file. any suggestions?
Thanks
John
On Sep 15, 2:48 pm, johnofeasttex
I searched around and found some code that allows me to create a list
of the files in a given directory. I just need to figure out how to
pull the comment data from the file.. any suggestions? What I have
so far looks like this:
Option Explicit
Sub GetFileList()
Dim strFolder As String
Dim
31 matches
Mail list logo