$$Excel-Macros$$ EXCEL HELP

2012-05-30 Thread Tarun Mondal
Sir , I have entered values 200 and o in one single column and i want generate a report how many 200 and how many 0 are there in the same column.please sir reply quickly ...it's urgent... -- Tarun Mondal Postal Assistant Katwa Head Post Office Burdwan,West Bengal (9474810276) -- FORUM RULES (

$$Excel-Macros$$ EXCEL HELP

2010-02-09 Thread somasekhar duvvapu
hi, Can anybody help me for writing excel macro. plz find the attached excel sheet for the problem, with regards, sekhar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and link

$$Excel-Macros$$ EXCEL HELP

2010-03-07 Thread karthikeyan
HI, I HAVE 500 PERSONS NAME IN SHEET1. LIKE:-BOX BAT BALL BLACK AXE IN SHEET2 AND SELECT CELL A1 WHEN I ENTER FIRST LETTER (AVAILABLE IN SHEET1) LIKE "B" COLUMN "C" SHOWS LIST OF AVAILABLE NAMES STARTING WITH "B"-LETTER.ITS LIKE GOOGLE SEARCH

$$Excel-Macros$$ excel help

2010-07-21 Thread preeti vora
Hi team, when we do vlookup is that possible without col_index_num and range_lookup for use vlookup..or can we use any other function instead of vlookup... -- Regards, Preeti Vora. -- -- Some important links for e

$$Excel-Macros$$ Excel Help

2009-01-10 Thread How Do you?
I'm using excel to do weekly time sheet and I created another page/tab with in the same workbook and I'm trying to post job numbers between the two sheets. If I post a new Job number and it's not already on the control sheet I want to add, not + but include it in the job numbers. Anybody? --~--~-

$$Excel-Macros$$ Excel Help...

2009-03-13 Thread Ashkaran Badlani
Hi Team, I have a list of numbers in an excel columns. I need to open a site and enter the numbers one by one in the search field of Open site and hit enter. I also need to capture the some information from the screen after clickling enter and then get back to the search page. Can anyone please

$$Excel-Macros$$ Excel-Help

2009-04-24 Thread raafi barey
Hi, I have a data which is more than the capacity of excel 2002..how can i retrieve the complete data..ny possibilty of loading into seperate sheets.. Regards Raafi --~--~-~--~~~---~--~~

$$Excel-Macros$$ Excel Help

2009-10-25 Thread karthikeyan
HI, How can i fillter the colored cells in excel. Except 2007 Txs karthik --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Fr

$$Excel-Macros$$ excel help

2009-12-01 Thread karthikeyan
Hi, A particular sheet in excel file doesn't allow cut/copy/paste. txs -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2.

$$Excel-Macros$$ Excel Help

2011-01-21 Thread DavidG
Hi I am trying to build a system for a hairdressers to manage their contacts and activity. I have tried using access which is the obvious answer but I am struggling with the relationships. So i thought excel might do the job. I need a new page per client, but am unsure if excel will do this? Any

$$Excel-Macros$$ Excel help

2011-04-03 Thread bhanu prakash
Hi - need it help excel. Removing zeros in alpha numeric data, ex ,,07855a need help in removing zeros in every cell. Regards ,- bhanu -- -- Some important links for excel users: 1. Follow us on TWITTER for tips trick

$$Excel-Macros$$ excel help me

2018-01-06 Thread Deepu Raj
how to remove 1025 to 25 or 140 to 40 ie hundred and thousand removing using excel -- 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 FORUM RULES 1) Use concise,

Re: $$Excel-Macros$$ EXCEL HELP

2012-05-30 Thread NOORAIN ANSARI
Dear Tarun, Please use.. =COUNTIF($E$1:$E$19,0) =COUNTIF($E$1:$E$19,200) On Thu, May 31, 2012 at 11:46 AM, Tarun Mondal wrote: > Sir , > > I have entered values 200 and o in one single column and i want generate a > report how many 200 and how many 0 are there in the same column.please sir > rep

Re: $$Excel-Macros$$ EXCEL HELP

2010-02-10 Thread somasekhar duvvapu
Hi Group, I want to learn excel macros. so can anybody have excel macro learning document for easily learning. with regards, sekhar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks

Re: $$Excel-Macros$$ EXCEL HELP

2010-02-12 Thread shannu shannu
2001, 2002, 2003.   same like vlookup but the result is unique then keep on adding with a comma for that look up.   Regards, Shan --- On Wed, 2/10/10, ayush jain wrote: From: ayush jain Subject: Re: $$Excel-Macros$$ EXCEL HELP To: excel-macros@googlegroups.com Cc: somasekhar2...@gmail.com Date

Re: $$Excel-Macros$$ Excel Help

2010-03-03 Thread rf1234 rf1234
dear shiv i think you can use a simple way pivot table and pivote grapgh. if more help required please send me me your sample sheet,and offcourse image file for required graph. hope it will help. happy to help. :) shyam On Wed, Mar 3, 2010 at 10:05 AM, Shiv Goel wrote: > Hi > > > I try to ma

Re: $$Excel-Macros$$ excel help

2010-07-22 Thread Dilip Pandey
Hi Preeti, Vlookup requires col_index_num and range_lookup to function properly, If reqd., instead of Vlookup you can use Index, Match, Offset, SumIf, Sumproduct etc as well. :) -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipa

Re: $$Excel-Macros$$ excel help

2009-12-01 Thread Dilip Pandey
Dear Karthik, Check if that sheet is protected. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 12/1/09, karthikeyan wrote: > > Hi, > > A particular sheet in excel file doesn't allow cut/copy

RE: $$Excel-Macros$$ excel help

2009-12-01 Thread Dave Bonallack
Check to see if there is a SheetActivate event macro for that particular sheet. Regards - Dave. > Date: Tue, 1 Dec 2009 08:06:15 -0800 > Subject: $$Excel-Macros$$ excel help > From: karthikeyansankar...@gmail.com > To: excel-macros@googlegroups.com > > Hi, > > A p

Re: $$Excel-Macros$$ Excel help

2011-04-03 Thread STDEV(i)
run this macro Sub RemoveAllZeros() Dim xCell As Range For Each xCell In ActiveSheet.UsedRange xCell = Replace(xCell, "0", "") Next End Sub since you ask for "REMOVING ZERO IN EVERY CELL" 1500 will be 15 2100500 will be 215 and so on On Sun, Apr 3, 2011 at 9:55 PM, bhanu pr

Re: $$Excel-Macros$$ Excel help

2011-04-03 Thread ChilExcel
Please attach file, so see what you need There are many ways, row or column or range I answer what you need to pair 2011/4/3 bhanu prakash > Hi - need it help excel. Removing zeros in alpha numeric data, ex ,,07855a > need help in removing zeros in every cell. Regards ,- bhanu > > -- > >

Re: $$Excel-Macros$$ Excel help

2011-04-03 Thread Mahesh parab
Hi Use =SUBSTITUTE(A1,"0","") On Sun, Apr 3, 2011 at 8:25 PM, bhanu prakash wrote: > Hi - need it help excel. Removing zeros in alpha numeric data, ex ,,07855a > need help in removing zeros in every cell. Regards ,- bhanu > > -- > > --

Re: $$Excel-Macros$$ Excel help

2011-04-03 Thread Dhananjay Pinjan
u can use the following formula =SUBSTITUTE(A1,0,"") (where Cell A1 is target data) Regards, Dhananjay On Sun, Apr 3, 2011 at 8:25 PM, bhanu prakash wrote: > Hi - need it help excel. Removing zeros in alpha numeric data, ex ,,07855a > need help in removing zeros in every cell. Regards ,- bhan

Re: $$Excel-Macros$$ Excel help

2011-04-03 Thread Shreedar Pandurangaiah
Hi Bhanu, Select all the cells where you want to remove zeros and select control + H, and type 0 and replace with blank and then click on* Replace All.* * * * * Thank you, Shreedar On Sun, Apr 3, 2011 at 8:25 PM, bhanu prakash wrote: > Hi - need it help excel. Removing zeros in alpha numeric da

Re: $$Excel-Macros$$ Excel help

2011-04-03 Thread bhanu prakash
Guys thanks a ton for responses ,i need to remove only first letter in cell if it is zero in alpha numeric data - regards - bhanu On 04-Apr-2011 3:45 AM, "STDEV(i)" wrote: run this macro Sub RemoveAllZeros() Dim xCell As Range For Each xCell In ActiveSheet.UsedRange xCell = Replac

Re: $$Excel-Macros$$ Excel help

2011-04-03 Thread ashish koul
try this made some changes in the code Sub RemoveAllZeros() Dim xCell As Range For Each xCell In ActiveSheet.UsedRange If Left(xCell.Value, 1) = 0 Then xCell.Value = Right(xCell.Value, Len(xCell.Value) - 1) End If Next End Sub On Mon, Apr 4, 2011 at 6:04 AM, bhanu prakas

Re: $$Excel-Macros$$ Excel help

2011-04-03 Thread STDEV(i)
then the macro should be modified like this Sub RemoveLeadingZeros() Dim xCell As Range, i As Integer, s As String For Each xCell In ActiveSheet.UsedRange s = CStr(xCell) For i = 1 To Len(xCell) If Mid(xCell, i, 1) = "0" Then s = Right(s, Len(s) - 1)

Re: $$Excel-Macros$$ Excel help

2011-04-03 Thread §»VIPER«§
if your data in a1 type the below formula on anywhere in the same worksheet =IF(AND(ISTEXT(A1),LEFT(A1,1)="0"),RIGHT(A1,LEN(A1)-1),A1) -- *Thanks & Regards Thamu * On Mon, Apr 4, 2011 at 6:04 AM, bhanu prakash wrote: > Guys thanks a ton for responses ,i need to remove only first letter in

Re: $$Excel-Macros$$ Excel help

2011-04-04 Thread STDEV(i)
i think mr. bhanu needs "000999" tobe "999" not "00999" On Mon, Apr 4, 2011 at 11:45 AM, §»VIPER«§ wrote: > if your data in a1 type the below formula on anywhere in the same worksheet > =IF(AND(ISTEXT(A1),LEFT(A1,1)="0"),RIGHT(A1,LEN(A1)-1),A1) > -- > *Thanks & Regards > Thamu > * > > --

Re: $$Excel-Macros$$ excel help me

2018-01-06 Thread Mangesh Vimay
You can use left or right function by converting number to text.. On Jan 6, 2018 21:26, "Deepu Raj" wrote: > how to remove 1025 to 25 or 140 to 40 ie hundred and thousand removing > using excel > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:O

$$Excel-Macros$$ Excel help : Remove Page Breaks Using VBA code

2010-05-12 Thread Sundarvelan N
Hello Friends, Can anyone help me to remove Page Breaks in Excel sheets Using VBA code. Thanks, N.Sundarvelan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://t

Re: $$Excel-Macros$$ Excel help : Remove Page Breaks Using VBA code

2010-05-12 Thread siti Vi
I think, removing VPageBreaks and HPageBreaks can be done by setting FitToPage /Wide/Tall properties to : 1 Sub ClearPgBreasks() With ActiveSheet.PageSetup .Zoom = False .FitToPagesWide = 1 .FitToPagesTall = 1 End With End Sub On May 12, 8:33 pm, Sundarvelan N wrote: >

Re: $$Excel-Macros$$ Excel help : Remove Page Breaks Using VBA code

2010-05-13 Thread Sundarvelan N
Hi Siti, Thanks for your reply, But the below said is not working Below is the recorded code for removing pagebreaks ActiveSheet.VPageBreaks(1).DragOff Direction:=xlToRight, RegionIndex:=1 is any other code to remove page breaks *I need to set the Page break to end of the used last column.* *

$$Excel-Macros$$ Excel Help - using value of one procedure into other

2012-02-08 Thread Kasireddy Amarender
Hi Team, I would like to know if I can use the value of one procedure as input to the other procedure. For example: I have a user form, it has two command buttons, the first one is requesting for a file location(address/path) and the second does also requesting another file location (address/pa

Re: $$Excel-Macros$$ Excel Help - using value of one procedure into other

2012-02-08 Thread NOORAIN ANSARI
Dear Amarender, Please use it.. Public Sub Lfile_Name() Dim IFileName As Variant IFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls") MsgBox IFileName End Sub Public Sub SFile_Name() Dim SFileName As Variant SFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls") MsgB

Re: $$Excel-Macros$$ Excel Help - using value of one procedure into other

2012-02-08 Thread Kasireddy Amarender
Thanks Noorain! Simple and Superb! On 08/02/2012, NOORAIN ANSARI wrote: > Dear Amarender, > > Please use it.. > > Public Sub Lfile_Name() > Dim IFileName As Variant > IFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls") > MsgBox IFileName > End Sub > Public Sub SFile_Name() > Dim

Re: $$Excel-Macros$$ Excel Help - using value of one procedure into other

2012-02-08 Thread Kasireddy Amarender
Hi Noorain, I'm getting error ... Can you please try your code and check? thanks, Amar On 08/02/2012, Kasireddy Amarender wrote: > Thanks Noorain! > > Simple and Superb! > > On 08/02/2012, NOORAIN ANSARI wrote: >> Dear Amarender, >> >> Please use it.. >> >> Public Sub Lfile_Name() >> Dim IFile

Re: $$Excel-Macros$$ Excel Help - using value of one procedure into other

2012-02-08 Thread Kris
Hi Have you tred mine ? -- FORUM RULES (986+ members already BANNED for violation) 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 not be answered. 2) Don'

Re: $$Excel-Macros$$ Excel Help - using value of one procedure into other

2012-02-09 Thread Kasireddy Amarender
Hi Kris, I don't have your code, Can you please forward? Thanks, Amar On 09/02/2012, Kris wrote: > Hi > > Have you tred mine ? > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need He

Re: $$Excel-Macros$$ Excel Help - using value of one procedure into other

2012-02-09 Thread NOORAIN ANSARI
Dear Amar, Use below code with little bit correction in red color This code has been modify as per Krish's solution. Hope it will help to you See attached sheet... Dim IFileName As Variant Dim SFileName As Variant Public Sub Lfile_Name() IFileName = Application.GetOpenFilename("Excel Files

$$Excel-Macros$$ Excel Help needed - To convert date format in to Decimal Min

2012-02-24 Thread satish
Hi all, I have the data in below format, I try to convert the date format in to decimal Minutes. It comes well when the data below 24 Hrs, as soon as it exceed 24 Hrs, it gives a wrong fig. I used the below formula to get answers =HOUR(G91)*60+MINUTE(G91)+SECOND(G91)/60 gprs - national -

Re: $$Excel-Macros$$ Excel Help needed - To convert date format in to Decimal Min

2012-02-24 Thread Sam Mathai Chacko
*=G91*1440* Regards, Sam Mathai Chacko On Fri, Feb 24, 2012 at 4:53 PM, satish wrote: > Hi all, > > I have the data in below format, I try to convert the date format in > to decimal Minutes. It comes well when the data below 24 Hrs, as soon > as it exceed 24 Hrs, it gives a wrong fig. > > I u

Re: $$Excel-Macros$$ Excel Help needed - To convert date format in to Decimal Min

2012-02-24 Thread Sam Mathai Chacko
If you insist on using your original formula, try a more lengthier *=QUOTIENT(G91,1)*1440+HOUR(**G9**1)*60+MINUTE(**G9**1)+SECOND(**G9**1)/60* But *=G91*1440 will give the same answer* Regards, Sam Mathai Chacko On Fri, Feb 24, 2012 at 10:19 PM, Sam Mathai Chacko wrote: > *=G91*1440* > > Regar