Re: $$Excel-Macros$$ Re: Introduce Yourself !!

Welcome All :) . Enjoy Team XLS On Thu, Aug 6, 2015 at 11:36 PM, hari kumar wrote: > Access import from excel > Once u created one data table n data, if the same details are in other 4 > worksheets also. Use import from excel say append to existing data. > > Exact opt

Re: $$Excel-Macros$$ Re: VBA - Cell with comma separated serial numbers - send list to individual cells

You can also use Split function with array in VBA . Enjoy Team XLS On Thu, Jan 22, 2015 at 1:41 PM, Ashish Kumar wrote: > PFA > > > Regards > Ashish > > -- > 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

Re: $$Excel-Macros$$ Dates

let Start date in b2 and end date in b3 then in cell c2 =IF(($B$2+ROW(B1)-1)>$B$3,"",($B$2+ROW(B1)-1)) for very basic formula you can also use array or UDF if you want. . Enjoy Team XLS On Fri, Dec 12, 2014 at 5:48 PM, Mandeep Baluja wrote: > > Just for knowledge can

Re: $$Excel-Macros$$ Re: Shortcut required for this format !!

you are far better than me. > > On Wednesday, November 26, 2014 4:07:51 PM UTC+5:30, XLS S wrote: >> >> is this your question for help...do you want to check our knowledge? >> >> . >> >> Enjoy >> Team XLS >> >> >

Re: $$Excel-Macros$$ Re: Shortcut required for this format !!

is this your question for help...do you want to check our knowledge? . Enjoy Team XLS On Wed, Nov 26, 2014 at 4:02 PM, Mandeep Baluja wrote: > build this hope this help someone else. > > Sub Format_to_time() > > Selection.NumberFormat = "[h]:mm:ss" > Selection.Font.Bol

Re: $$Excel-Macros$$ Shortcut required for this format !!

Sorry, in excel there is no shortcut related specify format... you can use ctrl+shift+@ for general time format . Enjoy Team XLS On Wed, Nov 26, 2014 at 3:29 PM, Mandeep Baluja wrote: > [h]:mm:ss > > What is the keyboard shortcut to set the time in this format. > > --

Re: $$Excel-Macros$$ please provide the excel vba code for creating ms access table headers table

Dear Change your database name if you want to use another database . Enjoy Team XLS On Sun, Sep 28, 2014 at 12:25 AM, renuka chari wrote: > Dear sir, > > thanks for your valuable efforts > > while run the code i received the error message has been attached here

Re: $$Excel-Macros$$ Access Interview Question

Some general questions like 1) How many type of Join's and what is the difference between right,left and full join 2) what is cross tab 3) how to make pivot report or normal report like that . Enjoy Team XLS On Wed, Sep 17, 2014 at 2:04 AM, Rudra Thapa wrote: > Hi

Re: $$Excel-Macros$$ need macro add Rows

try enclosed . Enjoy Team XLS On Sat, Sep 13, 2014 at 4:13 PM, Ashish Bhalara wrote: > Dear experts, > > I have column with heading of SR and fillup with 1 to 10. > I need a macro to insert blank row under 10 with continue series > 11,12,13... > When run macro, message

Re: $$Excel-Macros$$ Help me Learning Vba and Macro

Hi Anil, Try yourself with below online tutorial. if you need help, you can revert. http://www.excel-pratique.com/en/vba.php . Enjoy Team XLS On Tue, Jul 29, 2014 at 1:46 PM, anil nim wrote: > Dear all, > > > I want to learn Macros and VBA from any professional, who

Re: $$Excel-Macros$$ US$ currency Format

try below [>=1000]$ ##\,##\,##\,##0;[>=10] ##\,##\,##0;##,##0 . Enjoy Team XLS On Fri, Jul 18, 2014 at 2:32 PM, Rohan Young wrote: > *Hi Experts* > > * how do get US$ currency format from 1234567 to 1,234,567* > > thanks > > -- > Are you =EXP(E:RT) or =NOT(EX

Re: $$Excel-Macros$$ Fwd: R Shop Data

try this .. only formula used nothing else . Enjoy Team XLS On Fri, Jul 18, 2014 at 10:30 AM, my excel wrote: > Sir, > i sent attached file of my friend ration shop > & pls see out put data > he wanted a macro to generate output data > pls help > > > regards: > Veeren

Re: $$Excel-Macros$$ How to learn VBA or MACORS myself at home???

Dear Delin, Please try below link. http://www.excel-pratique.com/en/vba.php Its a very useful and simple . Enjoy Team XLS On Mon, Jul 14, 2014 at 10:56 PM, 'DELIN FRANCIS' via MS EXCEL AND VBA MACROS wrote: > Dear All, > > Good day to you > > I am here with a small

Re: $$Excel-Macros$$ File conversion from BMP to XLS !!!!!

Hi, Search in google about MODI OR OCR in VBA Or check below link www.ozgrid.com/forum/showthread.php?t=147473 Sent from my iPhone On Dec 6, 2012, at 11:43 PM, "Indrajit $nai" wrote: > Hi All, > > Is it possible to convert a Bitmap image (BMP) into a Excel file through some > Macro? > >

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

Asa, Useful information for us Thanks Sent from my iPhone On Dec 1, 2012, at 9:06 AM, "Asa Rossoff" wrote: > P.S., Hanumant, here is a link with detailed instructions for using OneNote > for OCR: > > http://www.howtogeek.com/howto/14595/ocr-anything-with-onenote-2007-and-2010/ > > Asa >

Re: $$Excel-Macros$$ credit card due date formula

Use Text formula for month like =text(d2,"") and u can use text with iferror formula Sent from my iPhone On Dec 2, 2012, at 12:43 AM, Hemantpokharkar wrote: > Dear All > > Kindly help me to solve the problem > > I have a excel sheet were i have required a formula which will show me the

Re: $$Excel-Macros$$ Kindly Help

if this is a fix. then use countif see the attachment On Fri, Oct 21, 2011 at 8:51 PM, XLS S wrote: > please send the example... > > > On Fri, Oct 21, 2011 at 1:56 PM, karan 1237 wrote: > >> Dear All, >> >> Need your help to extract some specific text. &g

Re: $$Excel-Macros$$ Kindly Help

please send the example... On Fri, Oct 21, 2011 at 1:56 PM, karan 1237 wrote: > Dear All, > > Need your help to extract some specific text. > > Exam. > Govt I Grade College, Pashachapur Tq Hukkeri Dist Belgaum (2007) A/S/C/ > BBA. Enrol 139, Teacher 1, Principal-Dr S F Tangade. > > I need to ext

Re: $$Excel-Macros$$ Extract from date and time

for only date use int() and time use mod fuction On Tue, Oct 18, 2011 at 3:02 PM, Muhammad Arslan wrote: > > > > Dear Experts > I need to disjoint date and time form a text. Help me out how to tackle in > excel using formual. Text is following > > 4/11/2011 08:39:20 PM > > Help me out hoping for

Re: $$Excel-Macros$$ queary about a jpg file into excel or pdf file

Hey Karan, that's great yaar !!! ] On Wed, Oct 19, 2011 at 9:48 AM, karan 1237 wrote: > Hey Anil, > > Convert your image files in excel through online or download a software > from the website below : > > http://www.onlineocr.net/ > > > http://www.cometdocs.com/ > > > http://www.coolutils.com/O

Re: $$Excel-Macros$$ How to learn vba

firstly learn recording then play with recorded code http://www.youtube.com/watch?v=Ycab4OiPug0 http://www.internet4classrooms.com/excel_record_macro.htm http://office.microsoft.com/en-us/excel-help/record-and-use-excel-macros-HA001054837.aspx http://msdn.microsoft.com/en-us/library/7kyhdt1z%28v=v

Re: $$Excel-Macros$$ JOB MIS executive for Gurgaon

Hey All, Hiring still open kindly come for interview at AuthBridge Research Services Pvt. Ltd. Plot No. 123, II Floor, Udyog Vihar, Phase IV – Gurgaon – 122 016 HARYANA, INDIA On Tue, Sep 6, 2011 at 11:00 PM, XLS S wrote: > Hey All, > > > > We need MIS Exe having good knowled

Re: $$Excel-Macros$$ Help

Kindly send text file.. On Sat, Oct 15, 2011 at 5:55 PM, santhu wrote: > Hi, > > How to extract a text file data to an excel sheet. > > Ex: Sl.no FirstName MiddleName LastName Place > 1 ABC abc India > 2 DEF def

Re: $$Excel-Macros$$ New Microsoft MVP Mr. Ayush Jain (2nd Times)..

Congratulation Ayush. On Sun, Oct 2, 2011 at 8:40 PM, NOORAIN ANSARI wrote: > Dear Group, > > Our Group Manager Mr. Ayush Jain has been awarded the Microsoft MVP award > for the 2nd year in row... > > Congrate Ayush > -- > Thanks & regards, > Noorain Ansari > *http://excelmacrowo

Re: $$Excel-Macros$$ Most Helpful Member Sep'11 - Noorain Ansari

om & www.noorain-ansari.blogspot.com > > *Noorain, Many thanks for all your great support to group. Keep it up* > > *Thanks to Don Guillett, Bheema, Venkat, GoldenLance, Ashish Koul, XLS S , > Paul and other folks for helping excel enthusiasts volun

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

Hey Rajan Babu, which page? On Sat, Oct 1, 2011 at 11:52 AM, rajan verma wrote: > HI, > Please visit this Page to know more about Worksheet Events.. > > Regards > Rajan > > On Sat, Oct 1, 2011 at 10:53 AM, Mr excel wrote: > >> HI group, >> >> This is a Great & amazing group in learning exce

Re: $$Excel-Macros$$ date format in Excel

Select cell or column then right click format cell ...then in number tab go to date and select date format then ok On Fri, Sep 30, 2011 at 11:03 AM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > Dear > > I like to put the date format in Excel as "dd/mm/",

Re: $$Excel-Macros$$ Numbers errors

Hey Anil, Microsoft Excel stores numbers with up to 15 digits of precision. If a number contains more than 15 significant digits, Microsoft Excel converts the extra digits to zeros (0). You have 2 options:- You already know one of them Put an apostrophe (') in front of the number. That's OK for

Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 12 Messages in 6 Topics

gt;[1 Update] >> >> Topic: [No >> Subject]<http://groups.google.com/group/excel-macros/t/6026fe9fd49d7639> >> >>naanu v Sep 22 09:20PM +0530 >> ^<#132961b47c59cc74_132939250e1a5959_digest_top> >> >>kindly provide macro for Index

Re: $$Excel-Macros$$

please specify requirement and condition On Thu, Sep 22, 2011 at 9:20 PM, naanu v wrote: > kindly provide macro for Index formula > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for ti

Re: $$Excel-Macros$$ Convert txt file to xls

Use export and import function or right click on ur txt file and open with excel On Thu, Sep 22, 2011 at 4:20 PM, Sandeep Pathak wrote: > Dear Team, > > Is there any way to convert text file to excel, except change of > extension name... > > Please advise... > > Regards, > Sandeep > > -- > >

Re: $$Excel-Macros$$ Converting date with time to date withOUT time

use =int() function ""The *Int* function returns the integer portion of a number."" On Fri, Sep 16, 2011 at 1:39 AM, Mich Mac wrote: > I am exporting a file from online which automatically includes dates. > This interferes with my Pivot tables. How do I convert an entire > column of dates with

Re: $$Excel-Macros$$ *Comparing two columns and sum unique values in excel *

Use sumif or put pivot tableplease find the attachment.. On Tue, Sep 13, 2011 at 7:15 AM, Prabhu wrote: > Hi All, > > I need to compare two columns and sum the unique value. > > Example: > > Apple 10 > Orange 5 > Apple 20 > Mango 25 > Orange 15 > Mango 7 > > > Result > > Apple 30

Re: $$Excel-Macros$$ **DAT to Excel conversion**

try this Sub copy_files() Dim ServerA As String Dim ServerB As String ServerA = "C:\temp\filename.dat" ServerB = "C:\temp\filename2.xls" FileCopy ServerA, ServerB End Sub On Tue, Sep 13, 2011 at 7:30 AM, Prabhu wrote: > Hi All, > > How to convert DAT to Excel file. > > Now i am just conver

Re: $$Excel-Macros$$ Loop Practice in VBA

Venkat Ji... Google Baba Ki Jai http://msdn.microsoft.com/en-us/library/ezk76t25%28v=vs.71%29.aspx On Fri, Sep 9, 2011 at 10:47 AM, Venkat CV wrote: > Dear All, > > Find attached some Examples With Loops...in VBA it will useful > > *Best Regards,* > *Venkat * > *Chennai* > *M

Re: $$Excel-Macros$$ calculating age with months

Great!!! But Result not. On Fri, Sep 9, 2011 at 10:39 AM, Venkat CV wrote: > Hi Varun, > > See if Helps Attached... > > *Best Regards,* > *Venkat * > *Chennai* > *My Linked in profile > * > > > > On Thu, Sep 8, 2011 at

Re: $$Excel-Macros$$ calculating age with months

Hey Varun , thy this =DATEDIF(A1,TODAY(),"Y") & " Years, " & DATEDIF(A1,TODAY(),"YM") & " Months, " & DATEDIF(A1,TODAY(),"MD") & " Days" On Thu, Sep 8, 2011 at 1:57 PM, VARUN CHAWLA wrote: > > > Can any body guide me the formula to calculate the Age in excel with months > and days. > > Regards

Re: $$Excel-Macros$$ Reasons for increase in excel file size

Hey Amit, Try this *Method 1:* 1. Open the Excel file 2. Then save the Excel file in html format 3. Then save the html document into xls but as another name *For spreadsheets with only text:* *Method 2:* 1. Open the Excel file 2. Save the Excel file as xml format 3. Save the

Re: $$Excel-Macros$$ Conditional Formatting Excel 2007

Hey , Please send the attachment... try the below link http://www.contextures.com/xlcondformat02.html http://www.wikihow.com/Apply-Conditional-Formatting-in-Excel On Wed, Sep 7, 2011 at 1:30 PM, zp18 wrote: > A1=the name of an employee, defined name is "Suspect" > A2= an amount of money, defi

$$Excel-Macros$$ JOB MIS executive for Gurgaon

uhan 9911868518 -- ..... XLS S Pagal Bana Dey -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN g

Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - August'11

August 2011 and helped many people through his > expertise. He has been consistent contributor to this excel forum and has > acheived this recognition for second time consecutively. > > Thanks to Noorain, Venkat, Sunny(XLS S), Don Guillett, and other folks for > helping excel enthusi

Re: $$Excel-Macros$$ replacement for query expression "Right ([F2],3") ????

Hey Manager Sir, Use proper syntax. like right([tablename.columnsname,num_char] left([tablename.columnsname,num_char] On Mon, Sep 5, 2011 at 4:03 AM, ScubaDude_ITmanager < blackjeepfinanc...@gmail.com> wrote: > Okay, its and Access question but may be used in both. "Right ([F2], > 3") is use

Re: $$Excel-Macros$$ Help to create summary table count unique

Hey Satvik, please find the below link http://www.ozgrid.com/VBA/conversion-functions.htm On Mon, Sep 5, 2011 at 9:28 AM, wrote: > ** Hi guru, > > Plz help me how to convert number in to a text. > > Regards, > Satvik > > Sent from BlackBerry® on Airtel > -- > *From:

Re: $$Excel-Macros$$ scrolling and blinking label caption

Userforms have 6 properties that relate directly to ScrollBars. Set the .ScrollBars property to 2 Now, set the .ScrollTop to 0 (So it will appear always at the top of the form) and finally, you must change the .ScrollBarHeight to something... for example, If the UserForm height is 100, try settin

Re: $$Excel-Macros$$ extracting data from a datasheet

send the attachment in excel-macros@googlegroups.com email id On Sat, Sep 3, 2011 at 9:41 AM, Bheema Shankar wrote: > how to attach my file.? > > On Sep 1, 8:08 pm, ashish koul wrote: > > Can you attach the sample file > > > > On Thu, Sep 1, 2011 at 4:16 PM, Bheema Shankar >wrote: > > > > > > >

Re: $$Excel-Macros$$ any short key to remove double add.

Hey Kannan, please find the below link http://office.microsoft.com/en-us/excel-help/delete-duplicate-rows-from-a-list-in-excel-HA001034626.aspx On Tue, Aug 30, 2011 at 5:57 PM, kannan excel wrote: > Hi NOORAIN ANSARI, > > Pls tell wat is this.?? > if you feel free explain me. > > Regards > V.

Re: $$Excel-Macros$$ Re: Sumproduct using VBA

Hey Chandra, try this Function xxx(x, y) Dim a, b, c As Range a = Range("a4:a14") ' contains text b = Range("b4:b14") ' contains text c = Range("c4:c14") ' contains values Range("a20") = Application.SumProduct((a = x) * (b = y) * c) End Function On Tue, Aug 30, 2011 at 11:56 AM

Re: $$Excel-Macros$$ Pivot table to remain intact - even if data table is removed

then ..press Alt + D +P +B and select new range ... On Mon, Aug 29, 2011 at 2:59 PM, Amit Desai (MERU) wrote: > That’s true… but what if I wants to refresh the Pivot table with new > data? > > ** ** > > Best Regards, > > Amit Desai > > ** ** > > ** ** > > *From:* excel-macros

Re: $$Excel-Macros$$ Need Formula remain intact even if source is removed...

rom: Amit Desai (MERU) [mailto:amit.de...@merucabs.com] > Sent: Saturday, August 20, 2011 6:05 PM > To: 'excel-macros@googlegroups.com' > > Subject: RE: $$Excel-Macros$$ Very slow performance by Excel file > > That's true. My memory usage shows more than 500 MB u

Re: $$Excel-Macros$$ how to change msword file into excel

Hey Anil, this post sent by mr.Bob If you want to import a text file into Excel and have that data be in multiple columns once it's in Excel, it must be either fixed width or delimited. Fixed-width means that new columns occur at the same place on every line. That's not very useful for most info

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

Hey Jocky, please find the attachment. On Sun, Aug 28, 2011 at 7:08 PM, jocky Beta wrote: > Hi, > > Can you create same for me? > > The Formula is given below. > >*FORMULA - A = P* (1 + r/12)12 > >*P* is the principal (the initial amount you borrow or deposit) - * >

Re: $$Excel-Macros$$ Some Sorting Technique

well done rajan On Sat, Aug 27, 2011 at 6:48 PM, Rajan_Verma wrote: > Hi Group, > > Refer the attached sheet with some Data Sorting Example. Hope you will like > it > > ** ** > > Rajan. > > ** ** > > -- > > -

Re: $$Excel-Macros$$ Conditional Formatting

this problem with formula only. > > Thanks, > > Zafar Iqbal > > On Thu, Aug 25, 2011 at 2:17 PM, XLS S wrote: > >> kindly put 3 condition it self and then send file. >> >> try this code >> >> Private Sub Worksheet_Change(ByVal Target As Range) >&

Re: $$Excel-Macros$$ Text to Numbers

Hey Amit, open this e-mail in internet explores and then copy past On Fri, Aug 26, 2011 at 7:17 PM, Amit Desai (MERU) wrote: > Dear Friends, > > ** ** > > I have recd the following data in email body itself & wants to convert them > in number to have sum of it. Let me know how to convert th

Re: $$Excel-Macros$$ Pivot Table Percent of Column...

try formula please find attachment... On Thu, Aug 25, 2011 at 8:04 PM, Robert Jacobs wrote: > Thanks in advance experts!!! This is very complicated to explain, but > I'll give it a go: > > I have data (Invoice#, Invoice Year, Cat1 Sales, Cat2 Sales, Cat3 > Sales), and need to find the pe

Re: $$Excel-Macros$$ Re: Cut Data from Rows and Paste into Columns

alos try this link http://www.vbaexpress.com/kb/getarticle.php?kb_id=144 On Fri, Aug 26, 2011 at 7:15 PM, GreenBriar wrote: > Transpose would not work because every 4th record (or row) would need to go > back to the first column, next row. > > original data could be in either an excel spreadshee

Re: $$Excel-Macros$$ Cut Data from Rows and Paste into Columns

Use pastespecial and transpose or try below link http://www.vbaexpress.com/kb/getarticle.php?kb_id=144 On Fri, Aug 26, 2011 at 9:25 AM, GreenBriar wrote: > I have a series of spreadsheets that have data in them that needs to > be formatted into 3 columns instead of one column. > > The data in

Re: $$Excel-Macros$$ Fill empty cells with zero

hey Usha, if blank cell come thru by formula then use if condition other wise use find and replace function On Fri, Aug 26, 2011 at 12:40 PM, Usha Gusain wrote: > We have some blank cells in excel (2007), which we want to fill with zero. > what is the formula for the same? > > With regards, > Us

Re: $$Excel-Macros$$ BarHide

Hey Udin, try this code Sub HideHeadings() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets ws.Activate ActiveWindow.DisplayHeadings = False Next ws End Sub On Fri, Aug 26, 2011 at 2:04 AM, Udin Haeruddin wrote: > how about hiding row and column heading for all sheet using

Re: $$Excel-Macros$$ MIS Opening

for which location.. On Thu, Aug 25, 2011 at 10:16 PM, Rahul Gandhi wrote: > I Have 2 Off-roll Opening with me, One in Videocon as an Off-roll > Employee and One in Master Franchisee of United Colors of Benetton. > > Package 2.5-3 Lac. > > Please call @ 9711772297 > > > Regards > Rahul Gandhi >

Re: $$Excel-Macros$$ Re: Copy the Last Row (Values) of Multiple Sheets to a Summary Sheet

Hey Noorain, it's perfectly working On Thu, Aug 25, 2011 at 3:43 PM, NOORAIN ANSARI wrote: > Dear Frederic, > > This function LOOKUP(9^9,A:A) is not working.. > We are unable to find Adject Output, it is showing #N/A error.. > -- > Thanks & regards, > Noorain Ansari > *http://noorain

Re: $$Excel-Macros$$ Fwd: regaurding popup XLS

Hey Nandkumar, where is due date column. and use conditional formation for highlighting On Thu, Aug 25, 2011 at 10:07 AM, Nandkumar kakvipure < nandkumar.hindust...@gmail.com> wrote: > > > -- Forwarded message -- > From: shridhar pandit > Date: Thu, Aug 18, 2011 at 12:32 PM > S

Re: $$Excel-Macros$$ Conditional Formatting

kindly put 3 condition it self and then send file. try this code Private Sub Worksheet_Change(ByVal Target As Range) Set I = Intersect(Target, Range("B2:B8")) If Not I Is Nothing Then Select Case Target Case 0 To 100: NewColor = 37 ' light blue Case 101 To 200: NewColor = 46 '

Re: $$Excel-Macros$$ Error - "**PASTE EXCEL CELLS HERE**"

please send vba code... On Wed, Aug 24, 2011 at 7:52 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hello, > > I am getting "**PASTE EXCEL CELLS HERE**" error(Range Not found) when I > send mail by using vba code. Please let me know whats the error is. > > Thanks, > > Chandru > >

Re: $$Excel-Macros$$ User Defined formula in Excel

Hey Atul, Please find the below links, http://www.ozgrid.com/VBA/Functions.htm http://www.codeproject.com/KB/macros/excelmvf.aspx http://www.vertex42.com/ExcelArticles/user-defined-functions.html On Tue, Aug 23, 2011 at 11:42 PM, Atul vishwakarma wrote: > Hi Rajan, > > Due to some reason I was

$$Excel-Macros$$ Job

*Experience required for the Job:* 2.5 - 5 years *Job Location:* Kolkata *Dear Candidate,* Hi, Greetings for the day! Our records show that you are an experienced IT professional with experience in VBA which matches to our requirement. This experience is relevant to one of my current openings. A

Re: $$Excel-Macros$$ Very slow performance by Excel file

la caln as > manual..but still performance is very slow > > Best Regards, > Amit Desai > > Assistant Manager, Fleet MIS (Corporate) > Desk No.: 022 40520129 > Cell No.: 9867232534 > > -Original Message- > From: excel-macros@googlegroups.com [

Re: $$Excel-Macros$$ Excel Filter Data Help required

use this... =INT(ROUND((BC3-BD3),1)) then put filter On Mon, Aug 22, 2011 at 10:21 PM, rajan verma wrote: > > see if it helps > > On Mon, Aug 22, 2011 at 10:00 PM, XLS S wrote: > >> because it's not a right condition not equal to 0.00..please try >>

Re: $$Excel-Macros$$ Excel Filter Data Help required

because it's not a right condition not equal to 0.00..please try it self ...just copy and paste spicel and check cell value.. On Mon, Aug 22, 2011 at 9:50 PM, KAUSHIK SAVLA wrote: > Hi All, > > I want hello in filtering data. > > In attached file if I am applying in Column BE Filter, the

$$Excel-Macros$$ Job

The sender of this email is registered with Naukri.com as Helios Matheson It Ltd. *Dear Candidate,* HI, Greetings from Helios & Matheson IT Ltd., We are a leading healthcare focused IT services company. We are a public limited company listed in NASDAQ, NASCOM, and BSE. We provide consulting and

Re: $$Excel-Macros$$ Need formula for more than three criteria

Hey Anwar, It would be very helpful if your data could result in an actual case with a real example. On Mon, Aug 22, 2011 at 2:26 PM, Anwar Mohd wrote: > Hi Rajan, > > I need the Summary tab in Quarter wise only. > > Regards > > Anwar > > > > -- Forwarded message -- > From: Anw

Re: $$Excel-Macros$$ TAT reporting for assignment

Hey Amit, Please find the attachment. On Sat, Aug 20, 2011 at 10:53 AM, Amit Desai (MERU) wrote: > Thanks this helped… > > ** ** > > Now what if I need, TAT range (0 – 2 day, 3 – 7 days, etc…) next to > “Completion time in Days” column in the attached file? > > ** ** > > Best R

Re: $$Excel-Macros$$ How to Copy a Cell Comment

Hey N Pradhan, please find the below link http://www.contextures.com/xlcomments03.html On Fri, Aug 19, 2011 at 4:11 PM, N Pradhan wrote: > ** > Hi, > > How do you copy Cell Comments, Please help. > > Regards. > > -- > > --

$$Excel-Macros$$ Learn What-IF-Analysis

What-if analysis is the process of changing the values in cells to see how those changes will affect the outcome of formulas on the worksheet. Three kinds of what-if analysis tools come with Excel: scenarios, data tables, and Goal Seek. 1) Scenarios and data tables take sets of input values and d

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

hey rajan, what is the mean of 1440/60? On Fri, Aug 19, 2011 at 7:22 PM, Rajan_Verma wrote: > Try this > > > > =((C2+D2)-(A2+B2))*1440/60 > > > > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of jayendra gaurav > Sent: Friday, August 19, 2011 1:28 PM > To

Re: $$Excel-Macros$$ ragarding FIFO METHOD in Ms Access

pleas find the below link.. http://forum.codecall.net/visual-basic-programming/4676-how-implement-lifo-fifo-method.html On Fri, Aug 19, 2011 at 4:06 PM, Sanjib Chatterjee wrote: > Dear Sirs, > > anybody please help regarding FIFO method in Ms Access 2003.  Please see the > attachment.  I want

Re: $$Excel-Macros$$ Very slow performance by Excel file

Try this... Go to "tools" -- "options" -- select "Calculation" tab -- check on "manual" and make sure you check on "recalculate before save". this is going reduce the time taken by excel to calculate the formulae present in your sheet. hence increasing the performance. I'm sure that you have lot

Re: $$Excel-Macros$$ making pivot table report filters interdependent

pleas find the below link http://office.microsoft.com/en-us/excel-help/filter-data-in-a-pivottable-or-pivotchart-report-HA010167795.aspx it may be help for you..and if it not help for you please send the sample sheet... On Fri, Aug 19, 2011 at 11:43 AM, marston.go...@allstardirectories.com wro

Re: $$Excel-Macros$$ Need your help in Vlookup formula.....

Hey Inderjit, please find the attachment... On Fri, Aug 19, 2011 at 1:02 AM, Indrajit $nai wrote: > Hi All, > I need your small help in Vlookup formula. I have attached a file with this > mail, where you can see  2 columns in the left. One is Qty. another is Sr. > no. > Now I want to search Sr.

Re: $$Excel-Macros$$ Check box to highlight Row if Checked

try thihs Private Sub CheckBox1_Click() If CheckBox1.Value = True Then Range("A2:B2").Select If CheckBox1.Value = False Then Range("A1:B1").Select End Sub On Fri, Aug 19, 2011 at 3:09 AM, Bob wrote: > Please Help with code! > If CheckBox1 is Checked then Highlight Sheet2 Row 2 Column A & B > T

Re: $$Excel-Macros$$ Countdown

Hope this will Help You. On Thu, Aug 18, 2011 at 10:11 PM, XLS S wrote: > which type downward or upward? and duration ? > > > > On Thu, Aug 18, 2011 at 7:14 PM, Dinesh Prajapati > wrote: >> Hi, >> >> Can some one help me to create countdown ( Day-Hour-Min

Re: $$Excel-Macros$$ Countdown

which type downward or upward? and duration ? On Thu, Aug 18, 2011 at 7:14 PM, Dinesh Prajapati wrote: > Hi, > > Can some one help me to create countdown ( Day-Hour-Min-Sec) in excel. > > Rgds > Dinesh > > -- > -- >

Re: $$Excel-Macros$$ MIS executive needed

Dear Amit, Can you share the JD and also Job Location. On Thu, Aug 18, 2011 at 7:13 PM, Amit Desai (MERU) wrote: > Dear All, > > > > We need MIS executive in our organization. If any one is interested, kindly > send me your CV on my official ID. > > > > Best Regards, > > Amit Desai >

Re: $$Excel-Macros$$ Vlookup against the value generated from formula

thanks noorain.. On Thu, Aug 18, 2011 at 2:27 PM, NOORAIN ANSARI wrote: > Please see below link. > http://www.xldynamic.com/source/xld.SUMPRODUCT.html > > On Thu, Aug 18, 2011 at 2:18 PM, XLS S wrote: >> >> Ok...can you give m

Re: $$Excel-Macros$$ Vlookup against the value generated from formula

,4,FALSE) > > On Thu, Aug 18, 2011 at 1:55 PM, XLS S wrote: >> >> Hey Noorain, >> >> can you tell me what is the mean of ++ and -- >> >> >> >> >> >> On Thu, Aug 18, 2011 at 10:20 AM, NOORAIN ANSARI >> wrote: >> > Dear Sub

Re: $$Excel-Macros$$ Vlookup against the value generated from formula

Hey Subhash, also use vlookup with value function, On Mon, Jul 25, 2011 at 6:37 PM, Subhash Yadav wrote: > When I m trying to use to formula VLOOKUP against any formula generated > value, there is error. > Please suggest suitable method for the same, as I have to take many of the > value based n

Re: $$Excel-Macros$$ Vlookup against the value generated from formula

Hey Noorain, can you tell me what is the mean of ++ and -- On Thu, Aug 18, 2011 at 10:20 AM, NOORAIN ANSARI wrote: > Dear Subhash, > > Please try it... > =VLOOKUP(--C5,Sheet3!$A$1:$D$403,4,FALSE) > > > -- > Thanks & regards, > Noorain Ansari > http://noorain-ansari.blogspot.com/ > On Mon, Ju

Re: $$Excel-Macros$$ Request for Directory Audit Macro

Great Job Rajan. On Thu, Aug 18, 2011 at 10:02 AM, Rajan_Verma wrote: > Try the attached Workbook, > > > > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of dguillett1 > Sent: Thursday, August 18, 2011 2:54 AM > > To: excel-macros@googlegroups.com > Subject

Re: $$Excel-Macros$$ Uniques Values

that's Great Haseeb. thnx On Thu, Aug 18, 2011 at 12:00 AM, Haseeb Avarakkan wrote: > Hi Sundarvelan, > > Since you are dealing with valid numbers use SMALL function. > > in G3 enter, > > =MIN(B:D) > > G4, copy down. > > =IFERROR(SMALL(B:D,COUNTIF(B:D,"<="&G3)+1),"") > > HTH > Haseeb > > For

Re: $$Excel-Macros$$ Uniques Values

Hey Sundarvelan, please try to use multiple range pivot. On Wed, Aug 17, 2011 at 4:20 PM, Sundarvelan N wrote: > Hi Freinds, > > Please help me to get the uniques values. > Thanks > N.Sundarvelan > 9600160150 > > -- > -

Re: $$Excel-Macros$$ UNIQUE values in Array

Hey Yogi, please find the attachment.,... there is a many way to put reverse vlookup.. like..IF count with choose functions,index with match function,lookup function,SUMPRODUCT function On Wed, Aug 17, 2011 at 12:03 PM, yogi yogi123 wrote: > > what is reverse vlookup.can u give one example.

Re: FW: $$Excel-Macros$$ Workbooks Consolidation Macro

Hey Satish, please see the below link and follow instructions http://support.microsoft.com/kb/214081 On Wed, Aug 17, 2011 at 11:36 AM, Satish Bandaru wrote: > hi experts > please help me.plz find the atachment > thanks in advance > > -- >

Re: FW: $$Excel-Macros$$ Update Data source range & converting "0" to "-"

> > Best Regards, > Amit Desai > > Assistant Manager, Fleet MIS (Corporate) > Desk No.: 022 40520129 > Cell No.: 9867232534 > > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of XLS S > Sent: W

Re: $$Excel-Macros$$ What is done?

ok, got it, thnx On Wed, Aug 17, 2011 at 5:16 AM, XLS S wrote: > hey All, > > please look into the attachment and say how to use table function with array > (table is a function or what ?) > > cell F11 = {=TABLE(

$$Excel-Macros$$ What is done?

hey All, please look into the attachment and say how to use table function with array (table is a function or what ?) cell F11 = {=TABLE(,E2)} what is this .. --

Re: $$Excel-Macros$$ How to use Multiple criteria in DSUM function...

Hey Sharma, Please find the attachment On Tue, Aug 16, 2011 at 12:53 PM, B Sharma wrote: > Hello to Excel Experts and other users of this group. > > I've been looking everywhere   about how to put several criteria in > different cell ranges in: > > DSUM(database, field, criteria). > > I

Re: FW: $$Excel-Macros$$ Workbooks Consolidation Macro

hey Vikas, try to use batch file open notepad...paste below code then save as copy.bat Copy *Comman file name*.xls output.xls exit On Tue, Aug 16, 2011 at 5:25 PM, vikas gupta wrote: > > Dear Sir, > Sir I have a query that by using this macro fil

Re: $$Excel-Macros$$ AutoHide

Very good venkat.. On Tue, Aug 16, 2011 at 5:03 PM, Venkat CV wrote: > Hi Sajid, > > Look AttachedSee if it helps... > > Best Regards, > Venkat > Chennai > On Tue, Aug 16, 2011 at 4:03 PM, SAJID MEMON wrote: >> >> Hi all Experts, >> >> I have a little doubt but may be cha

Re: $$Excel-Macros$$ re: required phone book in excel

Hey Harsh, Please find the below link http://office.microsoft.com/en-us/templates/CT010144671.aspx On Tue, Aug 16, 2011 at 1:37 PM, harsh shah wrote: > dear all, > > anybody having phone book software in excel ?? > i.e. name contact details phone numbers up to 3 or 4 numbers > and important

Re: $$Excel-Macros$$ Making Excel Project Unviewable

can u send the file.. On Sat, Aug 13, 2011 at 2:50 AM, hanumant shinde wrote: > nobody has any idea abt it? > > > > > - Original Message >> From: hanumant shinde >> To: Excel Group >> Sent: Fri, 12 August, 2011 3:30:08 AM >> Subject: $$Excel-Macros$$ Making Excel Project Unvie

  1   2   3   >