Re: $$Excel-Macros$$ Turning repating data in a Row into a sigle column

2014-05-03 Thread koul . ashish
Can u please share a sample file ? Sent on my BlackBerry® from Vodafone -Original Message- From: Freddy Sender: excel-macros@googlegroups.com Date: Sat, 3 May 2014 20:04:03 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Turning repating data in a Row into a sigle

Re: $$Excel-Macros$$ VBA Compare only visible rows

2014-04-30 Thread koul . ashish
Hi Benjamin Can you please let us know are all your values unique? Do you want to compare the same row nos or cell. Numbers ? Reason I m asking is if the values r unique and it is found you can use exit for as soon as condtion is met Also is it possible for you to share a sample file with dumm

Re: $$Excel-Macros$$ Re: VBA Job @ Ernst and Young , Gurgaon

2014-04-21 Thread koul . ashish
Pls share ur cv Sent on my BlackBerry® from Vodafone -Original Message- From: kapil Gupta Sender: excel-macros@googlegroups.com Date: Mon, 21 Apr 2014 04:00:54 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: VBA Job @ Ernst and Young , Gurgaon Hi, I am look

Re: $$Excel-Macros$$ Macro to copy data from a specif range from many closed workbooks in a folder to a master file creat

2014-04-16 Thread koul . ashish
Can you please let us know if all files saved in a single folder or in multiple folders? Can you please share some dummy files and master file how the output will look like Thanks Ashish Sent on my BlackBerry® from Vodafone -Original Message- From: Dragomir Zhelev Sender: excel-macro

Re: $$Excel-Macros$$ Very urgent . i need to submit my project today.. please help

2014-03-17 Thread koul . ashish
Y don't u use sumifs or countifs Sent on my BlackBerry(R) from Vodafone -Original Message- From: Prabhu Pinky Sender: excel-macros@googlegroups.com Date: Mon, 17 Mar 2014 15:48:28 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Very urgent . i need to submit m

Re: $$Excel-Macros$$ Excel Forum available @ discussexcel.com

2014-03-09 Thread koul . ashish
Can u share how output will look like Sent on my BlackBerry(R) from Vodafone -Original Message- From: ashish koul Date: Sun, 9 Mar 2014 22:42:50 To: excel-macros Subject: Re: $$Excel-Macros$$ Excel Forum available @ discussexcel.com which row you want to pick how r u going to decide th

Re: $$Excel-Macros$$ Export table data from outlook body to excel files

2014-02-06 Thread koul . ashish
Hi Ankit Save the outlook mail as word document and then open the document and copy content and paste it in excel You need to automate above steps Sent on my BlackBerry(R) from Vodafone -Original Message- From: Ankit Mehra Sender: excel-macros@googlegroups.com Date: Thu, 6 Feb 2014 16

Re: $$Excel-Macros$$ Importing Excel Files

2013-12-27 Thread koul . ashish
Is ur range fixed and do you want to append also or add the data in seperate tabs only Sent on my BlackBerry® from Vodafone -Original Message- From: Linda C Sender: excel-macros@googlegroups.com Date: Fri, 27 Dec 2013 08:40:19 To: Reply-To: excel-macros@googlegroups.com Subject: $$Exc

Re: $$Excel-Macros$$ Formula for averaging readings in Excel 2010 column, the odd and the even numbered cells

2013-11-27 Thread koul . ashish
Its ok You can also try averageif function Sent on my BlackBerry® from Vodafone -Original Message- From: Noel Sherry Sender: excel-macros@googlegroups.com Date: Wed, 27 Nov 2013 22:58:45 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Formula for averaging re

Re: $$Excel-Macros$$ Stuck in attaching multiple image files in email body

2013-11-19 Thread koul . ashish
You need to attach the images as well Sent on my BlackBerry® from Vodafone -Original Message- From: Farrukh Shaikh Sender: excel-macros@googlegroups.com Date: Tue, 19 Nov 2013 13:10:50 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Stuck in attaching multiple

Re: $$Excel-Macros$$ VBA for Excel to Word

2013-10-16 Thread koul . ashish
Can u share sample workbook n output format in word document Sent on my BlackBerry® from Vodafone -Original Message- From: Justin Pulley Sender: excel-macros@googlegroups.com Date: Wed, 16 Oct 2013 10:47:40 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ VBA for E

Re: $$Excel-Macros$$ Re: total Fridays in a range

2013-10-02 Thread koul . ashish
Can u explain it in detail Sent on my BlackBerry® from Vodafone -Original Message- From: asd...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 2 Oct 2013 01:22:20 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: total Fridays in a range On Wed

Re: $$Excel-Macros$$ Data Entry Form/Database

2013-10-02 Thread koul . ashish
Use excel as front end and access as back end to store information Create an access database with tables , etc save it in a share folder Create userform in excel and connect it with access db using ado Regards Ashish Sent on my BlackBerry® from Vodafone -Original Message- From: B V Di

Re: $$Excel-Macros$$ I NEED EXCEL CODE TO FORMAT AND SORT THE DATA FROM CONVERTED IMAGE DOCUMENT

2013-09-23 Thread koul . ashish
Do u want a formula which will convert image into excel ? Regards Ashish Sent on my BlackBerry® from Vodafone -Original Message- From: Mani Manju Sender: excel-macros@googlegroups.com Date: Mon, 23 Sep 2013 08:21:17 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$

Re: $$Excel-Macros$$ How to paste a range of cells from excel to text field of a web page

2013-09-21 Thread koul . ashish
Is it working if u pass a single cell value only Sent on my BlackBerry® from Vodafone -Original Message- From: Menaka Balakrishnamoorthy Sender: excel-macros@googlegroups.com Date: Sat, 21 Sep 2013 08:12:52 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How t

Re: $$Excel-Macros$$ Splitting single browser is possible ?

2013-09-17 Thread koul . ashish
Can u explain the requirement in details with image of screen if possible Sent on my BlackBerry® from Vodafone -Original Message- From: Abhidha Dixit Sender: excel-macros@googlegroups.com Date: Tue, 17 Sep 2013 13:10:57 To: excel-macros Reply-To: excel-macros@googlegroups.com Subject:

Re: $$Excel-Macros$$ Copy Past Macro help

2013-09-13 Thread koul . ashish
Hi R u using lotus notes or outlook for sending emails Regards Ashish Sent on my BlackBerry® from Vodafone -Original Message- From: shraddha malvankar Sender: excel-macros@googlegroups.com Date: Fri, 13 Sep 2013 10:57:37 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Ma

Re: $$Excel-Macros$$ Not getting daily emails

2013-07-05 Thread koul . ashish
Check ur google group settings Sent on my BlackBerry® from Vodafone -Original Message- From: PrIyAnKa Sender: excel-macros@googlegroups.com Date: Fri, 5 Jul 2013 14:27:14 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Not getting daily emails Dear Team Kindly d

Re: $$Excel-Macros$$ 8 become 0

2013-05-06 Thread koul . ashish
Change the format of cell to text or add ' in front of number Sent on my BlackBerry® from Vodafone -Original Message- From: priti verma Sender: excel-macros@googlegroups.com Date: Mon, 6 May 2013 16:29:14 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ 8 bec

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

2013-03-27 Thread koul . ashish
Can u share some sample input workbooks Sent on my BlackBerry® from Vodafone -Original Message- From: Aikistan Sender: excel-macros@googlegroups.com Date: Wed, 27 Mar 2013 08:06:39 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Macro newb - copy rows from multipl

Re: $$Excel-Macros$$ I need excel to find a value in the next row's cell back on the highest value of the previous cell.

2013-03-06 Thread koul . ashish
Can you share the excel file how would you like to see the output and also if possible make changes in the data of last row thr are two cells with 3% and I think you have to pick first instance Regards Ashish Sent on my BlackBerry® from Vodafone -Original Message- From: ferreg...@gm

Re: $$Excel-Macros$$ Getting Email Pattern

2013-02-01 Thread koul . ashish
Use Fn first name Fni or fi first intial Ln last name Lni or li last name intial Sent on my BlackBerry® from Vodafone -Original Message- From: rajan verma Sender: excel-macros@googlegroups.com Date: Fri, 1 Feb 2013 09:59:08 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-M

Re: $$Excel-Macros$$ Macro to delete a specific sheet by specifying

2013-01-29 Thread koul . ashish
Use input box pass the sheet name through inputbox Sent on my BlackBerry® from Vodafone -Original Message- From: Hilary Lomotey Sender: excel-macros@googlegroups.com Date: Tue, 29 Jan 2013 12:45:45 To: excel-macros Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Macro t

Re: $$Excel-Macros$$ Parts search with filters using a macro

2013-01-14 Thread koul . ashish
Are you selecting contains option manually? Regards Ashish Sent on my BlackBerry® from Vodafone -Original Message- From: Dan Nichols Sender: excel-macros@googlegroups.com Date: Mon, 14 Jan 2013 11:45:44 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Parts search

$$Excel-Macros$$ Happy b'day Noorain Ansari

2013-01-01 Thread koul . ashish
Happy b'day Noorain Ansari Regards Ashish Koul Sent on my BlackBerry® from Vodafone -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Probl

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

2012-12-11 Thread koul . ashish
have u selected the correct template and extension of template Pls check it once again Sent on my BlackBerry® from Vodafone -Original Message- From: Laura Ann Dietrich Sender: excel-macros@googlegroups.com Date: Tue, 11 Dec 2012 13:09:35 To: Reply-To: excel-macros@googlegroups.com Subj

Re: $$Excel-Macros$$ Scraping data from image

2012-11-29 Thread koul . ashish
Try able2extract professional version Or google OCR to word online converters Sent on my BlackBerry® from Vodafone -Original Message- From: Arsfan2005 Sender: excel-macros@googlegroups.com Date: Fri, 30 Nov 2012 12:58:24 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Exce

Re: $$Excel-Macros$$ convert time formatted as text to military time and join with date field

2012-11-29 Thread koul . ashish
Can u attach the excel file with sample data Sent on my BlackBerry® from Vodafone -Original Message- From: JenIT Sender: excel-macros@googlegroups.com Date: Thu, 29 Nov 2012 09:50:18 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ convert time formatted as text to

Re: $$Excel-Macros$$ Modify Code to to send range *

2012-11-28 Thread koul . ashish
Choose In tools ~reference ~ microsoft outlook Sent on my BlackBerry® from Vodafone -Original Message- From: Hilary Lomotey Sender: excel-macros@googlegroups.com Date: Wed, 28 Nov 2012 20:12:36 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Modify Code to t

Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .

2012-11-05 Thread koul . ashish
Right now its manual effort . You need to click on button every hour Sent on my BlackBerry® from Vodafone -Original Message- From: veerendra vanam Sender: excel-macros@googlegroups.com Date: Mon, 5 Nov 2012 22:50:04 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macro

Re: $$Excel-Macros$$

2012-10-19 Thread koul . ashish
Use application.displayalerts = false Application.screenupdating= false At the beginning of code And turn them true at the end of code before end sub Sent on my BlackBerry® from Vodafone -Original Message- From: Shrinivas Shevde Sender: excel-macros@googlegroups.com Date: Fri, 19 O

Re: $$Excel-Macros$$ VBA code to export from excel to word

2012-10-16 Thread koul . ashish
Can u share excel file and output in word Sent on my BlackBerry® from Vodafone -Original Message- From: Hilary Lomotey Sender: excel-macros@googlegroups.com Date: Tue, 16 Oct 2012 12:40:21 To: excel-macros Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ VBA code to exp

Re: $$Excel-Macros$$ Re: Macro to create Pivot Table for each sheet in the workbook

2012-10-14 Thread koul . ashish
Hi Its working fine on my desktop. Can you send the file Also specify which version of office u r using Sent on my BlackBerry® from Vodafone -Original Message- From: prkhan56 Sender: excel-macros@googlegroups.com Date: Sat, 13 Oct 2012 12:01:09 To: Reply-To: excel-macros@googlegroup

Re: $$Excel-Macros$$ Need Help related to XML with excel

2012-10-10 Thread koul . ashish
While you are importing use record macro option When u are done click on stop button Press alt +f11 to see the code Sent on my BlackBerry® from Vodafone -Original Message- From: Amol Jadhav Sender: excel-macros@googlegroups.com Date: Thu, 11 Oct 2012 11:54:30 To: Reply-To: excel-macr

Re: $$Excel-Macros$$ Creating Custom Ribbon

2012-09-11 Thread koul . ashish
Visit www.rondebruin.nl/ribbon.htm Sent on my BlackBerry® from Vodafone -Original Message- From: t vinay Sender: excel-macros@googlegroups.com Date: Tue, 11 Sep 2012 22:48:24 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Creating Custom Ribbon hi Team,m Can

Re: $$Excel-Macros$$ How to get Last Saved time in Cell B1

2012-09-07 Thread koul . ashish
Use before save event And save time in a1 Sent on my BlackBerry® from Vodafone -Original Message- From: Kuldeep Singh Sender: excel-macros@googlegroups.com Date: Fri, 7 Sep 2012 12:33:07 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to get Last Saved ti

Re: $$Excel-Macros$$ Macro for mail from excel - with sheets as an attachment

2012-08-25 Thread koul . ashish
http://www.rondebruin.nl/sendmail.htm Sent on my BlackBerry® from Vodafone -Original Message- From: "Amit Desai (MERU)" Sender: excel-macros@googlegroups.com Date: Sun, 26 Aug 2012 11:41:06 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Macro for mail from exce

Re: $$Excel-Macros$$ How can i reduce file size of a Excel file

2012-08-16 Thread koul . ashish
Save the file in .xlsb format Sent on my BlackBerry® from Vodafone -Original Message- From: Rakesh Kumar Sharma Sender: excel-macros@googlegroups.com Date: Thu, 16 Aug 2012 13:01:54 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ How can i reduce file size of a Ex

Re: $$Excel-Macros$$ PowerPoint to excel

2012-07-14 Thread koul . ashish
Can you share ppt and outfile in excel Sent on my BlackBerry® from Vodafone -Original Message- From: alpes...@gmail.com Sender: excel-macros@googlegroups.com Date: Sat, 14 Jul 2012 20:53:50 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$

Re: $$Excel-Macros$$ help in matching data in excel sheet

2012-05-19 Thread koul . ashish
Can you send the sample file Sent on my BlackBerry® from Vodafone -Original Message- From: Cute Awesome Sender: excel-macros@googlegroups.com Date: Sat, 19 May 2012 17:38:06 To: excel-macros@googlegroups.com\" Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ help in mat

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

2012-05-19 Thread koul . ashish
Can you share the sample data Sent on my BlackBerry® from Vodafone -Original Message- From: "B.N.Chethan Kumar" Sender: excel-macros@googlegroups.com Date: Sat, 19 May 2012 15:35:26 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help with PPT Dear friends, Do we

Re: $$Excel-Macros$$ count tricky question

2012-05-18 Thread koul . ashish
If u want to count total errors then Sum(if(iserror(a1:a10),1,0)) Press ctrl +shift+ enter And if you want to count types of error simply use countif Sent on my BlackBerry® from Vodafone -Original Message- From: danial mansoor Sender: excel-macros@googlegroups.com Date: Fri, 18 May 2

Re: $$Excel-Macros$$ count tricky question

2012-05-18 Thread koul . ashish
Len(a1)-len(substitute(a1,"a","")) Try see if it works Sent on my BlackBerry® from Vodafone -Original Message- From: danial mansoor Sender: excel-macros@googlegroups.com Date: Fri, 18 May 2012 09:48:57 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ count tricky qu