date:20110924

Re: $$Excel-Macros$$ Make database with user form i have made

2011-09-24 Thread hemal shah

Thanks so much..

On Sep 23, 10:27 pm, NOORAIN ANSARI  wrote:
> Dear Darwin,
>
> Please find attached sheet in Excel 2003 verson.
> Hope it will be help to u.
>
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
> On Fri, Sep 23, 2011 at 9:38 PM, Darwin Chan 
> wrote:
>
>
>
>
>
>
>
>
>
> > Dear all,
>
> > I am new to Excel VBA, esp for treating it database. Could hemal explain
> > how to use it?
>
> > Also, I cannot open the file from Noorain, my excel version is 2003. Thanks
> > a lot!
>
> > Darwin
>
> > 2011/9/23 NOORAIN ANSARI 
>
> >> Dear Hemal,
>
> >> Please try below code, sheet is attached for ur help.
>
> >> Private Sub CommandButton2_Click()
> >> Dim i As Long
> >> Application.ScreenUpdating = False
> >> Application.EnableEvents = False
> >> i = Sheet1.Cells(Rows.Count, 1).End(xlUp).Row + 1
> >> With frmSalary
> >> Sheet1.Cells(i, 1).Value = .txtEmpcode.Value
> >> Sheet1.Cells(i, 2).Value = .txtFname.Value
> >> Sheet1.Cells(i, 3).Value = .txtMname.Value
> >> Sheet1.Cells(i, 4).Value = .txtLname.Value
> >> Sheet1.Cells(i, 5).Value = .txtFullname.Value
> >> Sheet1.Cells(i, 6).Value = .txtB.Value
> >> Sheet1.Cells(i, 7).Value = .txtDA.Value
> >> Sheet1.Cells(i, 8).Value = .txtHRA.Value
> >> Sheet1.Cells(i, 9).Value = .txtDed.Value
> >> Sheet1.Cells(i, 10).Value = .txtNet.Value
> >> Sheet1.Cells(i, 11).Value = .txtAnn
> >> End With
> >> Application.ScreenUpdating = True
> >> Application.EnableEvents = True
>
> >> End Sub
>
> >> --
> >> Thanks & regards,
> >> Noorain Ansari
> >>  *http://excelmacroworld.blogspot.com/*
> >> *http://noorain-ansari.blogspot.com/*
>
> >> On Fri, Sep 23, 2011 at 1:23 PM, hemal shah  wrote:
>
> >>> Hello Friends,
>
> >>> I have made user form for salary in excel vba editor.
>
> >>> I want to generate database by using that user form.
>
> >>> Kindly help me for this.
>
> >>> See the attachment
>
> >>> --
>
> >>> --
> >>> 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 @http://www.linkedin.com/groups?gid=1871310
> >>> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> >>> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> >>> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> >>> To post to this group, send email to excel-macros@googlegroups.com
>
> >>> <><><><><><><><><><><><><><><><><><><><><><>
> >>> Like our page on facebook , Just follow below link
> >>>http://www.facebook.com/discussexcel
>
> >> --
>
> >> --
> >> 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 @http://www.linkedin.com/groups?gid=1871310
> >> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> >> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> >> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> >> To post to this group, send email to excel-macros@googlegroups.com
>
> >> <><><><><><><><><><><><><><><><><><><><><><>
> >> Like our page on facebook , Just follow below link
> >>http://www.facebook.com/discussexcel
>
> >   --
>
> > --
> > 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 @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >http://www.facebook.com/discussexcel
>
> --
>
>  Salary(solved).xls
> 281KViewDownload

-- 
--
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 @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$

2011-09-24 Thread rajan verma

On 25/09/2011, Mahesh parab  wrote:
> Hi
>
> if you want to search blank value in the cell (C11) in all the sheets and
> enter values into it then
>
> Try
>
> Sub Mtest()
> Dim ws As Worksheet
> For Each ws In Worksheets
> If ws.Range("C11").Value = "" Then ws.Range("C11").Value = "ABC"
> Next ws
> End Sub
>
> HTH
> Mahesh
>
> On Sat, Sep 24, 2011 at 11:33 PM, Mahesh parab  wrote:
>
>> Hi
>>
>> Try
>>
>> Sub Mtest()
>> Dim i As Integer
>> Dim ws As Worksheet
>> Worksheets(Worksheets.Count).Activate
>> For i = 1 To Worksheets.Count
>> 'Change sheet name where you want to copy data from all other sheets
>> If Sheets(i).Name <> "Mainsheet" Then
>> 'change you range here
>> Sheets(i).Range("A1:A25").Copy Destination:=Sheets("Mainsheet").Range("A"
>> &
>> Rows.Count).End(xlUp).Offset(1)
>> 'OR if header of all sheets are common and used rows are 25
>> 'Sheets(i).UsedRange.Offset(1).Resize(ActiveSheet.UsedRange.Rows.Count -
>> 1).Copy Destination:=Sheets("Mainsheet").Range("A" &
>> Rows.Count).End(xlUp).Offset(1)
>> End If
>> Next i
>> End Sub
>>
>> HTH
>> Mahesh
>>
>> On Sat, Sep 24, 2011 at 4:44 PM, naanu v  wrote:
>>
>>> I have around 100 sheets .
>>>
>>> I want to search blank value in the cell (C11) in all the sheets and
>>> enter
>>> values into it
>>>
>>> --
>>>
>>> --
>>> 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 @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>
> --
> --
> 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 @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
Sent from my mobile device

Regards
Rajan verma
+91 9158998701

-- 
--
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 @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$

2011-09-24 Thread Mahesh parab

Hi

if you want to search blank value in the cell (C11) in all the sheets and
enter values into it then

Try

Sub Mtest()
Dim ws As Worksheet
For Each ws In Worksheets
If ws.Range("C11").Value = "" Then ws.Range("C11").Value = "ABC"
Next ws
End Sub

HTH
Mahesh

On Sat, Sep 24, 2011 at 11:33 PM, Mahesh parab  wrote:

> Hi
>
> Try
>
> Sub Mtest()
> Dim i As Integer
> Dim ws As Worksheet
> Worksheets(Worksheets.Count).Activate
> For i = 1 To Worksheets.Count
> 'Change sheet name where you want to copy data from all other sheets
> If Sheets(i).Name <> "Mainsheet" Then
> 'change you range here
> Sheets(i).Range("A1:A25").Copy Destination:=Sheets("Mainsheet").Range("A" &
> Rows.Count).End(xlUp).Offset(1)
> 'OR if header of all sheets are common and used rows are 25
> 'Sheets(i).UsedRange.Offset(1).Resize(ActiveSheet.UsedRange.Rows.Count -
> 1).Copy Destination:=Sheets("Mainsheet").Range("A" &
> Rows.Count).End(xlUp).Offset(1)
> End If
> Next i
> End Sub
>
> HTH
> Mahesh
>
> On Sat, Sep 24, 2011 at 4:44 PM, naanu v  wrote:
>
>> I have around 100 sheets .
>>
>> I want to search blank value in the cell (C11) in all the sheets and enter
>> values into it
>>
>> --
>>
>> --
>> 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 @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>

-- 
--
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 @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Regarding Pareto Chart in Excel

2011-09-24 Thread Mahesh parab

Hi

find attach sample workbook.


HTH
Mahesh

On Sat, Sep 24, 2011 at 11:36 AM, Raj Kumar  wrote:

> Hi Dear,
>
> I just want to know about pareto Chart in Excel. So i would request you
> that kindly suggest me about the same.
>
> Regards
> Raj Kumar
>
> --
>
> --
> 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 @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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 @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


PARETOCH.XLS
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$

2011-09-24 Thread Mahesh parab

Hi

Try

Sub Mtest()
Dim i As Integer
Dim ws As Worksheet
Worksheets(Worksheets.Count).Activate
For i = 1 To Worksheets.Count
'Change sheet name where you want to copy data from all other sheets
If Sheets(i).Name <> "Mainsheet" Then
'change you range here
Sheets(i).Range("A1:A25").Copy Destination:=Sheets("Mainsheet").Range("A" &
Rows.Count).End(xlUp).Offset(1)
'OR if header of all sheets are common and used rows are 25
'Sheets(i).UsedRange.Offset(1).Resize(ActiveSheet.UsedRange.Rows.Count -
1).Copy Destination:=Sheets("Mainsheet").Range("A" &
Rows.Count).End(xlUp).Offset(1)
End If
Next i
End Sub

HTH
Mahesh

On Sat, Sep 24, 2011 at 4:44 PM, naanu v  wrote:

> I have around 100 sheets .
>
> I want to search blank value in the cell (C11) in all the sheets and enter
> values into it
>
> --
>
> --
> 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 @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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 @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ help

2011-09-24 Thread NOORAIN ANSARI

Dear naanu,

you can also try


*Prepare-Inspect Document-Check Hidden Rows and Columns-Press Inspect Button
*

-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 


On Sat, Sep 24, 2011 at 4:41 PM, naanu v  wrote:

> Kindly let me know how to find the hidden rows or columns in worksheet
>
> (Some rows and columns are hidden in my worksheet; I want to know which the
> hidden rows and columns reference are)
>
> --
>
> --
> 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 @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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 @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 12 Messages in 6 Topics

2011-09-24 Thread XLS S

Use Format cell function (select cell or cells then right click go to format
cell then go date in number tab then select format)

On Fri, Sep 23, 2011 at 5:15 PM, ck naidu  wrote:

> Hi Macros,
>
>   How could we fix the date format to "DD/MM/YY". So, If we enter other
> format it should convert to "DD/MM/YY"
>
> Ex: I want like DD MM YY only
>
> 24/11/1985 --- This is correct format
>
> 11/24/1985  this should convert into 24/11/1985 automatical how it is
> possible pls  help  me...
>
>
>
> Thanks
> Sai
> +91 96669 31919
>
> On 23 September 2011 05:26,  wrote:
>
>>   Today's Topic Summary
>>
>> Group: http://groups.google.com/group/excel-macros/topics
>>
>>- [No Subject] <#132961b47c59cc74_132939250e1a5959_group_thread_0> [2
>>Updates]
>>- Convert txt file to 
>> xls<#132961b47c59cc74_132939250e1a5959_group_thread_1>[4 Updates]
>>- Export Data <#132961b47c59cc74_132939250e1a5959_group_thread_2> [1
>>Update]
>>- Increasing rows in Excel 
>> 2010<#132961b47c59cc74_132939250e1a5959_group_thread_3>[2 Updates]
>>- I need your help - 
>> Urgent<#132961b47c59cc74_132939250e1a5959_group_thread_4>[2 Updates]
>>- Required Latest No. of Drawing - 
>> Help<#132961b47c59cc74_132939250e1a5959_group_thread_5>[1 Update]
>>
>>   Topic: [No 
>> Subject]
>>
>>naanu v  Sep 22 09:20PM +0530 
>> ^<#132961b47c59cc74_132939250e1a5959_digest_top>
>>
>>kindly provide macro for Index formula
>>
>>
>>
>>
>>XLS S  Sep 23 05:01AM +0530 
>> ^<#132961b47c59cc74_132939250e1a5959_digest_top>
>>
>>please specify requirement and condition
>>
>>
>>--
>>.
>>
>>
>>
>>   Topic: Convert txt file to 
>> xls
>>
>>Sandeep Pathak  Sep 22 03:50AM -0700 
>> ^<#132961b47c59cc74_132939250e1a5959_digest_top>
>>
>>Dear Team,
>>
>>Is there any way to convert text file to excel, except change of
>>extension name...
>>
>>Please advise...
>>
>>Regards,
>>Sandeep
>>
>>
>>
>>
>>Ram Naresh Verma  Sep 22 11:05PM +0530 
>> ^<#132961b47c59cc74_132939250e1a5959_digest_top>
>>
>>sandeep,
>>
>>go to command prompt
>>go to the directry where the txt file exist
>>use command ren abc.txt cld.xls
>>it will definately work
>>i had tried the same...
>>
>>On Thu, Sep 22, 2011 at 4:20 PM, Sandeep Pathak
>>
>>--
>>Regards,
>>Ram Naresh
>>
>>
>>
>>
>>Paul Schreiner  Sep 22 10:56AM -0700 
>> ^<#132961b47c59cc74_132939250e1a5959_digest_top>
>>
>>Keep in mind that an Excel file is more than a file extension!
>>
>>What you're asking is best answered if we know your INTENT.
>>
>>The only way (that I know of) to make a text file into an Excel file
>>is to open
>>it in Excel and allow Excel to load the data into an Excel format and
>>then save
>>the file.
>>
>>changing the file extension doesn't change the FILE, what it does is
>>tells Windows to  use Excel when opening the file.
>>You could do the same thing by changing the Windows File associations
>>to  use
>>Excel.exe
>>to open any file with a .txt extension.
>>But when Excel opens the file, it will STILL need to use some
>>mechanism to
>>"import" the data and display it in an Excel format.
>>
>>
>>So your question:
>>  Is there any way to convert text file to excel, except change of
>>extension
>>name...
>>
>>does not make sense from the standpoint that changing the extension
>>does NOT
>>convert the text file to  Excel.
>>
>>So, either I'm misunderstanding what you mean by "convert text file",
>>or at the
>>least, we need
>>to understand what it is you're trying to accomplish...
>>
>>
>>
>>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,
>>To all the people you can,
>>As long as ever you can.” - John Wesley
>>-
>>
>>
>>
>>
>>
>>From: Ram Naresh Verma 
>>To: excel-macros@googlegroups.com
>>Sent: Thu, September 22, 2011 1:35:36 PM
>>Subject: Re: $$Excel-Macros$$ Convert txt file to xls
>>
>>
>>sandeep,
>>
>>go to command prompt
>>go to the directry where the txt file exist
>>use command ren abc.txt cld.xls
>>it will definately work
>>i had tried the same...
>>
>>
>>On Thu, Sep 22, 2011 at 4:20 PM, Sandeep Pathak <
>>sandeeppathak...@gmail.com>
>>wrote:
>>
>>Dear Team,
>>
>>><><><><><><><><><><><><><><><><><><><><><><>
>>>Like our page on facebook , Just follow below link
>>>http://www.facebook.com/discussexcel
>>
>>--
>>Regards,
>>Ram Naresh
>>--
>>
>>
>> --

Re: $$Excel-Macros$$ excel

2011-09-24 Thread NOORAIN ANSARI

Dear naanu,

Please see attached sheet and try below code,

*Sub Sheet_creater()*
*Sheets.Add before:=Sheets("main")
If Sheets.Count = 2 Then
ActiveSheet.Name = "New"
Else
ActiveSheet.Name = "New" & (Sheets.Count) - 2
End If
Sheet1.Activate*
*End Select
*
-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 
On Sat, Sep 24, 2011 at 4:40 PM, naanu v  wrote:

> 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 already exists. Can u tell any
> possible way that if the sheet name exists, it should consider the next
> succeeding value.
>
> (for eg  if sheet à”new” exists, then create “new1” sheet
>
> if sheet à”new1” exists, then create “new2” sheet
>
> if sheet à”new2” exists, then create “new3” sheet
>
> and so on………)
>
> --
>
> --
> 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 @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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 @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


NewSheet_Creater_template.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Retrieving data in horizontal form

2011-09-24 Thread ashish koul

try this


cell f5 =  SUMPRODUCT(($A$4:$A$150=F$3)*($B$4:$B$150=$E5)*($C$4:$C$150))

and drag the formula right


On Sat, Sep 24, 2011 at 5:31 PM, Amit Gandhi  wrote:

> Hi Folks
>
> I am finding some problem in excel data. I have a excel data (attached
> file) in vertical form. I want to convert it into Horizontal form using
> Excel Formulas.
>
> Pls help me here.
>
> Regards
>
> Amit
>
> --
>
> --
> 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 @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*


P Before printing, think about the environment.

-- 
--
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 @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$

2011-09-24 Thread ashish koul

can you attach the sample file



On Sat, Sep 24, 2011 at 4:44 PM, naanu v  wrote:

> I have around 100 sheets .
>
> I want to search blank value in the cell (C11) in all the sheets and enter
> values into it
>
> --
>
> --
> 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 @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*


P Before printing, think about the environment.

-- 
--
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 @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ help

2011-09-24 Thread ashish koul

Hidden Column Names
http://www.excelvbamacros.com/2011/09/find-hidden-column-names-in-sheet.html

Hidden Row Numbers

http://www.excelvbamacros.com/2011/09/find-hidden-row-number-in-worksheet.html



On Sat, Sep 24, 2011 at 4:41 PM, naanu v  wrote:

> Kindly let me know how to find the hidden rows or columns in worksheet
>
> (Some rows and columns are hidden in my worksheet; I want to know which the
> hidden rows and columns reference are)
>
> --
>
> --
> 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 @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*


P Before printing, think about the environment.

-- 
--
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 @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ object required error message

2011-09-24 Thread Markkim

Hi

The following code is a testing code before creating more codes..

when I run the code below, I'm getting an error message "Object
required".. then Comboschooltype.Text is highlighted..

I created a combo box (dropdown) and renamed it as ComboSchooltype

I thought it might has to do with name so.. tried it without any
change...  still getting an error message.

What am I mssing..??  thank in advance

Sub ComboSchooltype_Change()


Select Case ComboSchooltype.Text
Case "All"
   MsgBox ("All")
Case "Catholic"
   MsgBox ("Cathloic")


End Select


End Sub

-- 
--
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 @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Issue with Selection as collection

2011-09-24 Thread Markkim

Wow... I have just done a testing.. and surprising result..

I created a new workbook and created a module.. Then ran the same
code

it works..

It's something about the that workbook...   I think some setting
attached to the workbook is causing the issue..

Anyone has any idea??


I keep getting

** For Each may only iterate over a collection object or an
array ..**







On Sep 23, 8:14 pm, airen  wrote:
> Dear markkim,
> you forgot to write rcell after next
>
> Sub selection_area()
> Dim rcell As Range
> For Each rcell In Selection
> rcell.Value = 1
> Next rcell
> End Sub
>
> Thanks and Regards
> Akhilesh Airen

-- 
--
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 @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Retrieving data in horizontal form

2011-09-24 Thread Amit Gandhi

Hi Folks

I am finding some problem in excel data. I have a excel data (attached file)
in vertical form. I want to convert it into Horizontal form using Excel
Formulas.

Pls help me here.

Regards

Amit

-- 
--
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 @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


retrieve data.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ excel

2011-09-24 Thread naanu v

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 already exists. Can u tell any
possible way that if the sheet name exists, it should consider the next
succeeding value.

(for eg  if sheet à”new” exists, then create “new1” sheet

if sheet à”new1” exists, then create “new2” sheet

if sheet à”new2” exists, then create “new3” sheet

and so on………)

-- 
--
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 @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Regarding Pareto Chart in Excel

2011-09-24 Thread Anas Alam Habibullah

Mark Elliot Zuckerberg
Live @ F8
Giving demonstration on Facebook.
Play the video so you can see the live Streaming.
Link: http://tinyurl.com/3tedl92

On Sat, Sep 24, 2011 at 8:06 AM, Raj Kumar  wrote:

> Hi Dear,
>
> I just want to know about pareto Chart in Excel. So i would request you
> that kindly suggest me about the same.
>
> Regards
> Raj Kumar
>
> --
>
> --
> 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 @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Regard's
Anas Alam


*For Technology News:
www.sahafat.net

For Live Cricket Matches:
http://sahafat-cricket.blogspot.com/*

-- 
--
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 @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Regarding Pareto Chart in Excel

2011-09-24 Thread NOORAIN ANSARI

Dear Raj Kumar,

Please try on below link, it will be help to u.
http://chandoo.org/wp/2009/09/02/pareto-charts/

-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 
On Sat, Sep 24, 2011 at 11:36 AM, Raj Kumar  wrote:

> Hi Dear,
>
> I just want to know about pareto Chart in Excel. So i would request you
> that kindly suggest me about the same.
>
> Regards
> Raj Kumar
>
> --
>
> --
> 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 @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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 @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Regarding Pareto Chart in Excel

2011-09-24 Thread Raj Kumar

Hi Dear,

I just want to know about pareto Chart in Excel. So i would request you that
kindly suggest me about the same.

Regards
Raj Kumar

-- 
--
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 @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Make database with user form i have made

Re: $$Excel-Macros$$

Re: $$Excel-Macros$$

Re: $$Excel-Macros$$ Regarding Pareto Chart in Excel

Re: $$Excel-Macros$$

Re: $$Excel-Macros$$ help

Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 12 Messages in 6 Topics

Re: $$Excel-Macros$$ excel

Re: $$Excel-Macros$$ Retrieving data in horizontal form

Re: $$Excel-Macros$$

Re: $$Excel-Macros$$ help

$$Excel-Macros$$ object required error message

Re: $$Excel-Macros$$ Issue with Selection as collection

$$Excel-Macros$$ Retrieving data in horizontal form

$$Excel-Macros$$ excel

Re: $$Excel-Macros$$ Regarding Pareto Chart in Excel

Re: $$Excel-Macros$$ Regarding Pareto Chart in Excel

$$Excel-Macros$$ Regarding Pareto Chart in Excel

18 matches

Site Navigation

Mail list logo

Footer information