$$Excel-Macros$$ Job

2011-06-13 Thread ashish koul
: Current Location: CTC: Notice Period: Regards, Susan Monica susan.mon...@htcindia.com Human Resources, HTC Global Services, URL: www.htcinc.com An Inc.500 Hall of Fame Company *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul

$$Excel-Macros$$ JOB

2011-06-09 Thread ashish koul
Hi All, I recieved this mail regarding opeing with Zensar today, forwarding it to group . if some is looking for the job HE/SHE can apply Please find the job details below Dear ashish, Greetings from Zensar! Zensar Technologies (www.zensar.com) is among the top 25 software service

Re: $$Excel-Macros$$ Product wise total sale between two dates

2011-06-09 Thread ashish koul
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://in.linkedin.com/pub

Re: $$Excel-Macros$$ Formula Needed to Extract Data

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

Re: $$Excel-Macros$$ Excel Macro- source series for a chart from all sheets

2011-06-08 Thread ashish koul
the sheets you deselect your chart? How do I best write the code within the loop so that I do not get this error? On Jun 6, 3:22 pm, ashish koul koul.ash...@gmail.com wrote: Sub test() For i = 1 To Sheets.Count Sheets(i).Select ' paste ur code here Next i End Sub On Mon

Re: $$Excel-Macros$$ Macro to put singles years of age into five year age bands

2011-06-08 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$$ solution to put data automtically

2011-06-08 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$$ How to copy sheet to new book without sheet module code?

2011-06-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* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul

Re: $$Excel-Macros$$ Application.Caller

2011-06-08 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$$ Copy Multiple Workbooks into One Workbook Macro problem ...

2011-06-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$$ Need a basic tutorial in VB

2011-06-07 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$$ Copy Multiple Workbooks into One Workbook Macro problem ...

2011-06-07 Thread ashish koul
: User-define type not defined. The following line in the macro code is highlighted: Dim objShell As New Shell32.Shell -Greg On Jun 7, 2:22 am, ashish koul koul.ash...@gmail.com wrote: try this http://akoul.blogspot.com/2011/02/merge-data-from-multiple-sheet-from... see if it helps

Re: $$Excel-Macros$$ Copy Multiple Workbooks into One Workbook Macro problem ...

2011-06-07 Thread ashish koul
selected no Excel spreadsheet is created. Isn't that the way it suppose to work? On Jun 7, 10:01 am, ashish koul koul.ash...@gmail.com wrote: have you added Microsoft shell control and automation in refrences tool - reference - Microsoft shell control and automation

Re: $$Excel-Macros$$ Help with Excel macro

2011-06-07 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$$ Unexpected Open File Dialog

2011-06-07 Thread ashish koul
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, think

Re: $$Excel-Macros$$ To Copy Paste Data

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

Re: $$Excel-Macros$$ Excel Macro- source series for a chart from all sheets

2011-06-06 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$$

2011-06-06 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$$ i want 2 or more copies print when i press print button - Reg

2011-06-06 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$$ Formula Needed to Extract Data

2011-06-03 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$$ How to filter only the required information using VBA codes?

2011-05-25 Thread ashish koul
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$$ Pivot Items

2011-05-25 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$$

2011-05-25 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

Re: $$Excel-Macros$$ Macro to Enter Current Time and Date

2011-05-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* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul

Re: $$Excel-Macros$$ Seperate the data in proper fomat

2011-05-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* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul

Re: $$Excel-Macros$$ Simple VBA code for filter data in ascending

2011-05-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* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul

Re: $$Excel-Macros$$ Update pivot table filters based on already applied filters?

2011-05-23 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$$ Dynamic formula

2011-05-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* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com

Re: $$Excel-Macros$$ Re: Macro for Converting txt to xls using Text Import Wizard

2011-05-20 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/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin

Re: $$Excel-Macros$$ Freeze/Unalterable Cells

2011-05-20 Thread ashish koul
On Tue, May 17, 2011 at 10:00 PM, ashish koul koul.ash...@gmail.comwrote: http://akoul.blogspot.com/search?q=protect Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 3 Then 'target.column =3 because column c is no 3 column 'you can change password ashish and choose your

Re: $$Excel-Macros$$ Delete columns A thru D if blank

2011-05-20 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$$ Re: Help with Budget - Formula

2011-05-18 Thread ashish koul
://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.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$$ Copy paste data for dynamic data_need Excel Macro Solution

2011-05-17 Thread ashish koul
send email to excel-macros@googlegroups.com and attach your workbook On Mon, May 16, 2011 at 12:08 PM, sagaraher sagara...@gmail.com wrote: How to upload a excel file??..kindly help On May 13, 7:29 pm, ashish koul koul.ash...@gmail.com wrote: can you attach the sample sheet

Re: $$Excel-Macros$$ MinMaxAverage : Using Sumproduct

2011-05-17 Thread ashish koul
be 100, 50 avergage should be 87.5. Can we use sumproduct for all the formulas instead of array formulas. Thanks in advanc. Regards, Chandra Shekar B On Mon, May 16, 2011 at 9:15 PM, ashish koul koul.ash...@gmail.comwrote: try this On Mon, May 16, 2011 at 12:12 PM, Chandra Shekar

Re: $$Excel-Macros$$ Help Needed - Copy paste data for dynamic data_need Excel Macro Solution

2011-05-17 Thread ashish koul
* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.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$$ Freeze/Unalterable Cells

2011-05-17 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/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400

Re: $$Excel-Macros$$ MinMaxAverage : Using Sumproduct

2011-05-16 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/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10

Re: $$Excel-Macros$$ Formula required

2011-05-16 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/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830

Re: $$Excel-Macros$$ How to remove space in excel cell

2011-05-15 Thread ashish koul
Koul* *akoul*.*blogspot*.com http://akoul.blogspot.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$$ Excel Macro Request!

2011-05-15 Thread ashish koul
-- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.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$$ converting COUNTIFS formula to macro

2011-05-15 Thread ashish koul
on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.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$$ A macro to parse a wordlist in Excel

2011-05-14 Thread ashish koul
A (as a headword), then termination must be copied to column A in Sheet 2 and the phrase abnormal termination to column B in Sheet 2 (next to termination). === Is it possible for you to add this functionality? On May 13, 4:26 pm, ashish koul koul.ash

Re: $$Excel-Macros$$ Copy some files from a folder to another folder

2011-05-14 Thread ashish koul
use move to move files and copy to copy the files Public f As Object, d As Object Sub Main() Dim Fso As Object Set Fso = CreateObject(Scripting.FileSystemObject) Set RootFolder = Fso.GetFolder(C:\Documents and Settings\ashish\Desktop\ashish koul) FolderRead RootFolder End Sub

Re: $$Excel-Macros$$ Copy some files from a folder to another folder

2011-05-14 Thread ashish koul
use this one Public f As Object, d As Object, sw As Object Sub Main() Dim Fso As Object Set sw = CreateObject(Scripting.FileSystemObject) Set Fso = CreateObject(Scripting.FileSystemObject) Set RootFolder = Fso.GetFolder(C:\Documents and Settings\ashish\Desktop\ashish koul

Re: $$Excel-Macros$$ Calculate Due dates

2011-05-14 Thread ashish koul
at 1:25 PM, ashish koul koul.ash...@gmail.com wrote: change dd-mmm- to dd-mmm' in formula On Sat, May 7, 2011 at 7:47 AM, Mr excel excelkeec...@gmail.com wrote: dear ashish,, That is excellent great.Thanks a lot .The formula u provided is very nearer to the solution

Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 12 Messages in 8 Topics

2011-05-13 Thread ashish koul
:-kumar.pramod03i...@gmail.com more... Topic: Consolidate data ashish koul koul.ash...@gmail.com May 11 08:07AM +0530 ^ check the attachemnt see if it helps -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http

Re: $$Excel-Macros$$ A macro to parse a wordlist in Excel

2011-05-13 Thread ashish koul
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/ *akoul

Re: $$Excel-Macros$$

2011-05-13 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/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10

Re: $$Excel-Macros$$ Copy paste data for dynamic data_need Excel Macro Solution

2011-05-13 Thread ashish koul
link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.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$$ fixing Format of pivot table noit working

2011-05-13 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/ *akoul*.wordpress.com http

$$Excel-Macros$$ Re: Excel Fourmla

2011-05-13 Thread ashish koul
HUCCHINS RD , COX TOWN, BANGALORE #229, 9th A Main~vijayanagar, NEAR GOVT SCHOOL, BANGALORE-40 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400

Re: $$Excel-Macros$$ Excel Fourmla

2011-05-13 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/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http

Re: $$Excel-Macros$$ Need macro help to copy paste each column data under one column

2011-05-10 Thread ashish koul
Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.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$$ $$Excel - Macros$$ Help me to Generate report in a button Click and sent to the Manager

2011-05-10 Thread ashish koul
on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.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$$ Consolidate data

2011-05-10 Thread ashish koul
* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.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$$ .Refresh Background:-False

2011-05-09 Thread ashish koul
/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.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$$ get name of months from date

2011-05-08 Thread ashish koul
-- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.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$$ Calculate Due dates

2011-05-07 Thread ashish koul
of the sheet.Name of the month should be printed like April'2011 instead of *05-Apr-2011 TO 04-May-2011*. the above formula also is very helpful to me in another scenario.. Really my joy knew no boundaries.. On Fri, May 6, 2011 at 6:46 AM, ashish koul koul.ash...@gmail.com wrote: try

Re: $$Excel-Macros$$ Please Help

2011-05-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/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830

Re: $$Excel-Macros$$ needed forumula

2011-05-06 Thread ashish koul
our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.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$$ compile all excel file.

2011-05-06 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 Paste next blank row

2011-05-06 Thread ashish koul
send email to excel-macros@googlegroups.com and add the attachment On Fri, May 6, 2011 at 4:24 PM, Bob bobandrich...@comcast.net wrote: Were is it located to attach file? Sorry I don't see it. Thanks On May 6, 1:25 am, ashish koul koul.ash...@gmail.com wrote: can you share the sample file

Re: $$Excel-Macros$$ NEED HELP - GET PIVOT

2011-05-06 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/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http

Re: $$Excel-Macros$$ Macro to send email automatically.

2011-05-06 Thread ashish koul
http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.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$$ A small query, need your help in vba coding.

2011-05-06 Thread ashish koul
-- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.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$$ Calculate Due dates

2011-05-05 Thread ashish koul
, ashish koul koul.ash...@gmail.com wrote: can you expaln with some example in workbook On Tue, May 3, 2011 at 8:30 PM, keechak excelkeec...@gmail.com wrote: Hi forum, Thanks very much for creating such a wonderful forum. I had a problem in calculating the due dates for different customers

Re: $$Excel-Macros$$ data merged

2011-05-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/ *akoul*.wordpress.com http://akoul.wordpress.com/ My

Re: $$Excel-Macros$$ data merged

2011-05-05 Thread ashish koul
).Select ActiveSheet.Paste s.Save s.Close Application.ScreenUpdating = True End Sub select the master file when it asks for workbook On Thu, May 5, 2011 at 9:14 PM, ashish koul koul.ash...@gmail.com wrote: hi save all your daily files in a single folder and try code on below links

Re: $$Excel-Macros$$ Calculate Due dates

2011-05-05 Thread ashish koul
try this one On Thu, May 5, 2011 at 9:11 PM, ashish koul koul.ash...@gmail.com wrote: see if it helps On Thu, May 5, 2011 at 7:23 AM, Mr excel excelkeec...@gmail.com wrote: For example, The billing cycle for supplier A is 5th of this month to 4th next so all the transactions pertaining

Re: $$Excel-Macros$$ Copy Paste next blank row

2011-05-05 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/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin

Re: $$Excel-Macros$$ excel 2003 or 2007???

2011-05-04 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/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish

Re: $$Excel-Macros$$ Calculate Due dates

2011-05-04 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 Koul

Re: $$Excel-Macros$$ How to include new Rs font in Excel Currency format (option in format cell)

2011-04-30 Thread ashish koul
below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.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$$ Help Required!

2011-04-29 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/ *akoul

$$Excel-Macros$$ Re: Please Help.................

2011-04-27 Thread ashish koul
click on *Eng In out Report* button. Please see attached sheet.. Thanks in Advance -- Thanks regards, Noorain Ansari -- Thanks regards, Noorain Ansari -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http

Re: $$Excel-Macros$$ RE: Multiple file Formatting

2011-04-27 Thread ashish koul
://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.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

2011-04-27 Thread ashish koul
follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.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$$ Need Help urgent Please

2011-04-27 Thread ashish koul
:- vbNewLine SWA2 vbNewLine vbNewLine _ SMPS :- vbNewLine SWA3 Sheets(UPS).Activate End Sub -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub

Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 17 Messages in 11 Topics

2011-04-26 Thread ashish koul
/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.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$$ HELP SOS

2011-04-26 Thread ashish koul
://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.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. -- *Regards

Re: $$Excel-Macros$$ Show full screen for a particular workbook only.

2011-04-25 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/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http

Re: $$Excel-Macros$$ Excel spell out word from number

2011-04-25 Thread ashish koul
below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.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$$ help

2011-04-25 Thread ashish koul
://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.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

2011-04-21 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/ *akoul*.wordpress.com http

Re: $$Excel-Macros$$ Need macro code help regaring the pop up .

2011-04-20 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/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul

Re: $$Excel-Macros$$ pls help

2011-04-20 Thread ashish koul
/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.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$$ Re: Search Formula

2011-04-19 Thread ashish koul
Where i have to make change. Regards, C.G.Kumar On Mon, Apr 18, 2011 at 6:18 PM, ashish koul koul.ash...@gmail.comwrote: try this see if it helps On Mon, Apr 18, 2011 at 2:21 PM, C.G.Kumar kumar.bemlmum...@gmail.comwrote: Hello, I have a very tricky problem. I have got an excel sheet

Re: $$Excel-Macros$$ How to Separate Text and Nos in a sentence ?

2011-04-19 Thread ashish koul
* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.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

$$Excel-Macros$$ Re: Search Formula

2011-04-18 Thread ashish koul
. Secondly it should display only those 4 rows in the result. Like if we are using a sort function. Regards, C.G.Kumar -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub

Re: $$Excel-Macros$$ Deploying Excel 2003 updates

2011-04-18 Thread ashish koul
page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.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$$ Re:Data - text to date format

2011-04-17 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$$ Re: Open Excel addin is unavailable

2011-04-16 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/ *akoul*.wordpress.com http

Re: $$Excel-Macros$$ Macro Help in Excel 2007?

2011-04-16 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/ *akoul*.wordpress.com http://akoul.wordpress.com

Re: $$Excel-Macros$$ how to copy all sheets data in one sheet by VBA

2011-04-16 Thread ashish koul
://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.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$$ How to make excel addins

2011-04-16 Thread ashish koul
://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.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$$ Re: Open Excel addin is unavailable

2011-04-15 Thread ashish koul
http://code.google.com/p/openexcel/downloads/detail?name=OPEN_XL.zipcan=2q = On Fri, Apr 15, 2011 at 10:26 AM, ashish koul koul.ash...@gmail.com wrote: try this =SUBSTITUTE(B3,.,-)-SUBSTITUTE(A3,.,-) On Fri, Apr 15, 2011 at 8:34 AM, Mohd Sanusi Mohd Noor sanus...@gmail.com wrote: Dear

Re: $$Excel-Macros$$ Macro Help in Excel 2007?

2011-04-15 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/ *akoul

Re: $$Excel-Macros$$ Problem in pivot table

2011-04-15 Thread ashish koul
layout. But my pivot is little bit complicated.Why is that so happening?. Why did you use employee code in data instead of count of poor or count of avg etc.? I am sending you the attachment. Regards, Alisha On Fri, Apr 15, 2011 at 10:27 AM, ashish koul koul.ash...@gmail.comwrote: see

Re: $$Excel-Macros$$ Re: Open Excel addin is unavailable

2011-04-14 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$$ Problem in pivot table

2011-04-14 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

<    5   6   7   8   9   10   11   12   13   14   >