Re: $$Excel-Macros$$ How can convert

2011-10-23 Thread ashish koul
://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *http

$$Excel-Macros$$ Download Word Macro Tutorial

2011-10-23 Thread ashish koul
http://www.susandoreydesigns.com/software/WordVBATechniques.pdf -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- -- Some important links for excel

$$Excel-Macros$$ Download Access Tutorial

2011-10-23 Thread ashish koul
http://www.susandoreydesigns.com/software/AccessTechniques.pdf -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- -- Some important links for excel

Re: $$Excel-Macros$$ Help in Learn advanced excel in noida

2011-10-23 Thread ashish koul
@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment

Re: $$Excel-Macros$$ Need help resolving runtime errors and crashes (or different approach)

2011-10-21 Thread ashish koul
profoundly grateful for the aid and the neat macro that you have provided. I will have to mark this problem Solved Warm regards, -Sean- On Oct 20, 10:19 pm, ashish koul koul.ash...@gmail.com wrote: hi Sean try this macro. select the folder which is having all the excel files. On Fri

$$Excel-Macros$$ ass links to blog

2011-10-21 Thread ashish koul
http://www.excelvbamacros.com/2011/10/sort-data-on-basis-of-font-color.html -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- -- Some important

Re: $$Excel-Macros$$ ass links to blog

2011-10-21 Thread ashish koul
Sorry Guys By mistake i send this link on this group On Fri, Oct 21, 2011 at 1:19 PM, ashish koul koul.ash...@gmail.com wrote: http://www.excelvbamacros.com/2011/10/sort-data-on-basis-of-font-color.html -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing

$$Excel-Macros$$ Sorry Guys By mistake i send this link on this group

2011-10-21 Thread ashish koul
On Fri, Oct 21, 2011 at 1:38 PM, ashish koul koul.ash...@gmail.com wrote: Sorry Guys By mistake i send this link on this group On Fri, Oct 21, 2011 at 1:19 PM, ashish koul koul.ash...@gmail.comwrote: http://www.excelvbamacros.com/2011/10/sort-data-on-basis-of-font-color.html

Re: $$Excel-Macros$$ Looking Up Words When You Only Have A Few Letters

2011-10-21 Thread ashish koul
Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- -- Some

Re: $$Excel-Macros$$ Need help resolving runtime errors and crashes (or different approach)

2011-10-20 Thread ashish koul
at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about

Re: $$Excel-Macros$$ querry ncg

2011-10-19 Thread ashish koul
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

Re: $$Excel-Macros$$ Color count in a row

2011-10-19 Thread ashish koul
://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *http

Re: $$Excel-Macros$$ conditional formatting- more than 3

2011-10-17 Thread ashish koul
To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment

Re: $$Excel-Macros$$ Formula needed to extract the text from string

2011-10-15 Thread ashish koul
on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- -- Some important links

Re: $$Excel-Macros$$ Dynamic chart range

2011-10-15 Thread ashish koul
at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *http

Re: $$Excel-Macros$$ Help

2011-10-15 Thread ashish koul
Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment

Re: $$Excel-Macros$$ Pivot Help

2011-10-14 Thread ashish koul
our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- -- Some

$$Excel-Macros$$ job

2011-10-11 Thread ashish koul
CTC:- Exp CTC:- Notice Period:- Reason for Change:- Please send me your updapted resume ASAP Thanks Regards Akankasha Talwar Planman HR akankasha.tal...@planmanconsulting.com 01130268207 -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about

$$Excel-Macros$$ job

2011-10-11 Thread ashish koul
knowledge in an MS-Excel If you are interested please send me your updated profile. Total Experience: Relevant Experience: CTC: ECTC NP Reason for Job change. Thanks and Regards Malathi -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment

Re: $$Excel-Macros$$ Querry ncg

2011-10-11 Thread ashish koul
, ashish koul koul.ash...@gmail.com wrote: check the attachment On Sat, Oct 8, 2011 at 3:07 PM, Nemi Gandhi nemigan...@gmail.com wrote: Plaease provide solution. -- Nemi Gandhi 98204 92963

Re: $$Excel-Macros$$ Querry ncg

2011-10-08 Thread ashish koul
://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about

Re: $$Excel-Macros$$ PPT

2011-10-06 Thread ashish koul
, Oct 4, 2011 at 4:43 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Thanks Ashish its working fine :) On Tue, Oct 4, 2011 at 9:36 AM, ashish koul koul.ash...@gmail.comwrote: try something like this Sub create_ppts() Dim slidecount As Integer Dim slide As slide, PPSlide

Re: $$Excel-Macros$$ PPT

2011-10-04 Thread ashish koul
link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us

$$Excel-Macros$$ job

2011-10-04 Thread ashish koul
-partners.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links

Re: $$Excel-Macros$$ New Microsoft MVP Mr. Ayush Jain (2nd Times)..

2011-10-02 Thread ashish koul
://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER

Re: $$Excel-Macros$$ Extract (%) Numbers from the text

2011-10-01 Thread ashish koul
://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *http

Re: $$Excel-Macros$$ Union to transfor a non-contiguous to a contiguous range In VBA

2011-09-28 Thread ashish koul
to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment

Re: $$Excel-Macros$$ Hidden Columns and Save Location

2011-09-28 Thread ashish koul
@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment

Re: $$Excel-Macros$$ examine three columns return the one that matches criteria

2011-09-27 Thread ashish koul
://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *http

Re: $$Excel-Macros$$ help

2011-09-24 Thread ashish koul
://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about

Re: $$Excel-Macros$$

2011-09-24 Thread ashish koul
at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *http

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

2011-09-24 Thread ashish koul
email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment

Re: $$Excel-Macros$$ Using VBA to switch between calculated fields

2011-09-21 Thread ashish koul
/discussexcel -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks

Re: $$Excel-Macros$$ Template to modify workbooks

2011-09-20 Thread ashish koul
at posting messages and I can not see how to attach my workbook. On Sep 19, 9:21 pm, ashish koul koul.ash...@gmail.com wrote: Hi Harry 1 are all the workbooks in xlsm or xls format is it possible for u to share a sample workbook On Tue, Sep 20, 2011 at 1:28 AM, HarryP Knuckles kent.bouc

Re: $$Excel-Macros$$ List of text files with data to Excel.

2011-09-19 Thread ashish koul
below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- -- Some important links for excel users: 1

Re: $$Excel-Macros$$ List of text files with data to Excel.

2011-09-19 Thread ashish koul
= Cells(j, 7).Value Cells(j, 8).Value = Left(Right(s, Len(s) - InStr(s, ()), Len(Right(s, Len(s) - InStr(s, ())) - 1) Cells(j, 7).Value = Left(s, InStr(s, () - 1) Exit Do End If End If Loop objFile.Close Next j Set objFSO = Nothing End Sub Regards Ashish koul 2011/9/19 johnofeasttex j...@demco

Re: $$Excel-Macros$$ Template to modify workbooks

2011-09-19 Thread ashish koul
* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com

Re: $$Excel-Macros$$ Excel chart challenge

2011-09-17 Thread ashish koul
://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment

Re: $$Excel-Macros$$ Navigate worksheet from Dropdown list

2011-09-16 Thread ashish koul
email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment

$$Excel-Macros$$ Job

2011-09-12 Thread ashish koul
* [image: cid:image002.jpg@01CB17B2.08CC85F0] P Please consider responsibility towards our environment before printing this e-mail. THINK BEFORE YOU PRINT. ** ** -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ P Before printing, think about

Re: $$Excel-Macros$$ Need help with advance filter

2011-09-10 Thread ashish koul
://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

Re: $$Excel-Macros$$ Manipulating data in rows into Columns

2011-09-09 Thread ashish koul
://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

Re: $$Excel-Macros$$ vba help

2011-09-09 Thread ashish koul
/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

Re: $$Excel-Macros$$ Macro to Copy the sheets from One file to Multiple Files

2011-09-07 Thread ashish koul
/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

Re: $$Excel-Macros$$ PDF to Excel

2011-09-07 Thread ashish koul
@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http

Re: $$Excel-Macros$$ PDF to Excel

2011-09-06 Thread ashish koul
below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before

Re: $$Excel-Macros$$ processor to slow for proper sequential processing of vba code ?

2011-09-06 Thread ashish koul
-macros@googlegroups.com ** Like our page on facebook , Just follow below link http://www.facebook.com/**discussexcelhttp://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http

Re: $$Excel-Macros$$ pie chart -how to remove in chart

2011-09-06 Thread ashish koul
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

Re: $$Excel-Macros$$ pie chart -how to remove in chart

2011-09-04 Thread ashish koul
://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

Re: $$Excel-Macros$$ extracting data from a datasheet

2011-09-01 Thread ashish koul
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.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My

Re: $$Excel-Macros$$ Need macro to split the files

2011-08-31 Thread ashish koul
is not populated in the Summary details sheet. 2. Could you pls remove the Q1 FY12 data from the from the detail sheet. Q1 Fy12 data is already available in the Summary sheet. Thanks a lot for your help. Regards Anu On Wed, Aug 31, 2011 at 6:05 AM, ashish koul koul.ash...@gmail.comwrote: try

Re: $$Excel-Macros$$ ***VBA code to copy and save as new book***

2011-08-31 Thread ashish koul
-- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

Re: $$Excel-Macros$$ urgent

2011-08-29 Thread ashish koul
-- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

Re: $$Excel-Macros$$ Reorder last and first names

2011-08-29 Thread ashish koul
link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing

Re: $$Excel-Macros$$ How can i fix my heading

2011-08-26 Thread ashish koul
@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http

Re: $$Excel-Macros$$ Re: Cut Data from Rows and Paste into Columns

2011-08-26 Thread ashish koul
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.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http

Re: $$Excel-Macros$$ BarHide

2011-08-25 Thread ashish koul
* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

Re: $$Excel-Macros$$ Multiple sorts on one Sheet

2011-08-25 Thread ashish koul
://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

Re: $$Excel-Macros$$ kindly suggest me how can I Unhide all the hide sheet in a single go.

2011-08-24 Thread ashish koul
@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http

Re: $$Excel-Macros$$ Copy the Last Row (Values) of Multiple Sheets to a Summary Sheet

2011-08-24 Thread ashish koul
-- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

Re: $$Excel-Macros$$ Need help in maro

2011-08-23 Thread ashish koul
/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

Re: $$Excel-Macros$$ Need a Help in Macro

2011-08-23 Thread ashish koul
://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

Re: $$Excel-Macros$$ Automatic Birth Day Outlook Mail Message

2011-08-22 Thread ashish koul
, Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P

Re: $$Excel-Macros$$ making pivot table report filters interdependent

2011-08-19 Thread ashish koul
@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http

Re: $$Excel-Macros$$ TAT reporting for assignment

2011-08-19 Thread ashish koul
/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

Re: $$Excel-Macros$$ Need to change Chart's Bar color based on value

2011-08-18 Thread ashish koul
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.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My

Re: $$Excel-Macros$$ Rolling 12-Month Average Lookup Dashboard Problem....

2011-08-18 Thread ashish koul
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

Re: $$Excel-Macros$$ filter out the cells with a particular formula

2011-08-18 Thread ashish koul
://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.blogspot.com/ http

Re: $$Excel-Macros$$ filter out the cells with a particular formula

2011-08-18 Thread ashish koul
filter out column I such that i extract values similar to a ( which use 0) and not b. Say suppose column I has 2cell records ... ? On Thu, Aug 18, 2011 at 9:05 PM, ashish koul koul.ash...@gmail.comwrote: see if it helps On Fri, Aug 19, 2011 at 6:24 AM, Sara Lee lee.sar...@gmail.com

Re: $$Excel-Macros$$ CheckBox to shade A2:B2

2011-08-18 Thread ashish koul
-- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

Re: $$Excel-Macros$$ Uniques Values

2011-08-18 Thread ashish koul
* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http

Re: $$Excel-Macros$$ Need your help in Vlookup formula.....

2011-08-18 Thread ashish koul
://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about

Re: $$Excel-Macros$$ Copy and Excel Chart and Past (with Source Formatting intact) in Powerpoint

2011-08-18 Thread ashish koul
-- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

Re: $$Excel-Macros$$ Request for Directory Audit Macro

2011-08-17 Thread ashish koul
://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.blogspot.com/ http://akoul.posterous.com/ *akoul

Re: $$Excel-Macros$$ Notes : Help

2011-08-16 Thread ashish koul
, Aug 16, 2011 at 5:40 AM, ashish koul koul.ash...@gmail.comwrote: can you attach your file On Mon, Aug 15, 2011 at 5:35 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, I am getting attached error while running the macro. Please let me know whats the error in the below code

Re: $$Excel-Macros$$ Notes : Help

2011-08-15 Thread ashish koul
, 2011 at 9:53 AM, ashish koul koul.ash...@gmail.comwrote: dont use .copy in set statement On Fri, Aug 12, 2011 at 3:43 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hello Ashish, I got solution for this issue but I am getting one more error in code as type mismatch *Set

Re: $$Excel-Macros$$ Required Formula to calculate rating

2011-08-13 Thread ashish koul
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.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http

Re: $$Excel-Macros$$ Move row to different sheet based on criteria

2011-08-13 Thread ashish koul
://exceldailytip.blogspot.**comhttp://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/**discussexcelhttp://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul

Re: $$Excel-Macros$$ Run-time error 1004 when no file selected

2011-08-11 Thread ashish koul
://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

Re: $$Excel-Macros$$ Locking cells based on conditions / todays date

2011-08-09 Thread ashish koul
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.blogspot.com

Re: $$Excel-Macros$$ While Using Vlookup Insted of Zero need Blanks...

2011-08-08 Thread ashish koul
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.blogspot.com/ http

Re: $$Excel-Macros$$ Email : Paste Object

2011-08-08 Thread ashish koul
-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.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin

$$Excel-Macros$$ Microsoft Excel World Champion

2011-08-05 Thread ashish koul
Meet Microsoft Excel World Champion http://gizmodo.com/5827731/the-microsoft-excel-world-champion-yes-srsly-is-a-15-year-old-english-girl -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com

Re: $$Excel-Macros$$ Syntax error on calling subroutine

2011-08-05 Thread ashish koul
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.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http

Re: $$Excel-Macros$$ Re: VBA macro runs fine, but freezes if I try to do ANYTHING else while it's running

2011-08-04 Thread ashish koul
* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

Re: $$Excel-Macros$$ Please help me(Combo box)

2011-08-03 Thread ashish koul
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.blogspot.com/ http

Re: $$Excel-Macros$$ Vlookup Including Cell Comments..

2011-08-03 Thread ashish koul
* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

Re: $$Excel-Macros$$ Macro to copy a block of formulas to other blocks

2011-08-03 Thread ashish koul
://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

Re: $$Excel-Macros$$ Copy VLookup Formula to alternate columns and update Col_Index_num

2011-08-03 Thread ashish koul
://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

Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - July'11

2011-08-03 Thread ashish koul
://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.blogspot.com/ http://akoul.posterous.com/ *akoul

Re: $$Excel-Macros$$ journal entry

2011-08-01 Thread ashish koul
-- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

Re: $$Excel-Macros$$ Multiple filters in one spreadsheet area

2011-08-01 Thread ashish koul
. 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

Re: $$Excel-Macros$$ journal entry

2011-08-01 Thread ashish koul
see if it helps On Mon, Aug 1, 2011 at 5:43 PM, Ananta Sapkota sapkota.ana...@gmail.comwrote: I want to enter journal voucher from one sheet of excel. And data of relevant account type must be entry its exact sheet. On Mon, Aug 1, 2011 at 11:56 AM, ashish koul koul.ash...@gmail.comwrote

Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets labelled 1 to X to Word.

2011-08-01 Thread ashish koul
, 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.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com

Re: $$Excel-Macros$$ excel function required to sum data on basis of criteria

2011-07-30 Thread ashish koul
-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.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http

Re: $$Excel-Macros$$ urgent help needed.

2011-07-30 Thread ashish koul
-- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment

Re: $$Excel-Macros$$ Dynamic Chart

2011-07-29 Thread ashish koul
link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing

Re: $$Excel-Macros$$ Extracting data from Website

2011-07-28 Thread ashish koul
B On Fri, Jul 22, 2011 at 1:00 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Thank u Ashish. I will check it out and come back to u If I have any clarification. Thanks! On Thu, Jul 21, 2011 at 3:07 PM, ashish koul koul.ash...@gmail.comwrote: http://akoul.blogspot.com/2011/06

Re: $$Excel-Macros$$ Query

2011-07-28 Thread ashish koul
below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before

Re: $$Excel-Macros$$ EXCEL 2010 VBA File: Read-Only Workbook created using EXCEL 2003

2011-07-27 Thread ashish koul
-in-access-in-excel.html On Wed, Jul 27, 2011 at 12:10 PM, XLS S xlst...@gmail.com wrote: Hey Ashis Sir, can provide the example please... On Wed, Jul 27, 2011 at 11:25 AM, ashish koul koul.ash...@gmail.comwrote: Hi its better you use access for working on shared files rather than

<    3   4   5   6   7   8   9   10   11   12   >