Re: $$Excel-Macros$$ time wages calculation

2013-04-19 Thread ashish koul
gt; "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send 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/

Re: $$Excel-Macros$$ print current file to pdf

2013-04-19 Thread ashish koul
material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS"

Re: $$Excel-Macros$$ convert date value into month number of format eg 03 for March

2013-04-19 Thread ashish koul
roup and stop receiving emails from it, send 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://g

Re: $$Excel-Macros$$ print current file to pdf

2013-04-15 Thread ashish koul
uot;MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send 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/gro

Re: $$Excel-Macros$$ Help needed

2013-04-11 Thread ashish koul
receiving emails from it, send 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/op

Re: $$Excel-Macros$$ Dynamic Charting

2013-04-04 Thread ashish koul
full jadhav wrote: > > Dear Ashish Sir, > > Can you explain the below formula ..what is "Small" function work here. > > > =IFERROR(SMALL(IF($B$2:$B$16=$G$2,$A$2:$A$16,""),ROW(A1)),"") > > Regards, > Prafull Jadhav > > > On Thu, Ap

Re: $$Excel-Macros$$ Dynamic Charting

2013-04-04 Thread ashish koul
Try this one too without pivot table . On Thu, Apr 4, 2013 at 10:11 PM, ashish koul wrote: > you can try pivot charts . Find the sample file attached. Just select the > day in the report filter > > > > On Thu, Apr 4, 2013 at 10:03 PM, Chris wrote: > >> I have data b

Re: $$Excel-Macros$$ Dynamic Charting

2013-04-04 Thread ashish koul
u are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. >

Re: $$Excel-Macros$$ Vertical Data Require

2013-04-03 Thread ashish koul
, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4)

Re: $$Excel-Macros$$ Zigzag Data into One Column

2013-04-03 Thread ashish koul
d 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. > &g

Re: $$Excel-Macros$$ Need help on Graph

2013-04-02 Thread ashish koul
stop receiving emails from it, send 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/grou

Re: $$Excel-Macros$$ Data req in attched sheet format.

2013-03-30 Thread ashish koul
receiving emails from it, send 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/o

Re: $$Excel-Macros$$ hi all***need code to attacha file in outlook and send it to respective email id***

2013-03-29 Thread ashish koul
d 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.excelvbamacro

Re: $$Excel-Macros$$ Index / Match formula - Ignoring blank cells

2013-03-28 Thread ashish koul
gt; "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send 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.co

Re: $$Excel-Macros$$ Sample Data

2013-03-28 Thread ashish koul
tial data in a workbook. Forum owners >>>> and members are not responsible for any loss. >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "MS EXCEL AND VBA MACROS" group. >>>> To unsubscr

Re: $$Excel-Macros$$ Amount in words

2013-03-28 Thread ashish koul
ot responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@g

Re: $$Excel-Macros$$ pls find the attached sheet and help me out this.

2013-03-28 Thread ashish koul
send 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. > > >

Re: $$Excel-Macros$$ Sample Data

2013-03-27 Thread ashish koul
VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send 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-

Re: $$Excel-Macros$$ Macro newb - copy rows from multiple workbooks using condition

2013-03-27 Thread ashish koul
ecause you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros...@**googlegroups.com. >> To post to this group, send email to excel-...@google

Re: $$Excel-Macros$$ Power pivot

2013-03-26 Thread ashish koul
end 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.excel

Re: $$Excel-Macros$$ Serial Number

2013-03-26 Thread ashish koul
from this group and stop receiving emails from it, send 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.

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

2013-03-25 Thread ashish koul
his 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://www.excelvba

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

2013-03-16 Thread ashish koul
> 6) Sharing copyrighted material and their links is not allowed. >>>> >>>> NOTE : Don't ever post confidential data in a workbook. Forum owners >>>> and members are not responsible for any loss. >>>> --- >>>> You received this message b

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

2013-03-09 Thread ashish koul
ible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To

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

2013-03-09 Thread ashish koul
S" group. > To unsubscribe from this group and stop receiving emails from it, send 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

Re: $$Excel-Macros$$ Active Filters

2013-03-09 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 Facebook<http://www.facebook.com/pag

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

2013-03-07 Thread ashish koul
o the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at h

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

2013-03-07 Thread ashish koul
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* * * *As

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

2013-03-07 Thread ashish koul
estions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workboo

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

2013-03-06 Thread ashish koul
m/**groups/opt_out<https://groups.google.com/groups/opt_out> >>> . >>> >>> >>> >> >> -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https

Re: $$Excel-Macros$$ Highlighted

2013-03-06 Thread ashish koul
s+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* *My E

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

2013-03-06 Thread ashish koul
ved this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-

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

2013-03-05 Thread ashish koul
g copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA

Re: $$Excel-Macros$$ xlfn

2013-03-03 Thread ashish koul
gt; 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 Blo

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

2013-02-18 Thread ashish koul
roups.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$$ Condition with concatenate function

2013-02-14 Thread ashish koul
attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6)

Re: $$Excel-Macros$$ Macro

2013-02-11 Thread ashish koul
swered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted mate

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

2013-02-11 Thread ashish koul
t ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop r

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

2013-02-09 Thread ashish koul
esponsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googleg

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

2013-02-08 Thread ashish koul
s/opt_out> >>> . >>> >>> >>> >> >> -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > &

Re: $$Excel-Macros$$ IF Problem

2013-02-08 Thread ashish koul
> 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 Facebook<http://www.f

Re: $$Excel-Macros$$ Conditional Format Entire Row if Any Column has a specific value

2013-02-05 Thread ashish koul
t; "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send 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

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

2013-02-04 Thread ashish koul
os@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 Facebook&

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

2013-02-03 Thread ashish koul
here are more than 2lac rows or records in access Just require ur >>> expertise can i use the same macro which is listed below if so please >>> advise the sql command to get for example >>> >>> to export complete details in batches wise >>> >

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

2013-02-02 Thread ashish koul
ot responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.

Re: $$Excel-Macros$$

2013-02-01 Thread ashish koul
L AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send 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

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
ed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google

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

2013-01-31 Thread ashish koul
to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this grou

Re: $$Excel-Macros$$ Macro require

2013-01-30 Thread ashish koul
om/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 Facebook<http://www.facebook.com/pages/Excel-VBA-Codes-Macros/1518038

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

2013-01-29 Thread ashish koul
book. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel

Re: $$Excel-Macros$$ Need Formula

2013-01-28 Thread ashish koul
> Thanks a Lot Ashish, >> >> Regards, >> Deepak >> >> >> On Mon, Jan 28, 2013 at 8:42 PM, ashish koul wrote: >> >>> =SUM(IF($C$3:$C$10=G3,IF($D$3:$D$10<>"",1,0))) >>> >>> Press *CTRL+SHIFT+ENTER* >>> * >>&g

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

2013-01-28 Thread ashish koul
st 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. > For more options, visit https://groups.google.com/groups

Re: $$Excel-Macros$$ Need Formula

2013-01-28 Thread ashish koul
ROS" 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. > For more options, visit https:

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 wrote: > Mr Koul, > > Tested the macro, the result is not exactly matching requirement requested > by Chris. > > Regards > Eugene

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

2013-01-26 Thread ashish koul
d material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" gro

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

2013-01-26 Thread ashish koul
material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACR

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

2013-01-25 Thread ashish koul
use you are subscribed to the Google 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://gro

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

2013-01-23 Thread ashish koul
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 Facebook<http://www.facebook.com/pages/Excel-VBA-Codes-Macros

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 wit

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 wrote: > Hi, > thax for reply > but still unsolved in panchayat it should come 2 rather than 5 &g

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

2013-01-17 Thread ashish koul
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 U

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

2013-01-16 Thread ashish koul
ess:= _ > "'" & sh.Name & "'" & "!A1", TextToDisplay:=sh.Name > if activeCell.row mod 30 =0 then > ActiveCell.Offset(1, 1).Select > else > ActiveCell.Offset(1, 0).Select > endif

Re: $$Excel-Macros$$ Need Formula

2013-01-15 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

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 wrote: > HI, > Tried but returns #VALUE > > > On Sun, Jan 13, 2013 at 2:26 PM, ashish koul wrote: > >> Try this >> >> >> >> =INDEX(Sheet1!C:C,MATCH(Sheet2!A2&Sheet2!C2,Sheet1!$

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

2013-01-13 Thread ashish koul
oblem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. >

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

2013-01-13 Thread ashish koul
ou received this message because you are subscribed to the Google 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

Re: $$Excel-Macros$$

2013-01-11 Thread ashish koul
curity > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not resp

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. >> >> >> > > > > -- > > Warm Regards, > Aindril De > Ph: 9811300157 > > -- > Join official Facebook page of this forum @ > https://www.face

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 wrote: > 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 wrote: > >> try the attachment see if

Re: $$Excel-Macros$$ Conditional Concatenate

2013-01-11 Thread ashish koul
ups.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. >>>>> >>>>> >>>>> >&g

Re: $$Excel-Macros$$ Lookup

2013-01-11 Thread ashish koul
tles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > m

Re: $$Excel-Macros$$ merge data

2013-01-10 Thread ashish koul
76").End(xlUp).Row ' paste the data on the merge sheet Sheets(i).Rows("4:" & z).Copy Destination:=Sheets("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 yo

Re: $$Excel-Macros$$ merge data

2013-01-10 Thread ashish koul
; measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible fo

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

2013-01-07 Thread ashish koul
CEL 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. > > > -- *Reg

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

2013-01-07 Thread ashish koul
Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from

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

2013-01-07 Thread ashish koul
- > You received this message because you are subscribed to the Google 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...@googlegrou

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

2013-01-03 Thread ashish koul
gt; 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL

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

2012-12-30 Thread ashish koul
; Sheets("DailyList").Range("ItemsList").Copy > Destination:=Sheets("ItemsListArchives").Range("D" & > Rows.Count).End(xlUp).Offset(7).value -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* P Before printing, think about the

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$$ Re: Need to convert the fax copy in Excel sheet.

2012-12-24 Thread ashish koul
book. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group

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

2012-12-24 Thread ashish koul
opyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA

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

2012-12-22 Thread ashish koul
o > 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 pa

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

2012-12-22 Thread ashish koul
NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send

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

2012-12-22 Thread ashish koul
ntial data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.

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

2012-12-22 Thread ashish koul
L AND VBA MACROS" group. >> To post to this group, send email to excel-...@googlegroups.com. >> To unsubscribe from this group, send email to excel-macros...@** >> googlegroups.com. >> >> Visit this group at >> http://groups.google.com/**group/excel-macro

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

2012-12-21 Thread ashish koul
their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group.

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

2012-12-20 Thread ashish koul
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 offi

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

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

2012-12-18 Thread ashish koul
quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allo

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

2012-12-18 Thread ashish koul
ge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You

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

2012-12-17 Thread ashish koul
ial 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, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may n

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

2012-12-17 Thread ashish koul
oin 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, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or

Re: $$Excel-Macros$$ small query

2012-12-17 Thread ashish koul
Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscri

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

2012-12-17 Thread ashish koul
>>>> 2) Don't post a question in the thread of another member. >>>> 3) Don't post questions regarding breaking or bypassing any security >>>> measure. >>>> 4) Acknowledge the responses you receive, good or bad. >>>> 5) Jobs posting

Re: $$Excel-Macros$$ How to develop Addins

2012-12-17 Thread ashish koul
cribed to the Google 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/g

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

2012-12-17 Thread ashish koul
legroups.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

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

2012-12-17 Thread ashish koul
are not responsible for any loss. > --- > You received this message because you are subscribed to the Google 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 em

Re: $$Excel-Macros$$ Pie Charts

2012-12-14 Thread ashish koul
subscribe from this group, send email to >> excel-macros+unsubscr...@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros?hl=en. >> >> >> > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel

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

2012-12-13 Thread ashish koul
r may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing

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 wrote: > Hi Laura > > > *Please try this code* > > Private Sub Work

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