Re: $$Excel-Macros$$ How to remove Save As opiton from excel.

[Vasant]

Hi

Pls find the code.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
If SaveAsUI Then
Cancel = True
End If
End Sub


This will work only if the workbook has been saved once.



On Fri, Jul 22, 2011 at 12:07 AM, Anshul  wrote:

> Please let me know how i can remove save as option from excel file...I have
> restrict persons not to save as anexcel file.
>
> --
>
> --
> 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

Vasant

skype Id: vasantjob
http://facebook.com/vasantjob

-- 
--
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$$ Macro needed for ms access database

[§»VIPER«§]

Hi



1. I have created a database with some custom menus. In that I am having a
menu called "Manage" and I require a code which should hide the particular
menu for particular users.

2. I have created a form for startup and I don’t want allow the users to
close the form using the Cnrl+W. It should be always open till the database
is open.  I have removed the form control property close box from the form
but the users are still able to close the form using Cntrl+W button.



Can anyone give me the solution?

-- 
*Great day,*
*viper
*

-- 
--
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$$ Unlocking locked sheets/workbooks or VBA projects!!!

[crazybond]

Experts,

In order to unlock locked sheets/workbooks or VBA project, which program or
codes would you suggest.


Regards

-- 
--
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$$ How to remove Save As opiton from excel.

[Anshul]

Please let me know how i can remove save as option from excel file...I have 
restrict persons not to save as anexcel file.

-- 
--
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$$ Re: VBA - Remove duplicate and get sums

[NOORAIN ANSARI]

Dear Raghvendra,

Please try below code and see attached sheet


Sub advancefilter_sumif()
Dim i, j As Long
Dim abc, cba As Range
Application.ScreenUpdating = False
Sheet1.Range("A1:A" & Sheet1.Range("A1").End(xlDown).Row).Copy
Sheet1.Range("D1").Select
ActiveSheet.Paste
Sheet1.Range("E1").Value = "Amount"
Sheet1.Range("D1:D" & Sheet1.Range("A1").End(xlDown).Row).RemoveDuplicates
1, xlNo
j = Application.WorksheetFunction.CountA(Sheet1.Range("D:D"))
Set abc = Sheet1.Range("A1:A" & Sheet1.Range("A1").End(xlDown).Row)
Set cba = Sheet1.Range("B1:B" & Sheet1.Range("B1").End(xlDown).Row)
For i = 2 To j
Sheet1.Range("E" & i).Value = Application.WorksheetFunction.SumIf(abc,
Sheet1.Range("D" & i).Value, cba)
Next
Application.ScreenUpdating = True
end sub
-- 
Thanks & regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/* 
On Fri, Jul 22, 2011 at 12:24 AM, GoldenLance  wrote:

> A Pivot Table is used precisely for such computations. As a thumb
> rule, use Excel functions and tools where Excel can handle it
> efficiently. Use VBA only if Excel cannot give desired output on its
> own
>
> On Jul 21, 10:19 pm, Raghavendra  wrote:
> > Hi,
> >
> > Can anyone let me know VBA code for the below?
> >
> > Input Data
> >
> > Names   Amount
> > A   100
> > B   200
> > C   100
> > B   100
> > A   100
> > D   150
> >
> > Out put data should be
> >
> > Names   Amount
> > A   200
> > B   300
> > C   100
> > D   150
> >
> > Regards,
> > Raghavendra
>
> --
>
> --
> 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


advance Filter + Sumif_Example.xlsm
Description: Binary data

Re: $$Excel-Macros$$ Call Center Dashboards

[NOORAIN ANSARI]

Dear Raghunandan,

Please use below link for Call center Dashboard

http://www.klipfolio.com/products/call-center-dashboard
http://www.inovasolutions.com/call-center-reporting/products/call-center-dashboard.html

On Thu, Jul 21, 2011 at 10:10 PM, Raghunandan wrote:

> Hi Guys,
>
> Can any1 help me out by sending Call center KPI dashboards or any link
> where in I can find that.
>
> Thank you...
>
> --
>
> --
> 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
>



-- 
Thanks & regards,
Noorain Ansari
*http://noorain-ansari.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$$ Workbooks Consolidation Macro

[ashish koul]

try  this see if it helps



On Thu, Jul 21, 2011 at 10:12 PM, Anish Shrivastava wrote:

> Harish,
>
> Did you try it.. ??
>
> On Thu, Jul 21, 2011 at 5:19 PM, Anish Shrivastava wrote:
>
>> Harish,
>>
>> PLease ignore the earlier attachment as I forgot to add *DUPLICATE CHECK*in 
>> that macro.
>>
>> Use this attachment.
>>
>>   On Thu, Jul 21, 2011 at 5:09 PM, Anish Shrivastava > > wrote:
>>
>>> Hi Harsih,
>>>
>>> Since you didnt reply about column headers I assumed that it's the same
>>> for every file on share drive.
>>>
>>> Please see the attached file with macro.
>>>
>>> You must populate the file path in Sheet2-A1.
>>>
>>> Do let me know if it works fine for you.
>>> Cheers!!
>>> Anish
>>>   On Thu, Jul 21, 2011 at 4:00 PM, Anish Shrivastava <
>>> anish@gmail.com> wrote:
>>>
 Harish,

 I forgot to ask you one thing.
 The column headers in the file you attached will be constant for all the
 30-35 files which are there on your sharedrive, right?
 Cheers,
 Anish
   On Wed, Jul 20, 2011 at 11:06 PM, Harish Sharma <
 harishsharma...@gmail.com> wrote:

> Hi Anish,
>
> Please find attached the sample file with one row filled.
> And Column "C" & Column "H" concatenate should give us unique value so
> if this is repeated then we need to have below requested feature.
>
> Hope this would be more clear now.
>
> Thanks
> Harish
>
>
>
> On 20 July 2011 21:32, Anish Shrivastava  wrote:
>
>> One sample sheet would be helpful to us to see the data structure.
>>
>> However, for this "*Also identifiy if there is any row duplicated and
>> highlight them and paste them into another sheet" * There must be any
>> particular data field which has to be checked against others in order to
>> find duplicates.
>>
>> Macro for consolidation is not a big deal.
>>
>>
>> On Wed, Jul 20, 2011 at 7:35 PM, Harish Sharma <
>> harishsharma...@gmail.com> wrote:
>>
>>> Hi,
>>>
>>> I had a macro file which was able to consolidate small files but now
>>> I have a requirement to consolidate 30 workbooks saved in a share drive 
>>> and
>>> this data may even cross 66000 row after consolidation. Can someone 
>>> help me
>>> in creating a macro which picks all the file from shared folder and
>>> consolidates the one specific worksheet in all the workbook.
>>>
>>> This macro should also be capable of deleting any blank row in any of
>>> these 30 workbooks so that we donot miss any data if someone by error 
>>> has
>>> missed a couple of row and entered the data in couple of row below.
>>>
>>> 30 workbooks in sharedrive
>>> one specific worksheet from all of these named as "Tracker"
>>> Should cover all the blanks and delete them so that no data missed
>>> Also identifiy if there is any row duplicated and highlight them and
>>> paste them into another sheet
>>> If data crosses excel 2003 limit of row it should move to next
>>> worksheet.
>>>
>>> Hope to get a solution from excel experts.
>>>
>>> --
>>> Kind Regards,
>>> Harish Sharma
>>>
>>> --
>>>
>>> --
>>> 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
>>
>
>
>
> --
> Kind Regards,
> Harish Sharma
>
> --
>
> --
>>>

Re: $$Excel-Macros$$ VBA - Remove duplicate and get sums

[ashish koul]

create a pivot table . check the attachment.




On Thu, Jul 21, 2011 at 10:49 PM, Raghavendra wrote:

> Hi,
>
> Can anyone let me know VBA code for the below?
>
> Input Data
>
> Names   Amount
> A   100
> B   200
> C   100
> B   100
> A   100
> D   150
>
> Out put data should be
>
> Names   Amount
> A   200
> B   300
> C   100
> D   150
>
>
> Regards,
> Raghavendra
>
> --
>
> --
> 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*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


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


pivot.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Help Macro doesn´t work anymore, keeps giving same error

[ashish koul]

add this line before if condition see if it helps

wb.Sheets("Pivot").select

On Thu, Jul 21, 2011 at 11:56 PM, Anish Shrivastava wrote:

> is it possible to attach the sheet? You can remove the data from it or
> replace the values..
>
>
> On Thu, Jul 21, 2011 at 11:04 PM, Jorge Marques wrote:
>
>> Yes, the names are all ok, i double checked it, even try to change names,
>> but doesn´t work :S
>>
>>   2011/7/21 Anish Shrivastava 
>>
>>> Please check if the sheet name is "Pivot".
>>> if not then rename it to Pivot.
>>>   On Thu, Jul 21, 2011 at 10:44 PM, Jorge Marques 
>>> wrote:
>>>
 Hi guys, i have this macro i use to copy a range from column D of a
 worksheet of a workbook to column G of another workbook and worksheet, but
 it keeps giving me the same error saying that it´s "subscript out of range"
 in the line in yellow.

 Public wb, wbmes As Workbook
 Sub filldatabase()
 Call AbrirFile
 Call left
 wbmes.Close
 End Sub
 Private Sub AbrirFile()
 Dim Filter, Caption As String
 Dim SelectedFile As Variant
 Set wb = ThisWorkbook

 Filter = "Ficheiro XLS (*.xls),(*.xls)"
 Caption = "Escolha o ficheiro a importar..."
 SelectedFile = Application.GetOpenFilename(Filter, , Caption)
 If SelectedFile = False Then Exit Sub
 Set wbmes = Workbooks.Open(SelectedFile, 1, 1)
 End Sub

 Private Sub left()
 Dim a As Double
 wbmes.Activate
 wbmes.Sheets("Total_Refrige").Select
 wbmes.Sheets("Total_Refrige").Range(Range("D2"),
 Range("D2").End(xlDown)).Copy
 wb.Activate
 If wb.Sheets("Pivot").Range("G2").Value <> "" Then
 wb.Sheets("Pivot").Range("G1").End(xlDown).Offset(1, 0).Select
 Else
 wb.Sheets("Pivot").Range("G2").Select
 End If
 a = ActiveCell.Row
 wb.Sheets("Total Refrige").Paste
 Application.CutCopyMode = False
 i = a
 While wb.Sheets("Pivot").Range("G" & i).Value <> ""
 i = i + 1

 Wend
 End Sub

 Do you have any idea how to solve this?1000 thanks

 --

 --
 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
>>>
>>
>> --
>>
>> --
>> 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
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*b

Re: $$Excel-Macros$$ How to learn Excel VBA

[ashish koul]

try this book

http://www.recordexcelmacro.com/vebooks/RecordExcelMacrosthatWork.pdf

and  websites  join these forums

www.mrexcel.com www.contextures.com www.rondebruin.nl www.ozgrid.com
www.cpearson.com

peltiertech.com

chandoo.org

www.mvps.org/links.html

www.vbaexpress.com

www.functionx.com

www.freevbcode.com



www.excelforum.com





On Thu, Jul 21, 2011 at 11:10 PM, Prabhu  wrote:

> Hi,
>
> How to learn Excel VBA. If i chose VB.Net course it's cover Excel VBA
>
> Or any special course to learn Excel VBA.
>
> Also advice where i can learn.
>
> Regards,
>
> Prabhu
>
>  --
>
> --
> 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*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


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$$ Automatic Outlook message

[ashish koul]

check few examples here

http://akoul.blogspot.com/2010/07/vba-code-to-send-email-through-excel.html

http://akoul.blogspot.com/2011/07/sending-birthday-images-messages-to.html

http://akoul.blogspot.com/2010/08/sending-e-mail-based-on-data-in-column.html

On Fri, Jul 22, 2011 at 12:01 AM, Anish Shrivastava wrote:

> Yes Prabhu, It is possible.. Pour in your further details/sample
> attachments.
>
>
> On Thu, Jul 21, 2011 at 11:03 PM, Prabhu  wrote:
>
>> Hi all,
>>
>> I need to send Automatic mail message from my mail id to some around 10
>> members in every week end to remind them to do something.
>>
>> I can create distribution list for whom i have to send mails, Message
>> content will be same only.
>>
>> It needs to reach every week end to that particular distribution list
>> members.
>>
>> Is there any way to send automatic reminder mail ?
>>
>> Plz help.
>>
>> Regards
>>
>> Prabhu
>>
>> --
>>
>> --
>> 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
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


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$$ Excel formula help

[ashish koul]

try the attached file



On Fri, Jul 22, 2011 at 2:33 AM, Vikas Chouhan  wrote:

> try this
>
>
>
> =IF(ISERROR(REPLACE(A2,FIND("Opt.",A2),3,"#")),A2,(REPLACE(A2,FIND("Opt.",A2),3,"#")))
>
>
> On Thu, Jul 21, 2011 at 10:54 PM, Prabhu  wrote:
>
>> Hi Friends,
>>
>> In the attached sheet wherever we find *"Opt. "*(Opt dart and a space) is
>> replace with # and add with the  previous cell which does not contain
>> "Opt."originally.
>>
>> As per the attached sheet A9,10,11,12 we have to remove "Opt. " and add #
>> with A8 as prefix.
>>
>> Similarly in A3 "Opt. 0D1"- Remove "Opt. "and insert # in front of A2 text
>> i.e "AH401A"
>>
>> IF there is no Opt. in a particular cell it will remain as it is.
>>
>> Plz help me with formula.
>>
>> Regards,
>>
>> Prabhu
>>
>>
>>
>>
>>
>> --
>>
>> --
>> 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
>>
>
>
>
> --
> One Team One Dream One Goal
>
> Warm Regards,
> *Vikas Chauhan*
> E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
> 9911868518,
> "We can't Spell S_*ccess *without U"
>
> Life is Very beautiful !!!
> ¨`•.•´¨) Always
> `•.¸(¨`•.•´¨) Keep
> (¨`•.•´¨)¸.•´ Smiling!
> `•.¸.•´.
>
>  --
>
> --
> 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*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


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


Opt. .xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Excel formula help

[Vikas Chouhan]

try this


=IF(ISERROR(REPLACE(A2,FIND("Opt.",A2),3,"#")),A2,(REPLACE(A2,FIND("Opt.",A2),3,"#")))

On Thu, Jul 21, 2011 at 10:54 PM, Prabhu  wrote:

> Hi Friends,
>
> In the attached sheet wherever we find *"Opt. "*(Opt dart and a space) is
> replace with # and add with the  previous cell which does not contain
> "Opt."originally.
>
> As per the attached sheet A9,10,11,12 we have to remove "Opt. " and add #
> with A8 as prefix.
>
> Similarly in A3 "Opt. 0D1"- Remove "Opt. "and insert # in front of A2 text
> i.e "AH401A"
>
> IF there is no Opt. in a particular cell it will remain as it is.
>
> Plz help me with formula.
>
> Regards,
>
> Prabhu
>
>
>
>
>
> --
>
> --
> 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
>



-- 
One Team One Dream One Goal

Warm Regards,
*Vikas Chauhan*
E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
9911868518,
"We can't Spell S_*ccess *without U"

Life is Very beautiful !!!
¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`•.•´¨)¸.•´ Smiling!
`•.¸.•´.

-- 
--
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: RE: $$Excel-Macros$$ Excel formula help

[Haseeb Avarakkan]

Hello Prabhu,

Use this in B2 & copy down. 

=IF(ISNUMBER(SEARCH("Opt. ",A2)),LOOKUP(2,1/ISERROR(SEARCH("Opt. 
",A$2:A2)),A$2:A2)&SUBSTITUTE(A2,"Opt. ","#"),A2)

Then copy Col_B *Paste Values *in Col_A. Then after delete Col_B.

HTH
Haseeb

-- 
--
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$$ Excel formula help

[Daniel]

Hi,

You can’t do it with a formula (a formula only changes the value of the cell
which contains it). Either you use the replace command (Ctrl+H) or you have
to use a macro.

Regards.

Daniel

 

De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Prabhu
Envoyé : jeudi 21 juillet 2011 19:24
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Excel formula help

 

Hi Friends,

 

In the attached sheet wherever we find "Opt. "(Opt dart and a space) is
replace with # and add with the  previous cell which does not contain
"Opt."originally.

 

As per the attached sheet A9,10,11,12 we have to remove "Opt. " and add #
with A8 as prefix.

 

Similarly in A3 "Opt. 0D1"- Remove "Opt. "and insert # in front of A2 text
i.e "AH401A"

 

IF there is no Opt. in a particular cell it will remain as it is.

 

Plz help me with formula.

 

Regards,

 

Prabhu

 

 

 

 

-- 

--
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$$ VBA Conditional Format Offset

[Daniel]

Try :

Sub ConFormatOffset3()
Dim LastRow As Long
LastRow = Cells.Find("*", , , , xlByRows, xlPrevious).Row
With Range([D1], Cells(LastRow, "EJ"))
.FormatConditions.Delete
.FormatConditions.Add Type:=xlExpression,
Formula1:="=AND(F1<>,D1>F1)"
.FormatConditions(1).Interior.Color = RGB(255, 0, 0)
End With
End Sub

Note that the formula has to be written in your local version of Excel. As
far as I am concerned, I have to translate it in French.
Regards.
Daniel

-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Natron
Envoyé : jeudi 21 juillet 2011 19:05
À : MS EXCEL AND VBA MACROS
Objet : Re: $$Excel-Macros$$ VBA Conditional Format Offset

Thanks Daniel that works, but I'm still trying to wrap my head around
applying this format to various ranges on the worksheet.

My data I'm comparing is in Column D and F, E and Getc all the way up to
Column EK.  Any pointers on skipping around with this formula?

Thanks again!

Natron


> Try :
>
> Sub ConFormatOffset()
>     With Range([A1], Cells(Rows.Count, 1).End(xlUp))
>         .FormatConditions.Delete
>         .FormatConditions.Add Type:=xlExpression, Operator:=xlGreater, 
> _
>             Formula1:="=A1>B1"
>         .FormatConditions(1).Interior.Color = RGB(255, 0, 0)
>     End With
> End Sub
>
> Daniel

--

--
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$$ Re: VBA - Remove duplicate and get sums

[GoldenLance]

A Pivot Table is used precisely for such computations. As a thumb
rule, use Excel functions and tools where Excel can handle it
efficiently. Use VBA only if Excel cannot give desired output on its
own

On Jul 21, 10:19 pm, Raghavendra  wrote:
> Hi,
>
> Can anyone let me know VBA code for the below?
>
> Input Data
>
> Names   Amount
> A       100
> B       200
> C       100
> B       100
> A       100
> D       150
>
> Out put data should be
>
> Names   Amount
> A       200
> B       300
> C       100
> D       150
>
> Regards,
> Raghavendra

-- 
--
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$$ Automatic Outlook message

[Anish Shrivastava]

Yes Prabhu, It is possible.. Pour in your further details/sample
attachments.

On Thu, Jul 21, 2011 at 11:03 PM, Prabhu  wrote:

> Hi all,
>
> I need to send Automatic mail message from my mail id to some around 10
> members in every week end to remind them to do something.
>
> I can create distribution list for whom i have to send mails, Message
> content will be same only.
>
> It needs to reach every week end to that particular distribution list
> members.
>
> Is there any way to send automatic reminder mail ?
>
> Plz help.
>
> Regards
>
> Prabhu
>
> --
>
> --
> 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$$ Re: ***Formula for find and replace***

[Anish Shrivastava]

Haseeb Sir,

I am becoming a FAN of you... You seem to have super knowledge of
Formulas... tooo good...

On Thu, Jul 21, 2011 at 9:58 PM, Haseeb Avarakkan <
haseeb.avarak...@gmail.com> wrote:

> Hello Prabhu,
>
> Use SUBSTITUTE. or excel's Find/Replace command
>
> SUBSTITUTE is a case sensitive function, so you need convert the cell to
> UPPER or LOWER, so use,
>
> =SUBSTITUTE(UPPER(A1),"ABC","")
>
> Or,
>
> =SUBSTITUTE(LOWER(A1),"abc","")
>
> All the letters in 1st output will be in CAPITAL LETTERS
> All the letters in 2nd output will be in small letters.
>
> If you need the results as the same as original, Try this,
>
>
> =INDEX(SUBSTITUTE(A1,{"ABC","abc"},""),MATCH(MIN(LEN(SUBSTITUTE(A1,{"ABC","abc"},""))),LEN(SUBSTITUTE(A1,{"ABC","abc"},"")),0))
>
> Or use Find/Replace command. select the range, Press Control+F
>
> Find What: abc
> leave the Replace with blank, then click Replace All
>
> HTH
> Haseeb
>
> --
>
> --
> 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 Macro doesn´t work anymore, keeps giving same error

[Anish Shrivastava]

is it possible to attach the sheet? You can remove the data from it or
replace the values..

On Thu, Jul 21, 2011 at 11:04 PM, Jorge Marques wrote:

> Yes, the names are all ok, i double checked it, even try to change names,
> but doesn´t work :S
>
>   2011/7/21 Anish Shrivastava 
>
>> Please check if the sheet name is "Pivot".
>> if not then rename it to Pivot.
>>   On Thu, Jul 21, 2011 at 10:44 PM, Jorge Marques 
>> wrote:
>>
>>> Hi guys, i have this macro i use to copy a range from column D of a
>>> worksheet of a workbook to column G of another workbook and worksheet, but
>>> it keeps giving me the same error saying that it´s "subscript out of range"
>>> in the line in yellow.
>>>
>>> Public wb, wbmes As Workbook
>>> Sub filldatabase()
>>> Call AbrirFile
>>> Call left
>>> wbmes.Close
>>> End Sub
>>> Private Sub AbrirFile()
>>> Dim Filter, Caption As String
>>> Dim SelectedFile As Variant
>>> Set wb = ThisWorkbook
>>>
>>> Filter = "Ficheiro XLS (*.xls),(*.xls)"
>>> Caption = "Escolha o ficheiro a importar..."
>>> SelectedFile = Application.GetOpenFilename(Filter, , Caption)
>>> If SelectedFile = False Then Exit Sub
>>> Set wbmes = Workbooks.Open(SelectedFile, 1, 1)
>>> End Sub
>>>
>>> Private Sub left()
>>> Dim a As Double
>>> wbmes.Activate
>>> wbmes.Sheets("Total_Refrige").Select
>>> wbmes.Sheets("Total_Refrige").Range(Range("D2"),
>>> Range("D2").End(xlDown)).Copy
>>> wb.Activate
>>> If wb.Sheets("Pivot").Range("G2").Value <> "" Then
>>> wb.Sheets("Pivot").Range("G1").End(xlDown).Offset(1, 0).Select
>>> Else
>>> wb.Sheets("Pivot").Range("G2").Select
>>> End If
>>> a = ActiveCell.Row
>>> wb.Sheets("Total Refrige").Paste
>>> Application.CutCopyMode = False
>>> i = a
>>> While wb.Sheets("Pivot").Range("G" & i).Value <> ""
>>> i = i + 1
>>>
>>> Wend
>>> End Sub
>>>
>>> Do you have any idea how to solve this?1000 thanks
>>>
>>> --
>>>
>>> --
>>> 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
>>
>
> --
>
> --
> 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$$ How to learn Excel VBA

[Prabhu]

Hi,

How to learn Excel VBA. If i chose VB.Net course it's cover Excel VBA 

Or any special course to learn Excel VBA.

Also advice where i can learn.

Regards,

Prabhu

-- 
--
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 Macro doesn´t work anymore, keeps giving same error

[Jorge Marques]

Yes, the names are all ok, i double checked it, even try to change names,
but doesn´t work :S

2011/7/21 Anish Shrivastava 

> Please check if the sheet name is "Pivot".
> if not then rename it to Pivot.
>   On Thu, Jul 21, 2011 at 10:44 PM, Jorge Marques wrote:
>
>> Hi guys, i have this macro i use to copy a range from column D of a
>> worksheet of a workbook to column G of another workbook and worksheet, but
>> it keeps giving me the same error saying that it´s "subscript out of range"
>> in the line in yellow.
>>
>> Public wb, wbmes As Workbook
>> Sub filldatabase()
>> Call AbrirFile
>> Call left
>> wbmes.Close
>> End Sub
>> Private Sub AbrirFile()
>> Dim Filter, Caption As String
>> Dim SelectedFile As Variant
>> Set wb = ThisWorkbook
>>
>> Filter = "Ficheiro XLS (*.xls),(*.xls)"
>> Caption = "Escolha o ficheiro a importar..."
>> SelectedFile = Application.GetOpenFilename(Filter, , Caption)
>> If SelectedFile = False Then Exit Sub
>> Set wbmes = Workbooks.Open(SelectedFile, 1, 1)
>> End Sub
>>
>> Private Sub left()
>> Dim a As Double
>> wbmes.Activate
>> wbmes.Sheets("Total_Refrige").Select
>> wbmes.Sheets("Total_Refrige").Range(Range("D2"),
>> Range("D2").End(xlDown)).Copy
>> wb.Activate
>> If wb.Sheets("Pivot").Range("G2").Value <> "" Then
>> wb.Sheets("Pivot").Range("G1").End(xlDown).Offset(1, 0).Select
>> Else
>> wb.Sheets("Pivot").Range("G2").Select
>> End If
>> a = ActiveCell.Row
>> wb.Sheets("Total Refrige").Paste
>> Application.CutCopyMode = False
>> i = a
>> While wb.Sheets("Pivot").Range("G" & i).Value <> ""
>> i = i + 1
>>
>> Wend
>> End Sub
>>
>> Do you have any idea how to solve this?1000 thanks
>>
>> --
>>
>> --
>> 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
>

-- 
--
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$$ Call Center Dashboards

[Raghunandan]

Hi Guys,

Can any1 help me out by sending Call center KPI dashboards or any link where
in I can find that.

Thank you...

-- 
--
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$$ VBA - Remove duplicate and get sums

[Raghavendra]

Hi,

Can anyone let me know VBA code for the below?

Input Data

Names   Amount
A   100
B   200
C   100
B   100
A   100
D   150

Out put data should be

Names   Amount
A   200
B   300
C   100
D   150


Regards,
Raghavendra

-- 
--
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: RE: $$Excel-Macros$$ adding adjacent (contagious) cells only

[Haseeb Avarakkan]

Thank you Dave for the last cell point & the correction. I didn't notice the 
last column being Yes.

I think Column U don't have to be blank, because we have an additional 
column (A) without Yes or No, so If we change the formula without including 
column U, like,

=SUMPRODUCT(--(B2:T2="Yes"),--(A2:S2<>"Yes"))

Or,

=COUNTIFS(B2:T2,"Yes",A2:S2,"<>Yes")

Regards,
Haseeb

-- 
--
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$$ Re: ***Formula for find and replace***

[Haseeb Avarakkan]

Hello Prabhu,

Use SUBSTITUTE. or excel's Find/Replace command

SUBSTITUTE is a case sensitive function, so you need convert the cell to 
UPPER or LOWER, so use,

=SUBSTITUTE(UPPER(A1),"ABC","")

Or,

=SUBSTITUTE(LOWER(A1),"abc","")

All the letters in 1st output will be in CAPITAL LETTERS
All the letters in 2nd output will be in small letters.

If you need the results as the same as original, Try this,

=INDEX(SUBSTITUTE(A1,{"ABC","abc"},""),MATCH(MIN(LEN(SUBSTITUTE(A1,{"ABC","abc"},""))),LEN(SUBSTITUTE(A1,{"ABC","abc"},"")),0))

Or use Find/Replace command. select the range, Press Control+F

Find What: abc
leave the Replace with blank, then click Replace All

HTH
Haseeb

-- 
--
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$$ Automatic Outlook message

[Prabhu]

Hi all,

I need to send Automatic mail message from my mail id to some around 10 
members in every week end to remind them to do something.

I can create distribution list for whom i have to send mails, Message 
content will be same only.

It needs to reach every week end to that particular distribution list 
members.

Is there any way to send automatic reminder mail ?

Plz help.

Regards

Prabhu

-- 
--
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$$ Group Survey : Your feedback is important

[Ayush Jain]

Dear members,

Thanks for all your contribution to group. I am very happy to see the
great participation in the group.

For me its very important to know what you feel about the group, So that I
can take any action or initiative on the basis of your feedback.
This is an anonymous survey, so feel free to share your views and the
activities you would like to see in this group. Your valuable feedback is
highly appreciated.

To participate in survey, Please follow the below link
http://www.surveymonkey.com/s/L8BTDNQ

Thanks again and Keep Posting. :)

Best regards,
Ayush Jain
Group Manager

-- 
--
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$$ Excel formula help

[Prabhu]

Hi Friends,

In the attached sheet wherever we find *"Opt. "*(Opt dart and a space) is 
replace with # and add with the  previous cell which does not contain 
"Opt."originally.

As per the attached sheet A9,10,11,12 we have to remove "Opt. " and add # 
with A8 as prefix.

Similarly in A3 "Opt. 0D1"- Remove "Opt. "and insert # in front of A2 text 
i.e "AH401A"

IF there is no Opt. in a particular cell it will remain as it is.

Plz help me with formula.

Regards,

Prabhu



 

-- 
--
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


Opt. .xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Help Macro doesn´t work anymore, keeps giving same error

[Anish Shrivastava]

Please check if the sheet name is "Pivot".
if not then rename it to Pivot.
On Thu, Jul 21, 2011 at 10:44 PM, Jorge Marques wrote:

> Hi guys, i have this macro i use to copy a range from column D of a
> worksheet of a workbook to column G of another workbook and worksheet, but
> it keeps giving me the same error saying that it´s "subscript out of range"
> in the line in yellow.
>
> Public wb, wbmes As Workbook
> Sub filldatabase()
> Call AbrirFile
> Call left
> wbmes.Close
> End Sub
> Private Sub AbrirFile()
> Dim Filter, Caption As String
> Dim SelectedFile As Variant
> Set wb = ThisWorkbook
>
> Filter = "Ficheiro XLS (*.xls),(*.xls)"
> Caption = "Escolha o ficheiro a importar..."
> SelectedFile = Application.GetOpenFilename(Filter, , Caption)
> If SelectedFile = False Then Exit Sub
> Set wbmes = Workbooks.Open(SelectedFile, 1, 1)
> End Sub
>
> Private Sub left()
> Dim a As Double
> wbmes.Activate
> wbmes.Sheets("Total_Refrige").Select
> wbmes.Sheets("Total_Refrige").Range(Range("D2"),
> Range("D2").End(xlDown)).Copy
> wb.Activate
> If wb.Sheets("Pivot").Range("G2").Value <> "" Then
> wb.Sheets("Pivot").Range("G1").End(xlDown).Offset(1, 0).Select
> Else
> wb.Sheets("Pivot").Range("G2").Select
> End If
> a = ActiveCell.Row
> wb.Sheets("Total Refrige").Paste
> Application.CutCopyMode = False
> i = a
> While wb.Sheets("Pivot").Range("G" & i).Value <> ""
> i = i + 1
>
> Wend
> End Sub
>
> Do you have any idea how to solve this?1000 thanks
>
> --
>
> --
> 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$$ Help Macro doesn´t work anymore, keeps giving same error

[Jorge Marques]

Hi guys, i have this macro i use to copy a range from column D of a
worksheet of a workbook to column G of another workbook and worksheet, but
it keeps giving me the same error saying that it´s "subscript out of range"
in the line in yellow.

Public wb, wbmes As Workbook
Sub filldatabase()
Call AbrirFile
Call left
wbmes.Close
End Sub
Private Sub AbrirFile()
Dim Filter, Caption As String
Dim SelectedFile As Variant
Set wb = ThisWorkbook

Filter = "Ficheiro XLS (*.xls),(*.xls)"
Caption = "Escolha o ficheiro a importar..."
SelectedFile = Application.GetOpenFilename(Filter, , Caption)
If SelectedFile = False Then Exit Sub
Set wbmes = Workbooks.Open(SelectedFile, 1, 1)
End Sub

Private Sub left()
Dim a As Double
wbmes.Activate
wbmes.Sheets("Total_Refrige").Select
wbmes.Sheets("Total_Refrige").Range(Range("D2"),
Range("D2").End(xlDown)).Copy
wb.Activate
If wb.Sheets("Pivot").Range("G2").Value <> "" Then
wb.Sheets("Pivot").Range("G1").End(xlDown).Offset(1, 0).Select
Else
wb.Sheets("Pivot").Range("G2").Select
End If
a = ActiveCell.Row
wb.Sheets("Total Refrige").Paste
Application.CutCopyMode = False
i = a
While wb.Sheets("Pivot").Range("G" & i).Value <> ""
i = i + 1

Wend
End Sub

Do you have any idea how to solve this?1000 thanks

-- 
--
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$$ VBA Conditional Format Offset

[Natron]

Thanks Daniel that works, but I'm still trying to wrap my head around
applying this format to various ranges on the worksheet.

My data I'm comparing is in Column D and F, E and Getc all the way
up to Column EK.  Any pointers on skipping around with this formula?

Thanks again!

Natron


> Try :
>
> Sub ConFormatOffset()
>     With Range([A1], Cells(Rows.Count, 1).End(xlUp))
>         .FormatConditions.Delete
>         .FormatConditions.Add Type:=xlExpression, Operator:=xlGreater, _
>             Formula1:="=A1>B1"
>         .FormatConditions(1).Interior.Color = RGB(255, 0, 0)
>     End With
> End Sub
>
> Daniel

-- 
--
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$$ Re: ***Formula for find and replace***

[Prabhu]

Hi All,

Great!!! Thanks..

Regards,

Prabhu

-- 
--
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$$ Re: ***Formula for find and replace***

[GoldenLance]

@Anish, that's cool dude, just trying to help.

Sam Mathai Chacko

On Jul 21, 9:41 pm, Anish Shrivastava  wrote:
> Prabhu,
>
> Use the solution given by GoldenLance below.
>
> =SUBSTITUTE(A1,"ABC","#")
> *GoldenLance,*
> Thanks Man, This formula didnt hit my mind at that time.
>
>
>
>
>
>
>
> On Thu, Jul 21, 2011 at 10:02 PM, GoldenLance  wrote:
> > Wouldn't this be much more easier, and apt?
>
> > =SUBSTITUTE(A1,"ABC","#")
>
> > On Jul 21, 9:27 pm, Prabhu  wrote:
> > > Hi Anish,
>
> > > If it is "ABC12" and i need to replace the ABC form the cell then the
> > > formula will be ?
>
> > > Regards,
>
> > > Prabhu
>
> > --
>
> > --
> > 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 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$$ Workbooks Consolidation Macro

[Anish Shrivastava]

Harish,

Did you try it.. ??

On Thu, Jul 21, 2011 at 5:19 PM, Anish Shrivastava wrote:

> Harish,
>
> PLease ignore the earlier attachment as I forgot to add *DUPLICATE CHECK*in 
> that macro.
>
> Use this attachment.
>
>   On Thu, Jul 21, 2011 at 5:09 PM, Anish Shrivastava 
> wrote:
>
>> Hi Harsih,
>>
>> Since you didnt reply about column headers I assumed that it's the same
>> for every file on share drive.
>>
>> Please see the attached file with macro.
>>
>> You must populate the file path in Sheet2-A1.
>>
>> Do let me know if it works fine for you.
>> Cheers!!
>> Anish
>>   On Thu, Jul 21, 2011 at 4:00 PM, Anish Shrivastava > > wrote:
>>
>>> Harish,
>>>
>>> I forgot to ask you one thing.
>>> The column headers in the file you attached will be constant for all the
>>> 30-35 files which are there on your sharedrive, right?
>>> Cheers,
>>> Anish
>>>   On Wed, Jul 20, 2011 at 11:06 PM, Harish Sharma <
>>> harishsharma...@gmail.com> wrote:
>>>
 Hi Anish,

 Please find attached the sample file with one row filled.
 And Column "C" & Column "H" concatenate should give us unique value so
 if this is repeated then we need to have below requested feature.

 Hope this would be more clear now.

 Thanks
 Harish



 On 20 July 2011 21:32, Anish Shrivastava  wrote:

> One sample sheet would be helpful to us to see the data structure.
>
> However, for this "*Also identifiy if there is any row duplicated and
> highlight them and paste them into another sheet" * There must be any
> particular data field which has to be checked against others in order to
> find duplicates.
>
> Macro for consolidation is not a big deal.
>
>
> On Wed, Jul 20, 2011 at 7:35 PM, Harish Sharma <
> harishsharma...@gmail.com> wrote:
>
>> Hi,
>>
>> I had a macro file which was able to consolidate small files but now I
>> have a requirement to consolidate 30 workbooks saved in a share drive and
>> this data may even cross 66000 row after consolidation. Can someone help 
>> me
>> in creating a macro which picks all the file from shared folder and
>> consolidates the one specific worksheet in all the workbook.
>>
>> This macro should also be capable of deleting any blank row in any of
>> these 30 workbooks so that we donot miss any data if someone by error has
>> missed a couple of row and entered the data in couple of row below.
>>
>> 30 workbooks in sharedrive
>> one specific worksheet from all of these named as "Tracker"
>> Should cover all the blanks and delete them so that no data missed
>> Also identifiy if there is any row duplicated and highlight them and
>> paste them into another sheet
>> If data crosses excel 2003 limit of row it should move to next
>> worksheet.
>>
>> Hope to get a solution from excel experts.
>>
>> --
>> Kind Regards,
>> Harish Sharma
>>
>> --
>>
>> --
>> 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
>



 --
 Kind Regards,
 Harish Sharma

 --

 --
 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

Re: $$Excel-Macros$$ Re: ***Formula for find and replace***

[Anish Shrivastava]

Prabhu,

Use the solution given by GoldenLance below.

=SUBSTITUTE(A1,"ABC","#")
*GoldenLance,*
Thanks Man, This formula didnt hit my mind at that time.

On Thu, Jul 21, 2011 at 10:02 PM, GoldenLance  wrote:

> Wouldn't this be much more easier, and apt?
>
> =SUBSTITUTE(A1,"ABC","#")
>
> On Jul 21, 9:27 pm, Prabhu  wrote:
> > Hi Anish,
> >
> > If it is "ABC12" and i need to replace the ABC form the cell then the
> > formula will be ?
> >
> > Regards,
> >
> > Prabhu
>
> --
>
> --
> 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$$ Re: ***Formula for find and replace***

[GoldenLance]

Wouldn't this be much more easier, and apt?

=SUBSTITUTE(A1,"ABC","#")

On Jul 21, 9:27 pm, Prabhu  wrote:
> Hi Anish,
>
> If it is "ABC12" and i need to replace the ABC form the cell then the
> formula will be ?
>
> Regards,
>
> Prabhu

-- 
--
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$$ ***Formula for find and replace***

[Vikas Chouhan]

Hey Prabhu,


try this formula


=IF(ISERROR(REPLACE(A1,FIND("ABC",A1),3,"#")),A1,(REPLACE(A1,FIND("ABC",A1),3,"#")))



On Thu, Jul 21, 2011 at 8:50 PM, Prabhu  wrote:

> Hi Friends,
>
> Can  you help me to know the formula for find and replace.Examble i need to
> find  "ABC in the A1 cell and replace with "#". If there is no 'ABC"
>  existing A1 should remain as it is.
>
>Existing CellReplace as
>  12ABC 12# 13XTZ 13XTZ
>
> --
>
> --
> 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
>



-- 


Warm Regards,
*Vikas Chauhan*


"We can't Spell S_*ccess *without U"

Life is Very beautiful !!!
¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`•.•´¨)¸.•´ Smiling!
`•.¸.•´.

-- 
--
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$$ Re: ***Formula for find and replace***

[Prabhu]

Hi Anish,

If it is "ABC12" and i need to replace the ABC form the cell then the 
formula will be ?

Regards,

Prabhu

-- 
--
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$$ VBA Conditional Format Offset

[Daniel]

Try :

Sub ConFormatOffset()
With Range([A1], Cells(Rows.Count, 1).End(xlUp))
.FormatConditions.Delete
.FormatConditions.Add Type:=xlExpression, Operator:=xlGreater, _
Formula1:="=A1>B1"
.FormatConditions(1).Interior.Color = RGB(255, 0, 0)
End With
End Sub

Daniel

-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Natron
Envoyé : jeudi 21 juillet 2011 04:15
À : MS EXCEL AND VBA MACROS
Objet : $$Excel-Macros$$ VBA Conditional Format Offset

I have multiple columns (around 140) of data and need to conditionally
format the data as apposed to looping through.

For instance I have the following data in column A and B.

A B
1 10
2 1
8 4
4 3
5 6

Here is basically what I'm trying to do:
If Column A has a value Greater than Column B then change Column A cell
interior color to red

My attempt in a Macro to perform this task is Below...not quite working

Sub ConFormatOffset()
With Selection
Debug.Print ActiveCell
Debug.Print ActiveCell.Offset(0, 2)
.FormatConditions.Delete
.FormatConditions.Add Type:=xlExpression, Operator:=xlGreater,
Formula1:="=A1>Offset(ActiveCell,0,2)"
.FormatConditions(1).Interior.Color = RGB(255, 0, 0)
End With
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

-- 
--
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$$ Re: ***Formula for find and replace***

[GoldenLance]

If you are looking for an Excel formula, just use

=SUBSTITUTE(A1,"ABC","")

On Jul 21, 8:37 pm, "Daniel"  wrote:
> HI,
>
> Sub ABCReplace()
>
>     [A1].Replace "ABC", "#"
>
> End Sub
>
> Regards.
>
> Daniel
>
> De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
> la part de Prabhu
> Envoyé : jeudi 21 juillet 2011 17:26
> À : excel-macros@googlegroups.com
> Objet : $$Excel-Macros$$ Re: ***Formula for find and replace***
>
> Hi Friends,
>
> Can  you help me to know the formula for find and replace.Example i need to
> find  "ABC in the A1 cell and replace with "#". If there is no 'ABC"
> existing A1 should remain as it is.(Not using ctr+H)
>
> Example.
>
> Existing Cell              Replace as
>
> 12ABC                       12#
>
> 13XYZ                        13XYZ
>
> --
> 
> --
> 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 
> linkhttp://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$$ Looping an array

[GoldenLance]

You are welcome.

Oh just noticed, out of curiosity, why is my message displayed after
Ashish's? I messaged it before!!

On Jul 21, 2:47 am, Natron  wrote:
> Thanks to both Ashish and GoldenLance. Problem solved.

-- 
--
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$$ Re: ***Formula for find and replace***

[Daniel]

HI,

 

Sub ABCReplace()

[A1].Replace "ABC", "#"

End Sub

 

Regards.

Daniel

 

De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Prabhu
Envoyé : jeudi 21 juillet 2011 17:26
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Re: ***Formula for find and replace***

 

Hi Friends,

 

Can  you help me to know the formula for find and replace.Example i need to
find  "ABC in the A1 cell and replace with "#". If there is no 'ABC"
existing A1 should remain as it is.(Not using ctr+H)

 

Example.

 

Existing Cell  Replace as

12ABC   12#

 

13XYZ13XYZ

-- 

--
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$$ Re: ***Formula for find and replace***

[Anish Shrivastava]

Giving the formula as per your  example.

*=IF(RIGHT(A1,3)="ABC",LEFT(A1,2)&"#",A1)*

Copy it down.

On Thu, Jul 21, 2011 at 8:55 PM, Prabhu  wrote:

> Hi Friends,
>
> Can  you help me to know the formula for find and replace.Example i need to
> find  "ABC in the A1 cell and replace with "#". If there is no 'ABC"
>  existing A1 should remain as it is.(Not using ctr+H)
>
> *Example.*
>
> Existing Cell  Replace as
> 12ABC   12#
>
> 13XYZ13XYZ
>
> --
>
> --
> 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$$ Re: ***Formula for find and replace***

[Prabhu]

Hi Friends,

Can  you help me to know the formula for find and replace.Example i need to 
find  "ABC in the A1 cell and replace with "#". If there is no 'ABC" 
 existing A1 should remain as it is.(Not using ctr+H)

*Example.*

Existing Cell  Replace as
12ABC   12#

13XYZ13XYZ

-- 
--
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$$ ***Formula for find and replace***

[Prabhu]

Hi Friends,

Can  you help me to know the formula for find and replace.Examble i need to 
find  "ABC in the A1 cell and replace with "#". If there is no 'ABC" 
 existing A1 should remain as it is.

   Existing CellReplace as  
 12ABC 12# 13XTZ 13XTZ  

-- 
--
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 requ

[vijayajith VA]

Hi,

I have names, order no and county names in two sheets.. need to consolidate
in one sheet..

Thanks


On Thu, Jul 21, 2011 at 7:04 PM, Anish Shrivastava wrote:

> Vijay,
>
> Though you have provided the sample sheet your requirement is not clear.
>
> What do you mean by merge the names in one sheet. do you want to
> consolidate the data or you want a concatenation.
>
> On Thu, Jul 21, 2011 at 5:33 PM, vijayajith VA wrote:
>
>> fyi
>>
>>
>> On Wed, Jul 20, 2011 at 6:25 PM, NOORAIN ANSARI > > wrote:
>>
>>> Dear Vijay,
>>>
>>> Please provide sample sheet
>>>
>>>   On Wed, Jul 20, 2011 at 5:49 PM, vijayajith VA <
>>> vijayajith...@gmail.com> wrote:
>>>
 Hi,


 1;
  I have several names in two sheets..i need to merge it in one
 sheet...is this possible using formula..

 Thanks



 --

 --
 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

>>>
>>>
>>>
>>> --
>>> Thanks & regards,
>>> Noorain Ansari
>>> *http://noorain-ansari.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
>>>
>>
>> --
>>
>> --
>> 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
>

-- 
--
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 requ

[Anish Shrivastava]

Vijay,

Though you have provided the sample sheet your requirement is not clear.

What do you mean by merge the names in one sheet. do you want to consolidate
the data or you want a concatenation.

On Thu, Jul 21, 2011 at 5:33 PM, vijayajith VA wrote:

> fyi
>
>
> On Wed, Jul 20, 2011 at 6:25 PM, NOORAIN ANSARI 
> wrote:
>
>> Dear Vijay,
>>
>> Please provide sample sheet
>>
>>   On Wed, Jul 20, 2011 at 5:49 PM, vijayajith VA > > wrote:
>>
>>> Hi,
>>>
>>>
>>> 1;
>>>  I have several names in two sheets..i need to merge it in one sheet...is
>>> this possible using formula..
>>>
>>> Thanks
>>>
>>>
>>>
>>> --
>>>
>>> --
>>> 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
>>>
>>
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> *http://noorain-ansari.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
>>
>
> --
>
> --
> 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$$ Urgent Help needed-Dashboards

[Venkatesan c]

Hi  Avinash,

Try below Links,

http://www.l3analytics.com/2011/05/16/free-excel-dashboard-template/
http://www.excelcharts.com/blog/how-to-create-an-excel-dashboard/
http://www.contextures.com/excel-dashboards.html
http://www.mrdashboard.com/download.html

-- 
*Best Regards,*
*Venkat*
*
*

On Thu, Jul 21, 2011 at 5:49 PM, Aindril De  wrote:

> Hi Avinash,
>
> Try this:
>
> http://www.freeexceldashboards.com/exceldashboardtemplates.html
>
> Cheers,
> Andy
>
> On Thu, Jul 21, 2011 at 4:49 PM, Avinash Patil 
> wrote:
>
>> Hi Masters,
>>
>> can anybody please forward me excel dashboard designs i need dashboard
>> designs with all automations and vba work like drop downs , charts, graphs
>> "a dashboard with full graphical and customization interface"
>>
>> i'll be realy greatfull to you guys please forward me the designs,
>>
>> Regards,
>>
>> Avinash
>>
>> --
>>
>> --
>> 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
>>
>
>
>
> --
>
> Warm Regards,
> Aindril De
> Unified Learning Pvt Ltd.
> Ph: 9811300157
>
>  --
>
> --
> 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$$ Extracting data from Website

[ashish koul]

http://akoul.blogspot.com/2011/06/macro-to-import-data-from-webpage-to.html

http://akoul.blogspot.com/2011/06/copy-data-of-webpage-to-excel-using.html

http://akoul.blogspot.com/2011/06/macro-to-copy-text-from-webpage-to.html

On Thu, Jul 21, 2011 at 6:30 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:

> Any link is ok. Just I need to learn how to do this task. Thanks.
>
> On Thu, Jul 21, 2011 at 2:15 PM, ashish koul wrote:
>
>> can you send the direct  link
>>
>>
>> On Thu, Jul 21, 2011 at 4:34 PM, Chandra Shekar <
>> chandrashekarb@gmail.com> wrote:
>>
>>> Hi,
>>>
>>> How to extract data from websites for ex: Yahoo News Columns. could
>>> anyone provide VBA code for this. Thanks!
>>>
>>> --
>>>
>>> --
>>> 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*
>> *akoul*.*blogspot*.com 
>> http://akoul.posterous.com/
>>  *akoul*.wordpress.com 
>> My Linkedin Profile 
>>
>>
>> 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
>>
>
>  --
>
> --
> 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*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


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$$ Extracting data from Website

[Chandra Shekar]

Any link is ok. Just I need to learn how to do this task. Thanks.

On Thu, Jul 21, 2011 at 2:15 PM, ashish koul  wrote:

> can you send the direct  link
>
>
> On Thu, Jul 21, 2011 at 4:34 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hi,
>>
>> How to extract data from websites for ex: Yahoo News Columns. could anyone
>> provide VBA code for this. Thanks!
>>
>> --
>>
>> --
>> 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*
> *akoul*.*blogspot*.com 
> http://akoul.posterous.com/
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> 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
>

-- 
--
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$$ to find particular column and insert one column and perform Vlookup using vba

[Rajasekhar Praharaju]

Thanks a ton to one all really helped me alot in this concern.

On Mon, Jul 18, 2011 at 11:30 PM, Mahesh parab  wrote:

> Hi
>
> For Vlookup you can use static Name range which is predetermined
> RANGE
> =SBUMapping!$A$1:$D$789
> OR
> dynamic Name range range which resize dynamically
> RANGE
>
> =OFFSET(SBUMapping!$A$1,0,0,COUNTA(SBUMapping!$A:$A),COUNTA(SBUMapping!$1:$1))
>
>
> Thanks
> Mahesh
>
>
> On Mon, Jul 18, 2011 at 11:05 PM, Mahesh parab  wrote:
>
>> Hi Prathima
>>
>> Assuming your Data 1,2 & 3 columns contain data
>>
>> Try :
>>
>> Sub test()
>> Dim LR As Long
>> Sheets("Summary").Select
>>
>> Set Found = Sheets("Summary").Rows(1).Find(what:="Data 1",
>> LookIn:=xlValues, lookat:=xlWhole)
>> LR = Cells(Rows.Count, Found.Column).End(xlUp).Row
>> Found.Offset(, 1).EntireColumn.Insert
>> Cells(1, Found.Column + 1).Value = "SBU"
>> Range(Cells(2, Found.Column + 1), Cells(LR, Found.Column + 1)).Formula =
>> Application.VLookup(Range(Cells(2, Found.Column), Cells(LR, Found.Column)),
>> Range("RANGE"), 2, False)
>>
>> Set Found = Sheets("Summary").Rows(1).Find(what:="Data2",
>> LookIn:=xlValues, lookat:=xlWhole)
>> LR = Cells(Rows.Count, Found.Column).End(xlUp).Row
>> Found.Offset(, 1).EntireColumn.Insert
>> Cells(1, Found.Column + 1).Value = "Region"
>> Range(Cells(2, Found.Column + 1), Cells(LR, Found.Column + 1)).Formula =
>> Application.VLookup(Range(Cells(2, Found.Column), Cells(LR, Found.Column)),
>> Range("RANGE"), 3, False)
>>
>> Set Found = Sheets("Summary").Rows(1).Find(what:="Data3",
>> LookIn:=xlValues, lookat:=xlWhole)
>> LR = Cells(Rows.Count, Found.Column).End(xlUp).Row
>> Found.Offset(, 1).EntireColumn.Insert
>> Cells(1, Found.Column + 1).Value = "Division"
>> Range(Cells(2, Found.Column + 1), Cells(LR, Found.Column + 1)).Formula =
>> Application.VLookup(Range(Cells(2, Found.Column), Cells(LR, Found.Column)),
>> Range("RANGE"), 4, False)
>> End Sub
>>
>> Thanks
>> Mahesh
>>   On Sun, Jul 17, 2011 at 12:02 PM, Prathima R wrote:
>>
>>> hi experts,
>>>
>>> Please help me in this concern.
>>>
>>> i need to perform vlookup function using VBA
>>>
>>> i have attached sample work book for referance
>>>
>>> From the attached workbook i need update summary sheet using the company
>>> code as base  from SBU Mapping sheet.
>>>
>>> i need to insert one column after Data1 , Data2, Data3 Columns and pull
>>> the SBU,DIVISION, REGION
>>>
>>> Please provide the vba code code to find the data1 column and then insert
>>> one column after it.then i need to pull data using vlookup.
>>>
>>> like wise i will be updating for all rest.
>>>
>>> Thanks,
>>> Prathima.
>>>
>>> --
>>>
>>> --
>>> 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
>

-- 
--
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$$ Urgent Help needed-Dashboards

[Aindril De]

Hi Avinash,

Try this:

http://www.freeexceldashboards.com/exceldashboardtemplates.html

Cheers,
Andy

On Thu, Jul 21, 2011 at 4:49 PM, Avinash Patil wrote:

> Hi Masters,
>
> can anybody please forward me excel dashboard designs i need dashboard
> designs with all automations and vba work like drop downs , charts, graphs
> "a dashboard with full graphical and customization interface"
>
> i'll be realy greatfull to you guys please forward me the designs,
>
> Regards,
>
> Avinash
>
> --
>
> --
> 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
>



-- 

Warm Regards,
Aindril De
Unified Learning Pvt Ltd.
Ph: 9811300157

-- 
--
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$$ Extracting data from Website

[ashish koul]

can you send the direct  link

On Thu, Jul 21, 2011 at 4:34 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:

> Hi,
>
> How to extract data from websites for ex: Yahoo News Columns. could anyone
> provide VBA code for this. Thanks!
>
> --
>
> --
> 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*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


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$$ Urgent Help needed-Dashboards

[ashish koul]

open this link
http://chandoo.org/wp/excel-dashboards/

On Thu, Jul 21, 2011 at 4:49 PM, Avinash Patil wrote:

> Hi Masters,
>
> can anybody please forward me excel dashboard designs i need dashboard
> designs with all automations and vba work like drop downs , charts, graphs
> "a dashboard with full graphical and customization interface"
>
> i'll be realy greatfull to you guys please forward me the designs,
>
> Regards,
>
> Avinash
>
> --
>
> --
> 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*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


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$$ Urgent Help needed-Dashboards

[Avinash Patil]

Hi Masters,

can anybody please forward me excel dashboard designs i need dashboard
designs with all automations and vba work like drop downs , charts, graphs
"a dashboard with full graphical and customization interface"

i'll be realy greatfull to you guys please forward me the designs,

Regards,

Avinash

-- 
--
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$$ Workbooks Consolidation Macro

[Anish Shrivastava]

Harish,

PLease ignore the earlier attachment as I forgot to add *DUPLICATE CHECK* in
that macro.

Use this attachment.

On Thu, Jul 21, 2011 at 5:09 PM, Anish Shrivastava wrote:

> Hi Harsih,
>
> Since you didnt reply about column headers I assumed that it's the same for
> every file on share drive.
>
> Please see the attached file with macro.
>
> You must populate the file path in Sheet2-A1.
>
> Do let me know if it works fine for you.
> Cheers!!
> Anish
>   On Thu, Jul 21, 2011 at 4:00 PM, Anish Shrivastava 
> wrote:
>
>> Harish,
>>
>> I forgot to ask you one thing.
>> The column headers in the file you attached will be constant for all the
>> 30-35 files which are there on your sharedrive, right?
>> Cheers,
>> Anish
>>   On Wed, Jul 20, 2011 at 11:06 PM, Harish Sharma <
>> harishsharma...@gmail.com> wrote:
>>
>>> Hi Anish,
>>>
>>> Please find attached the sample file with one row filled.
>>> And Column "C" & Column "H" concatenate should give us unique value so if
>>> this is repeated then we need to have below requested feature.
>>>
>>> Hope this would be more clear now.
>>>
>>> Thanks
>>> Harish
>>>
>>>
>>>
>>> On 20 July 2011 21:32, Anish Shrivastava  wrote:
>>>
 One sample sheet would be helpful to us to see the data structure.

 However, for this "*Also identifiy if there is any row duplicated and
 highlight them and paste them into another sheet" * There must be any
 particular data field which has to be checked against others in order to
 find duplicates.

 Macro for consolidation is not a big deal.


 On Wed, Jul 20, 2011 at 7:35 PM, Harish Sharma <
 harishsharma...@gmail.com> wrote:

> Hi,
>
> I had a macro file which was able to consolidate small files but now I
> have a requirement to consolidate 30 workbooks saved in a share drive and
> this data may even cross 66000 row after consolidation. Can someone help 
> me
> in creating a macro which picks all the file from shared folder and
> consolidates the one specific worksheet in all the workbook.
>
> This macro should also be capable of deleting any blank row in any of
> these 30 workbooks so that we donot miss any data if someone by error has
> missed a couple of row and entered the data in couple of row below.
>
> 30 workbooks in sharedrive
> one specific worksheet from all of these named as "Tracker"
> Should cover all the blanks and delete them so that no data missed
> Also identifiy if there is any row duplicated and highlight them and
> paste them into another sheet
> If data crosses excel 2003 limit of row it should move to next
> worksheet.
>
> Hope to get a solution from excel experts.
>
> --
> Kind Regards,
> Harish Sharma
>
> --
>
> --
> 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

>>>
>>>
>>>
>>> --
>>> Kind Regards,
>>> Harish Sharma
>>>
>>> --
>>>
>>> --
>>> 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
>>>
>>> <><><><><><><><><><><><><><><><><><

Re: $$Excel-Macros$$ Workbooks Consolidation Macro

[Anish Shrivastava]

Hi Harsih,

Since you didnt reply about column headers I assumed that it's the same for
every file on share drive.

Please see the attached file with macro.

You must populate the file path in Sheet2-A1.

Do let me know if it works fine for you.
Cheers!!
Anish
On Thu, Jul 21, 2011 at 4:00 PM, Anish Shrivastava wrote:

> Harish,
>
> I forgot to ask you one thing.
> The column headers in the file you attached will be constant for all the
> 30-35 files which are there on your sharedrive, right?
> Cheers,
> Anish
>   On Wed, Jul 20, 2011 at 11:06 PM, Harish Sharma <
> harishsharma...@gmail.com> wrote:
>
>> Hi Anish,
>>
>> Please find attached the sample file with one row filled.
>> And Column "C" & Column "H" concatenate should give us unique value so if
>> this is repeated then we need to have below requested feature.
>>
>> Hope this would be more clear now.
>>
>> Thanks
>> Harish
>>
>>
>>
>> On 20 July 2011 21:32, Anish Shrivastava  wrote:
>>
>>> One sample sheet would be helpful to us to see the data structure.
>>>
>>> However, for this "*Also identifiy if there is any row duplicated and
>>> highlight them and paste them into another sheet" * There must be any
>>> particular data field which has to be checked against others in order to
>>> find duplicates.
>>>
>>> Macro for consolidation is not a big deal.
>>>
>>>
>>> On Wed, Jul 20, 2011 at 7:35 PM, Harish Sharma <
>>> harishsharma...@gmail.com> wrote:
>>>
 Hi,

 I had a macro file which was able to consolidate small files but now I
 have a requirement to consolidate 30 workbooks saved in a share drive and
 this data may even cross 66000 row after consolidation. Can someone help me
 in creating a macro which picks all the file from shared folder and
 consolidates the one specific worksheet in all the workbook.

 This macro should also be capable of deleting any blank row in any of
 these 30 workbooks so that we donot miss any data if someone by error has
 missed a couple of row and entered the data in couple of row below.

 30 workbooks in sharedrive
 one specific worksheet from all of these named as "Tracker"
 Should cover all the blanks and delete them so that no data missed
 Also identifiy if there is any row duplicated and highlight them and
 paste them into another sheet
 If data crosses excel 2003 limit of row it should move to next
 worksheet.

 Hope to get a solution from excel experts.

 --
 Kind Regards,
 Harish Sharma

 --

 --
 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
>>>
>>
>>
>>
>> --
>> Kind Regards,
>> Harish Sharma
>>
>> --
>>
>> --
>> 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 Linked

$$Excel-Macros$$ Extracting data from Website

[Chandra Shekar]

Hi,

How to extract data from websites for ex: Yahoo News Columns. could anyone
provide VBA code for this. Thanks!

-- 
--
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$$ Change e-mail settings

[Venkatesan c]

Hi,

Just Go to Below link and sign in your Gmail account..and set as a

https://groups.google.com/group/excel-macros/subscribe?hl=en

and go to Edit my membership --->Email *(Approximately 15 emails per day)*Send
each message to me as it arrives

and save it...

-- 
*Best Regards,*
*Venkat*
*
*

On Wed, Jul 20, 2011 at 10:46 PM, Dan Little wrote:

> How do I edit my preferences such that I do not receive a message everytime
> someone posts a discussion with $$Excel-Macros$$ tagged?
>
> H3lue
>
> --
>
> --
> 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$$ Workbooks Consolidation Macro

[Anish Shrivastava]

Harish,

I forgot to ask you one thing.
The column headers in the file you attached will be constant for all the
30-35 files which are there on your sharedrive, right?
Cheers,
Anish
On Wed, Jul 20, 2011 at 11:06 PM, Harish Sharma
wrote:

> Hi Anish,
>
> Please find attached the sample file with one row filled.
> And Column "C" & Column "H" concatenate should give us unique value so if
> this is repeated then we need to have below requested feature.
>
> Hope this would be more clear now.
>
> Thanks
> Harish
>
>
>
> On 20 July 2011 21:32, Anish Shrivastava  wrote:
>
>> One sample sheet would be helpful to us to see the data structure.
>>
>> However, for this "*Also identifiy if there is any row duplicated and
>> highlight them and paste them into another sheet" * There must be any
>> particular data field which has to be checked against others in order to
>> find duplicates.
>>
>> Macro for consolidation is not a big deal.
>>
>>
>> On Wed, Jul 20, 2011 at 7:35 PM, Harish Sharma > > wrote:
>>
>>> Hi,
>>>
>>> I had a macro file which was able to consolidate small files but now I
>>> have a requirement to consolidate 30 workbooks saved in a share drive and
>>> this data may even cross 66000 row after consolidation. Can someone help me
>>> in creating a macro which picks all the file from shared folder and
>>> consolidates the one specific worksheet in all the workbook.
>>>
>>> This macro should also be capable of deleting any blank row in any of
>>> these 30 workbooks so that we donot miss any data if someone by error has
>>> missed a couple of row and entered the data in couple of row below.
>>>
>>> 30 workbooks in sharedrive
>>> one specific worksheet from all of these named as "Tracker"
>>> Should cover all the blanks and delete them so that no data missed
>>> Also identifiy if there is any row duplicated and highlight them and
>>> paste them into another sheet
>>> If data crosses excel 2003 limit of row it should move to next worksheet.
>>>
>>> Hope to get a solution from excel experts.
>>>
>>> --
>>> Kind Regards,
>>> Harish Sharma
>>>
>>> --
>>>
>>> --
>>> 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
>>
>
>
>
> --
> Kind Regards,
> Harish Sharma
>
> --
>
> --
> 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$$ Workbooks Consolidation Macro

[Anish Shrivastava]

Sure Harish :) ..

You will have it soon..

On Thu, Jul 21, 2011 at 3:45 PM, Harish Sharma wrote:

> Can someone help this is really urgent.
>
> Thanks
> Harish
>
>
> On 20 July 2011 23:06, Harish Sharma  wrote:
>
>> Hi Anish,
>>
>> Please find attached the sample file with one row filled.
>> And Column "C" & Column "H" concatenate should give us unique value so if
>> this is repeated then we need to have below requested feature.
>>
>> Hope this would be more clear now.
>>
>> Thanks
>> Harish
>>
>>
>>
>> On 20 July 2011 21:32, Anish Shrivastava  wrote:
>>
>>> One sample sheet would be helpful to us to see the data structure.
>>>
>>> However, for this "*Also identifiy if there is any row duplicated and
>>> highlight them and paste them into another sheet" * There must be any
>>> particular data field which has to be checked against others in order to
>>> find duplicates.
>>>
>>> Macro for consolidation is not a big deal.
>>>
>>>
>>> On Wed, Jul 20, 2011 at 7:35 PM, Harish Sharma <
>>> harishsharma...@gmail.com> wrote:
>>>
 Hi,

 I had a macro file which was able to consolidate small files but now I
 have a requirement to consolidate 30 workbooks saved in a share drive and
 this data may even cross 66000 row after consolidation. Can someone help me
 in creating a macro which picks all the file from shared folder and
 consolidates the one specific worksheet in all the workbook.

 This macro should also be capable of deleting any blank row in any of
 these 30 workbooks so that we donot miss any data if someone by error has
 missed a couple of row and entered the data in couple of row below.

 30 workbooks in sharedrive
 one specific worksheet from all of these named as "Tracker"
 Should cover all the blanks and delete them so that no data missed
 Also identifiy if there is any row duplicated and highlight them and
 paste them into another sheet
 If data crosses excel 2003 limit of row it should move to next
 worksheet.

 Hope to get a solution from excel experts.

 --
 Kind Regards,
 Harish Sharma

 --

 --
 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
>>>
>>
>>
>>
>> --
>> Kind Regards,
>> Harish Sharma
>>
>
>
>
> --
> Kind Regards,
> Harish Sharma
>
> --
>
> --
> 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 facebo

Re: $$Excel-Macros$$ Workbooks Consolidation Macro

[Harish Sharma]

Can someone help this is really urgent.

Thanks
Harish

On 20 July 2011 23:06, Harish Sharma  wrote:

> Hi Anish,
>
> Please find attached the sample file with one row filled.
> And Column "C" & Column "H" concatenate should give us unique value so if
> this is repeated then we need to have below requested feature.
>
> Hope this would be more clear now.
>
> Thanks
> Harish
>
>
>
> On 20 July 2011 21:32, Anish Shrivastava  wrote:
>
>> One sample sheet would be helpful to us to see the data structure.
>>
>> However, for this "*Also identifiy if there is any row duplicated and
>> highlight them and paste them into another sheet" * There must be any
>> particular data field which has to be checked against others in order to
>> find duplicates.
>>
>> Macro for consolidation is not a big deal.
>>
>>
>> On Wed, Jul 20, 2011 at 7:35 PM, Harish Sharma > > wrote:
>>
>>> Hi,
>>>
>>> I had a macro file which was able to consolidate small files but now I
>>> have a requirement to consolidate 30 workbooks saved in a share drive and
>>> this data may even cross 66000 row after consolidation. Can someone help me
>>> in creating a macro which picks all the file from shared folder and
>>> consolidates the one specific worksheet in all the workbook.
>>>
>>> This macro should also be capable of deleting any blank row in any of
>>> these 30 workbooks so that we donot miss any data if someone by error has
>>> missed a couple of row and entered the data in couple of row below.
>>>
>>> 30 workbooks in sharedrive
>>> one specific worksheet from all of these named as "Tracker"
>>> Should cover all the blanks and delete them so that no data missed
>>> Also identifiy if there is any row duplicated and highlight them and
>>> paste them into another sheet
>>> If data crosses excel 2003 limit of row it should move to next worksheet.
>>>
>>> Hope to get a solution from excel experts.
>>>
>>> --
>>> Kind Regards,
>>> Harish Sharma
>>>
>>> --
>>>
>>> --
>>> 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
>>
>
>
>
> --
> Kind Regards,
> Harish Sharma
>



-- 
Kind Regards,
Harish Sharma

-- 
--
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$$ adding adjacent (contagious) cells only

[Azeema]

Thanks a lot everyone for your quick help. This is one of the best
forums for Advance Excel.

Azeema

On Jul 20, 2:42 pm, Haseeb Avarakkan 
wrote:
> Hello Azeema,
>
> Use this formula, say in V2 & copy down.
>
> =COUNTIFS(A2:S2,"Yes",B2:T2,"<>Yes") This will only work XL2007 or later.
>
> If you want to work with XL 2003 or prior use SUMPRODUCT
>
> =SUMPRODUCT(--(A2:S2="Yes"),--(B2:T2<>"Yes"))
>
> See the attached
>
> HTH
> Haseeb
>
>  UnpaidWork with COUNTIFS.xlsx
> 13KViewDownload

-- 
--
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$$ Macro needed for ms access database

[§»VIPER«§]

Hi



1. I have created a database with some custom menus. In that I am having a
menu called "Manage" and I require a code which should hide the particular
menu for particular users.

2. I have created a form for startup and I don’t want allow the users to
close the form using the Cnrl+W. It should be always open till the database
is open.  I have removed the form control property close box from the form
but the users are still able to close the form using Cntrl+W button.



Can anyone give me the solution?

-- 
*Great day,*
*viper
*

-- 
--
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$$ Struggling with ADO...!! connecting to SQL Server

[Rajan_Verma]

Try this

 

Dim cn as ADODB.Connection

Set cn = New ADODB.Connection

With cn

 .Provider = "Microsoft.Jet.OLEDB.4.0"

 .ConnectionString = "Data Source=C:\MyFolder\MyWorkbook.xls;" & _

"Extended Properties=Excel 8.0;"

 .Open

 

End With

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Markkim
Sent: Thursday, July 21, 2011 10:44 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Struggling with ADO...!! connecting to SQL Server

 

Hi all 

 

I'm trying to learn how to connect to SQL Server and extract information
from Excel. 

 

The code below is one I got it from one of site and modified a bit (After
reading a book about ADO)

 

When I run the code, I get the following error 

 

Complie error:

User-defined type not defined 

 

Then it highlights the following line  

 

Dim objConn As ADODB.Connection  

 

 

I am confused.. I read a book again and again but I'm not sure what I am
missing..   Do I need to create a class or something? 

 

Can you help me out please? I'm trying to get the basic structure working
first then continue to study from here..

 

Thanks a lot in advance 

 

 

 

 

Sub Stats2()

ActiveSheet.Range("A1").Select

Dim objConn As ADODB.Connection
Dim rsData As ADODB.Recordset
Dim strSQL As String

szconnect = "Provider=SQLOLEDB;" & _
"Data Source=sgjapsql02;" & _
"Initial catalog = RECProcess;" & _
"Intergrated Security=SSPI"


''#Create the Connection and Recordset objects.
Set objConn = New ADODB.Connection
Set rsData = New ADODB.Recordset

On Error GoTo errHandler

''#Open the Connection and execute the stored procedure
objConn.Open szconnect
strSQL = "select * from employee"
objConn.CommandTimeout = 0
Set rsData = objConn.Execute(strSQL)

For iCols = 0 To rsData.Fields.Count - 1
ActiveSheet.Range("A3").Select
ActiveSheet.Cells(ActiveCell.Row, ActiveCell.Column + iCols).Value =
rsData.Fields(iCols).Name
ActiveSheet.Cells.Font.Name = "Arial"
ActiveSheet.Cells.Font.Size = 8
ActiveSheet.Cells.EntireColumn.AutoFit
Next

ActiveSheet.Range(ActiveSheet.Cells(ActiveCell.Row, ActiveCell.Column),
ActiveSheet.Cells(ActiveCell.Row, ActiveCell.Column +
rsData.Fields.Count)).Font.Bold = True
j = 2

If Not rsData.EOF Then
''#Dump the contents of the recordset onto the worksheet
On Error GoTo errHandler
ActiveSheet.Cells(ActiveCell.Row + 1, ActiveCell.Column).CopyFromRecordset
rsData
If Not rsData.EOF Then
MsgBox "Data set too large for a worksheet!"

End If
rsData.Close
End If

Unload frmSQLQueryADO
Exit Sub

errHandler:
MsgBox Err.Description, vbCritical, "Error No: " & Err.Number
''#Unload frmSQLQueryADO
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

-- 
--
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$$ Data Input Sheet - Deleting Entries - all added data deletes

[Cab Boose]

Hi Ashish

Thanks for that.  How do I toggle the 'TabOrder' on ?  At the moment the tab
order is not working.

Thanks

Charlie

On Thu, Jul 21, 2011 at 7:08 PM, ashish koul  wrote:

> try this
>
>
> On Thu, Jul 21, 2011 at 11:36 AM, Cab Boose  wrote:
>
>> Hi Rajan
>>
>>
>>
>> I have attached copy of the sheet involved.
>>
>>
>> Let me know what you think.
>>
>> Thanks
>>
>> Charlie
>>
>>   On Wed, Jul 20, 2011 at 9:19 PM, Rajan_Verma 
>> wrote:
>>
>>>  *Would you please attached Workbook.*
>>>
>>> * *
>>>
>>> *From:* excel-macros@googlegroups.com [mailto:
>>> excel-macros@googlegroups.com] *On Behalf Of *Cab Boose
>>> *Sent:* Wednesday, July 20, 2011 2:10 PM
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* $$Excel-Macros$$ Data Input Sheet - Deleting Entries - all
>>> added data deletes
>>>
>>> ** **
>>>
>>> Hi everyone
>>>
>>>  
>>>
>>> Excel 2000 Win7
>>>
>>>  
>>>
>>> I am using code below to enter data onto a sheet.  The sheet works well
>>> in entering data, but when you go back to an entry above and delete the
>>> current data and put in the correct data, on the delete key it deletes all
>>> data entered and user has to start over again.
>>>
>>>  
>>>
>>> How to stop all data entered being deleted ?:
>>>
>>>  
>>>
>>> Thanks
>>>
>>>  
>>>
>>> Charlie
>>>
>>>  
>>>
>>>  
>>>
>>> **
>>>
>>>  
>>>
>>> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
>>> 'Establishes tab order for data entry. Hit Enter or Tab keys to jump to
>>> the next cell.
>>>
>>> Dim TabOrder As Variant, X As Variant
>>> Dim addr As String
>>> Dim rg As Range, targ As Range
>>> If TabOrderFlag = True Then Exit Sub
>>>
>>> TabOrder = Array("h8", "h9", "h10", "h11", "h13", "l11", "l12", "h17",
>>> "k17", "h18", "k18", "k21", "k22", "n26", "n27", "n31", _
>>> "k37", "e82", "f82", "h82", "j82", "e83", "f83", "h83", "j83", "e84",
>>> "f84", "h84", "j84", "e85", "f85", "h85", _
>>> "j85", "e86", "f86", "h86", "j86", "e87", "f87", "h87", "j87", "e88",
>>> "f88", "h88", "j88", "e89", "f89", _
>>> "h89", "j89")
>>>
>>> 'List your cell addresses in desired tab order here
>>> For Each X In TabOrder
>>> If rg Is Nothing Then
>>> Set rg = Range(X)
>>> Else
>>> Set rg = Union(rg, Range(X))
>>> End If
>>> Next
>>>
>>> Set targ = Intersect(rg, Target)
>>> rg.Select
>>> If targ Is Nothing Then
>>> addr = Target.Cells(1, 1).Address(ColumnAbsolute:=False,
>>> RowAbsolute:=False)
>>> X = Application.Match(addr, TabOrder, 0)
>>> If IsError(X) Then Range(TabOrder(LBound(TabOrder))).Activate
>>> Else
>>> targ.Activate
>>> End If
>>>
>>> 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
>>>
>>> --
>>>
>>> --
>>> 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
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> http://akoul.posterous.com/
>  *akoul*.wordpress.com 

Re: $$Excel-Macros$$ I'm in budget vlookup hell. Please help

[Adam Hamilton]

Any chance to think about it?

Sent from my iPhone

On Jul 20, 2011, at 1:06 AM, Adam Hamilton  wrote:

> You're a godsend!
> 
> On Wed, Jul 20, 2011 at 12:57 AM, Anish Shrivastava  
> wrote:
>> Tracking sheet.. I see.. I will have a look and try my best to give one
>> dummy dashboard by tomorrow.
>> 
>> On Wed, Jul 20, 2011 at 1:16 PM, Adam Hamilton 
>> wrote:
>>> 
>>> However, I get your point, the data is not raw if I am adding a sum of
>>> spend based on resource allocation and budgetary spend.
>>> 
>>> The 'time tracking' sheet is supposed to be the 'raw' data, but since
>>> it has been altered, I guess I have none..
>>> 
>>> On Wed, Jul 20, 2011 at 12:44 AM, Adam Hamilton 
>>> wrote:
 The 'time tracking' sheet is where all of the data are pulled to
 populate the erroneous amount of fluff that you see in my xls
 
 On Wed, Jul 20, 2011 at 12:35 AM, Anish Shrivastava
  wrote:
> Hi Adam,
> 
> Great thing.
> I would request you again to send me only those sheets which you think
> are
> raw data.
> 
> Your workbook contains many sheets (includin pivot sheets) which makes
> me
> unsure that which sheet should I consider as a raw data sheet for
> dashboard.
> 
> As you said, your management wants to select a resourse from a list of
> resources in order to see their expenses and other details then I
> assume
> there must be a raw data sheet in database format (simply rows and
> columns).
> 
> to protect the confidentiality, you can change the values on your
> originial
> sheet. Replace it with some example values. Change the names, mail
> address
> and amount.
> thanks,
> Anish
> On Wed, Jul 20, 2011 at 12:49 PM, Adam Hamilton
> 
> wrote:
>> 
>> Thanks so much.  A dummy dashboard would be great.  Once I can grasp
>> the concept, I know it shouldn't be any problem expanding on it at a
>> later time.  My idea is for executive mgmt to be able to select a
>> resource and see everything pertaining to thier spend and billable
>> rates……..
>> 
>> To answer your question, I was using charts to show my directors my
>> bucket spend.  I will be able to omit everything if I can find a way
>> to extract everything from the raw data, instead of hundreds of
>> vlookups in hidden tabls…..all of the other bucket breakdowns once I
>> can get this to make sense from the raw data.
>> 
>> Attached is a monthly spend ticket as submitted per executive review.
>> 
>> On Tue, Jul 19, 2011 at 11:44 PM, Anish Shrivastava
>> 
>> wrote:
>>> Hi Adam,
>>> 
>>> Looking at your workbook, it seems that it's a complete dashboard
>>> project to
>>> be completed and in these cases Sample data wouldn't do the perfect
>>> job
>>> (However we can create one dummy dashboard).
>>> 
>>> I understand that you want it to be interactive to the user creating
>>> homepage and navigation with charts and other analysis.
>>> 
>>> I have one question for you, why are you using images(charts) on the
>>> sheet.
>>> where as you can do it with excel charts itself.
>>> 
>>> Your project is a big one and if we have to do it, it might take
>>> some
>>> time
>>> to go through all the sheets and understand the data structure to
>>> create
>>> an
>>> interactive data base.
>>> 
>>> You will have to have patience for it. I understand that because of
>>> data
>>> confidentiality you cant share the complete data but in order to
>>> complete
>>> this dashboard or for giving a dashboard skeleton, we would expect
>>> one
>>> cleansed workbook only with the necessary sheets.
>>> 
>>> Hope you understood what I am trying to say.
>>> 
>>> Thanks,
>>> Anish
>>> 
>>> 
>>> On Wed, Jul 20, 2011 at 12:04 PM, Adam Hamilton
>>> 
>>> wrote:
 
 Hi, Guys,
 
 Thanks.  You're recieving this error b/c I ommitted the resources
 names for confidentiality.  I'm looking for a macro, or complex
 formulae that will allow the dashboard to be both interactive to
 the
 user, as well as auto populate data, charts, stats, etc.
 
 On Tue, Jul 19, 2011 at 6:10 AM, Adam Hamilton
 
 wrote:
> Hi, guys,
> 
> So, I’ve created this complex budget workbook for the department
> I
> manage.  Everything is automated, however, now that I want to
> create
> a
> dashboard with the data, all of my syntax are failing!!!
> 
> I’ve spent endless hours on this, can someone PLEASE guide me in
> the
> right direction?  As you can see from the sample db, the data I
> want
> to capture are all available in the Raw Data file.  But after
> weeks
> of

Re: $$Excel-Macros$$ Struggling with ADO...!! connecting to SQL Server

[ashish koul]

http://support.microsoft.com/kb/306125

http://support.microsoft.com/kb/321686

http://www.ozgrid.com/forum/showthread.php?t=83016&page=1


On Thu, Jul 21, 2011 at 10:44 AM, Markkim  wrote:

> Hi all
>
> I'm trying to learn how to connect to SQL Server and extract information
> from Excel.
>
> The code below is one I got it from one of site and modified a bit (After
> reading a book about ADO)
>
> When I run the code, I get the following error
>
> Complie error:
> User-defined type not defined
>
> Then it highlights the following line
>
> Dim objConn As ADODB.Connection
>
>
> I am confused.. I read a book again and again but I'm not sure what I am
> missing..   Do I need to create a class or something?
>
> Can you help me out please? I'm trying to get the basic structure working
> first then continue to study from here..
>
> Thanks a lot in advance
>
>
>
>
> Sub Stats2()
>
> ActiveSheet.Range("A1").Select
>
> Dim objConn As ADODB.Connection
> Dim rsData As ADODB.Recordset
> Dim strSQL As String
>
> szconnect = "Provider=SQLOLEDB;" & _
> "Data Source=sgjapsql02;" & _
> "Initial catalog = RECProcess;" & _
> "Intergrated Security=SSPI"
>
>
> ''#Create the Connection and Recordset objects.
> Set objConn = New ADODB.Connection
> Set rsData = New ADODB.Recordset
>
> On Error GoTo errHandler
>
> ''#Open the Connection and execute the stored procedure
> objConn.Open szconnect
> strSQL = "select * from employee"
> objConn.CommandTimeout = 0
> Set rsData = objConn.Execute(strSQL)
>
> For iCols = 0 To rsData.Fields.Count - 1
> ActiveSheet.Range("A3").Select
> ActiveSheet.Cells(ActiveCell.Row, ActiveCell.Column + iCols).Value =
> rsData.Fields(iCols).Name
> ActiveSheet.Cells.Font.Name  =
> "Arial"
> ActiveSheet.Cells.Font.Size = 8
> ActiveSheet.Cells.EntireColumn.AutoFit
> Next
>
> ActiveSheet.Range(ActiveSheet.Cells(ActiveCell.Row, ActiveCell.Column),
> ActiveSheet.Cells(ActiveCell.Row, ActiveCell.Column +
> rsData.Fields.Count)).Font.Bold = True
> j = 2
>
> If Not rsData.EOF Then
> ''#Dump the contents of the recordset onto the worksheet
> On Error GoTo errHandler
> ActiveSheet.Cells(ActiveCell.Row + 1, ActiveCell.Column).CopyFromRecordset
> rsData
> If Not rsData.EOF Then
> MsgBox "Data set too large for a worksheet!"
>
> End If
> rsData.Close
> End If
>
> Unload frmSQLQueryADO
> Exit Sub
>
> errHandler:
> MsgBox Err.Description, vbCritical, "Error No: " & Err.Number
> ''#Unload frmSQLQueryADO
> 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
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


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