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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Protect cells if it have data

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

Re: $$Excel-Macros$$ Re: Saving an Excel sheet as a UTF8 .txt and .csv - have code, need modifications!

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

2011-06-14 Thread ashish koul
To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http

Re: $$Excel-Macros$$ Macros to rearrange data

2011-06-14 Thread ashish koul
://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http

Re: $$Excel-Macros$$ Using a macro to login to a web-site

2011-06-14 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$$ Protecting certain cells based on conditions

2011-06-14 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$$ excel query

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

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