Re: $$Excel-Macros$$ Power pivot

2013-03-26 Thread ashish koul
://groups.google.com/groups/opt_out. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before

Re: $$Excel-Macros$$ SAS - SPSS

2013-03-25 Thread ashish koul
. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about

Re: $$Excel-Macros$$ please solve the search the particular name on the other sheet PFA

2013-03-16 Thread ashish koul
https://groups.google.com/**groups/opt_outhttps://groups.google.com/groups/opt_out . -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http

Re: $$Excel-Macros$$ Active Filters

2013-03-09 Thread ashish koul
. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment

Re: $$Excel-Macros$$ please solve the search the particular name on the other sheet PFA

2013-03-09 Thread ashish koul
/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http

Re: $$Excel-Macros$$ Re: calculating between two cells in two different sheets.

2013-03-09 Thread ashish koul
://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us

Re: $$Excel-Macros$$ Re: CLEAR CONTENTS of cells with value 0

2013-03-07 Thread ashish koul
://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join

Re: $$Excel-Macros$$ Telephone directory template

2013-03-07 Thread ashish koul
this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros

Re: $$Excel-Macros$$ Macro to sort cells based on highlights

2013-03-07 Thread ashish koul
...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http

Re: $$Excel-Macros$$ Re: CLEAR CONTENTS of cells with value 0

2013-03-06 Thread ashish koul
email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp

Re: $$Excel-Macros$$ Highlighted

2013-03-06 Thread ashish koul
to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- *Regards* * * *Ashish Koul* *Visit

Re: $$Excel-Macros$$ shuffle cell value in excel

2013-03-06 Thread ashish koul
options, visit https://groups.google.com/groups/opt_out. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups

Re: $$Excel-Macros$$ CLEAR CONTENTS of cells with value 0

2013-03-05 Thread ashish koul
email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp

Re: $$Excel-Macros$$ xlfn

2013-03-03 Thread ashish koul
options, visit https://groups.google.com/groups/opt_out. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups

Re: $$Excel-Macros$$ Dynamic Data Validation Issue

2013-02-18 Thread ashish koul
, visit https://groups.google.com/groups/opt_out. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P

Re: $$Excel-Macros$$ Condition with concatenate function

2013-02-14 Thread ashish koul
@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages

Re: $$Excel-Macros$$ vba code to insert chart from another excel file

2013-02-11 Thread ashish koul
-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http

Re: $$Excel-Macros$$ Macro

2013-02-11 Thread ashish koul
/groups/opt_out. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about

Re: $$Excel-Macros$$ VBA Code for Home tab

2013-02-09 Thread ashish koul
. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you

Re: $$Excel-Macros$$ IF Problem

2013-02-08 Thread ashish koul
://groups.google.com/groups/opt_out. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before

Re: $$Excel-Macros$$ Getting Path using VBA Code

2013-02-08 Thread ashish koul
. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment

Re: $$Excel-Macros$$ Macro to copy data within excel into tables in a word document

2013-02-04 Thread ashish koul
. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you

Re: $$Excel-Macros$$ Need your advise - MS Access 2007 drop down list Macro

2013-02-03 Thread ashish koul
complete details in batches wise 1st record to 6 th record like wise. Thanks, Raj On Sun, Oct 21, 2012 at 10:13 PM, ashish koul koul.ash...@gmail.comwrote: Option Compare Database Private Sub Command11_Click() ' Add microsoft Excel ' ADD aTIEVEX DATA OBJECT Dim xla

Re: $$Excel-Macros$$ Macro related.

2013-02-02 Thread ashish koul
to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- *Regards* * * *Ashish Koul* *Visit

Re: $$Excel-Macros$$

2013-02-01 Thread ashish koul
=en. For more options, visit https://groups.google.com/groups/opt_out. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com

Re: $$Excel-Macros$$ Blank out corresponding column if multiple criteria found

2013-01-31 Thread ashish koul
. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment

Re: $$Excel-Macros$$ Macro to Insert Rows Based on a Cell Value and put in the Value against each row.

2013-01-31 Thread ashish koul
...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http

Re: $$Excel-Macros$$ Macro require

2013-01-30 Thread ashish koul
an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- *Regards* * * *Ashish Koul

Re: $$Excel-Macros$$ Create Links to All sheet Starting from a particular sheet

2013-01-29 Thread ashish koul
-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com

Re: $$Excel-Macros$$ Need Formula

2013-01-28 Thread ashish koul
to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp

Re: $$Excel-Macros$$ Extract information from excel

2013-01-28 Thread ashish koul
to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us

Re: $$Excel-Macros$$ Need Formula

2013-01-28 Thread ashish koul
, Regards, Deepak On Mon, Jan 28, 2013 at 8:42 PM, ashish koul koul.ash...@gmail.comwrote: =SUM(IF($C$3:$C$10=G3,IF($D$3:$D$10,1,0))) Press *CTRL+SHIFT+ENTER* * * *Regards* *Ashish* On Mon, Jan 28, 2013 at 6:27 PM, Deepak Rawat deepakexce...@gmail.comwrote: Dear All, Pls provide

Re: $$Excel-Macros$$ Two-to-multi column sorting

2013-01-26 Thread ashish koul
, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros

Re: $$Excel-Macros$$ Need help with a couple subs

2013-01-26 Thread ashish koul
to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897

Re: $$Excel-Macros$$ Two-to-multi column sorting

2013-01-26 Thread ashish koul
Hi Its working at my place . Please find the working file attached Regards Ashish Koul On Sat, Jan 26, 2013 at 10:58 PM, Eugene Bernard eugene.bern...@gmail.comwrote: Mr Koul, Tested the macro, the result is not exactly matching requirement requested by Chris. Regards Eugene

Re: $$Excel-Macros$$ Save excel with date

2013-01-25 Thread ashish koul
to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897

Re: $$Excel-Macros$$ VBA Code -Slide Show

2013-01-23 Thread ashish koul
Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish

Re: $$Excel-Macros$$ Excel rename file in folder

2013-01-18 Thread ashish koul
try the attached file Regards Ashish Koul On Thu, Jan 17, 2013 at 10:50 PM, Viswanathan Yoganathan viswanathan.yoganat...@asia.xchanging.com wrote: Hi, ** ** I have 150 files in my folder and all my files to be renamed starting with A using VBA macro. ** ** Example

Re: $$Excel-Macros$$ Extract Price from cell link text

2013-01-17 Thread ashish koul
://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before

Re: $$Excel-Macros$$ Need formula

2013-01-17 Thread ashish koul
Deepak Watch this video you will be able to solve your problem on your *OWN* http://www.youtube.com/watch?v=27qh1i_kgCY Regards Ashish Koul On Thu, Jan 17, 2013 at 5:18 PM, Deepak Rawat deepakexce...@gmail.comwrote: Hi, thax for reply but still unsolved in panchayat it should come 2 rather

Re: $$Excel-Macros$$ HyperLinks to Sheets *

2013-01-16 Thread ashish koul
then ActiveCell.Offset(1, 1).Select else ActiveCell.Offset(1, 0).Select endif End If Next sh End Sub -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros

Re: $$Excel-Macros$$ Need Formula

2013-01-15 Thread ashish koul
. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com

Re: $$Excel-Macros$$ please correct the formula

2013-01-13 Thread ashish koul
to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http

Re: $$Excel-Macros$$ Re: Prince Kumar - Most Helpful Member December'12

2013-01-13 Thread ashish koul
...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http

Re: $$Excel-Macros$$ please correct the formula

2013-01-13 Thread ashish koul
try attached workbook On Sun, Jan 13, 2013 at 2:31 PM, Smitha S R sperdwo...@gmail.com wrote: HI, Tried but returns #VALUE On Sun, Jan 13, 2013 at 2:26 PM, ashish koul koul.ash...@gmail.comwrote: Try this =INDEX(Sheet1!C:C,MATCH(Sheet2!A2Sheet2!C2,Sheet1!$A$1:$A$5Sheet1!$B$1:$B$5,0

Re: $$Excel-Macros$$ Lookup

2013-01-11 Thread ashish koul
email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com

Re: $$Excel-Macros$$ Conditional Concatenate

2013-01-11 Thread ashish koul
to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http

Re: $$Excel-Macros$$ Conditional Concatenate

2013-01-11 Thread ashish koul
write UDF then On Fri, Jan 11, 2013 at 5:15 PM, Satendra kumar satendrakuma...@gmail.comwrote: many many thanks sir, but any other way with out helping column. thankx satendra On Fri, Jan 11, 2013 at 5:06 PM, ashish koul koul.ash...@gmail.comwrote: try the attachment see

Re: $$Excel-Macros$$ Sumproduct Formula Required

2013-01-11 Thread ashish koul
...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http

Re: $$Excel-Macros$$

2013-01-11 Thread ashish koul
@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp

Re: $$Excel-Macros$$ merge data

2013-01-10 Thread ashish koul
://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before

Re: $$Excel-Macros$$ merge data

2013-01-10 Thread ashish koul
(Merge).Range(a Sheets(Merge).Range(a1048576).End(xlUp).Row + 1) End If Next End Sub I have changed the upper row now to 3 you have first two rows blank On Fri, Jan 11, 2013 at 11:12 AM, ashish koul koul.ash...@gmail.com wrote: Try this Sub merge1() Dim i As Long, z As Long ' add new sheet

Re: $$Excel-Macros$$ Re: Keen to more Learn

2013-01-07 Thread ashish koul
-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us

Re: $$Excel-Macros$$ Needs excel formula to find the running totals between two dates

2013-01-07 Thread ashish koul
, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com

Re: $$Excel-Macros$$ date time subtraction

2013-01-07 Thread ashish koul
from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel

Re: $$Excel-Macros$$ VBA code for copying bitmap image into outlook

2013-01-03 Thread ashish koul
://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before

Re: $$Excel-Macros$$ VBA to Destination of Value only

2012-12-30 Thread ashish koul
(ItemsListArchives).Range(D Rows.Count).End(xlUp).Offset(7).value -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use

Re: $$Excel-Macros$$ Merry Christmas Happy New Year

2012-12-25 Thread ashish koul
Hi Group, Merry Christmas to All Try this macro to add Christmas Theme/Effect to Charts [?] http://www.excelvbamacros.com/2012/12/macro-to-replace-markers-with-custom.html Download Working File/Macro - https://www.box.com/s/02sfon6jloo7lpaj3s6c Regards Ashish Koul On Tue, Dec 25, 2012 at 8

Re: $$Excel-Macros$$ Concept of INDEX, Match, Direct, Indirect

2012-12-24 Thread ashish koul
this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- Join official Facebook

Re: $$Excel-Macros$$ Re: Need to convert the fax copy in Excel sheet.

2012-12-24 Thread ashish koul
, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* P Before

Re: $$Excel-Macros$$ Re: How to import web page Table in Excel

2012-12-22 Thread ashish koul
://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise

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

2012-12-22 Thread ashish koul
to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* P Before printing

Re: $$Excel-Macros$$ Re: Combine all sheets in a single sheet

2012-12-22 Thread ashish koul
+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- Join official Facebook page of this forum @ https

Re: $$Excel-Macros$$ Integration using Monte Carlo method in Excel

2012-12-22 Thread ashish koul
. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help

Re: $$Excel-Macros$$ hlep to convert pdf to excel

2012-12-21 Thread ashish koul
. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http

Re: $$Excel-Macros$$ Macro /Formula to Merge Text

2012-12-20 Thread ashish koul
* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent

Re: $$Excel-Macros$$ Date / Time Conversion Function or Macro Needed

2012-12-19 Thread ashish koul
try this =TEXT(B2,mmddhhmm) see if it helps On Wed, Dec 19, 2012 at 10:36 PM, Bill Q ronsmith...@gmail.com wrote: IE: January 8, 2012 9:01 would return a value of 201201080901. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* P Before printing, think about

Re: $$Excel-Macros$$ create a macro in pivot table

2012-12-18 Thread ashish koul
to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- Join official Facebook page of this forum @ https

Re: $$Excel-Macros$$ char code for SM (Service Mark)

2012-12-18 Thread ashish koul
group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http

Re: $$Excel-Macros$$ To Add Comments based on Cell Value

2012-12-17 Thread ashish koul
. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles

Re: $$Excel-Macros$$ Excel macro help please

2012-12-17 Thread ashish koul
MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul

Re: $$Excel-Macros$$ Consolidating Multiple files

2012-12-17 Thread ashish koul
to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http

Re: $$Excel-Macros$$ small query

2012-12-17 Thread ashish koul
://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise

Re: $$Excel-Macros$$ Re: Find and the current data on Form

2012-12-17 Thread ashish koul
+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- Join official Facebook page of this forum @ https

Re: $$Excel-Macros$$ Re: Find and the current data on Form

2012-12-17 Thread ashish koul
+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- Join official Facebook page of this forum @ https

Re: $$Excel-Macros$$ Pie Charts

2012-12-14 Thread ashish koul
to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join official

Re: $$Excel-Macros$$ FORMAT DATES IN USERFORM *

2012-12-13 Thread ashish koul
to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com

Re: $$Excel-Macros$$ VBA code for convert xls,xlsx into .CSV file

2012-12-11 Thread ashish koul
this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join official Facebook page of this forum @ https

Re: $$Excel-Macros$$ Request for formula:Unique value from same month

2012-12-11 Thread ashish koul
, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment

Re: $$Excel-Macros$$ Create New Worksheet Template Based on Cell Value

2012-12-11 Thread ashish koul
Then* *Set wsNew = Sheets(Target.Text)* *If wsNew Is Nothing Then Sheets.Add().Name = Target.Text* *End If* *End Sub* -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join

Re: $$Excel-Macros$$ Create New Worksheet Template Based on Cell Value

2012-12-11 Thread ashish koul
= Sheets(Target.Text)* *If wsNew Is Nothing Then Sheets.Add().Name = Target.Text* *End If* *End Sub* -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join

Re: $$Excel-Macros$$ Re: Create New Worksheet Template Based on Cell Value

2012-12-11 Thread ashish koul
how many sheets u have created in scanningprocess.xltm template On Tue, Dec 11, 2012 at 11:15 PM, Laura Ann Dietrich ldietri...@gmail.comwrote: scanningprocess.xltm -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before

Re: $$Excel-Macros$$ Re: Create New Worksheet Template Based on Cell Value

2012-12-11 Thread ashish koul
* * * * * * * On Tue, Dec 11, 2012 at 11:20 PM, Laura Ann Dietrich ldietri...@gmail.comwrote: scanningprocess.xltm is one worksheet. On Tue, Dec 11, 2012 at 12:47 PM, ashish koul koul.ash...@gmail.comwrote: how many sheets u have created in scanningprocess.xltm template On Tue, Dec 11, 2012

Re: $$Excel-Macros$$ Re: Create New Worksheet Template Based on Cell Value

2012-12-11 Thread ashish koul
(Target.Text) If wsNew Is Nothing Then Set sht = Sheets.Add(Type:=C:\Documents and Settings\user\Desktop\sample.xltx, After:=Sheets(Sheets.Count)) sht.Name = Target.Text End If End If End Sub Regards Ashish Koul -- Join official Facebook page of this forum

Re: $$Excel-Macros$$ Re: Create New Worksheet Template Based on Cell Value

2012-12-11 Thread ashish koul
sorry forget to mention please change the path of template as per your system and template name C:\Documents and Settings\user\Desktop\sample.xltx On Tue, Dec 11, 2012 at 11:31 PM, ashish koul koul.ash...@gmail.com wrote: Hi Laura *Please try this code* Private Sub Worksheet_Change

Re: $$Excel-Macros$$ Using VBA Macros to create a Purchase order form

2012-12-10 Thread ashish koul
. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http

Re: $$Excel-Macros$$ Need to create a summary sheet

2012-12-09 Thread ashish koul
...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join official Facebook page of this forum @ https

Re: $$Excel-Macros$$ sample problem

2012-12-08 Thread ashish koul
Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish

Re: $$Excel-Macros$$ File conversion from BMP to XLS !!!!!

2012-12-08 Thread ashish koul
MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http

Re: $$Excel-Macros$$ create a macro in pivot table

2012-12-08 Thread ashish koul
group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http

Re: $$Excel-Macros$$ Extracting Data from Multiple sheet.

2012-12-08 Thread ashish koul
MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http

Re: $$Excel-Macros$$ Need quick help to extract rows that meets a search criteria

2012-12-06 Thread ashish koul
to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com

Re: $$Excel-Macros$$ VBA to update in Website.

2012-12-06 Thread ashish koul
...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join official Facebook page of this forum @ https

Re: $$Excel-Macros$$ Extracting Text from Cell

2012-12-06 Thread ashish koul
* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread

Re: $$Excel-Macros$$ Formula to Calculate Weeks

2012-12-06 Thread ashish koul
@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P

Re: $$Excel-Macros$$ lookup based on multiple dates.

2012-12-03 Thread ashish koul
this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join official Facebook page of this forum @ https://www.facebook.com

Re: $$Excel-Macros$$

2012-12-03 Thread ashish koul
://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES

Re: $$Excel-Macros$$ Average from different sheets except blank data

2012-12-03 Thread ashish koul
-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com

Re: $$Excel-Macros$$ EMAIL AUTOMATION BY VBA OUTLOOK

2012-12-01 Thread ashish koul
Hi Try the attached file - change the folder path in code. Regards, Ashish Koul On Fri, Nov 30, 2012 at 10:15 AM, Satendra kumar satendrakuma...@gmail.comwrote: Dear Sir, I am not expert in vba, i am beginner vba so please me suggest me where is add loop?? thankx satendra On Thu

Re: $$Excel-Macros$$ EMAIL AUTOMATION BY VBA OUTLOOK

2012-12-01 Thread ashish koul
whts in cc email On Sun, Dec 2, 2012 at 10:55 AM, Satendra kumar satendrakuma...@gmail.comwrote: Thank you so much sir, but cc email is pick up thankx satendra On Sun, Dec 2, 2012 at 10:46 AM, ashish koul koul.ash...@gmail.comwrote: Hi Try the attached file - change

<    1   2   3   4   5   6   7   8   9   10   >