Re: $$Excel-Macros$$ Cell Capacity & filters

Hi Iqbal, I don't know the way out. However, though it does not show up because of its length, you can still do a text filter with Containg option and search for something unique in that string to show that up in the result. Regards, Andy On Mon, Jul 5, 2010 at 5:04 PM, Iqbal Muneeb wrote: > H

Re: $$Excel-Macros$$ Help needed

Hi Rajender, Use the following VBA Code: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim rg As String MsgBox Target.Address & " has been selected" 'displaying the selected cell address rg = Split(ActiveCell.Address, "$")(1) & 5 'getting the column name and createing the range col

Re: $$Excel-Macros$$ Problem facing

Hi Sajid, Would it be possible for you to share a sample sheet Regards, Aindril On Mon, Jul 5, 2010 at 10:23 AM, SAJID MEMON wrote: > Hi > > Dear I want in excel, when i press enter key cursor should go to particular > cell example: my cursor is at A1 and after press enter it should go to D15

Re: $$Excel-Macros$$ Hi, need your help - urgent

Hi Rajender, I am not quite sure how would you want to do it. However there is a very simple solution mentioned in the link below, which almost does what you are trying to achieve. http://www.excelforum.com/excel-general/713781-display-an-image-based-on-a-cells-value.html

Re: $$Excel-Macros$$ Help reqd for using SUMIF along with a variable (month)

Hi Radhe, PFA the attached solution Regards, Andy On Wed, Jun 30, 2010 at 12:44 PM, Radhe Sham wrote: > Hi Group > > I have data which has repeated values for a set of product every month for > 12 months > > Need the output as total for each product ( sumif formula helps here) > > But the requ

Re: $$Excel-Macros$$ INFORMATION REQUIRED

Hi Magan, Can u please send a sample file Regards, Andy On Mon, Jun 28, 2010 at 8:09 AM, CA MAGAN DEEP AGGARWAL < magandeepc...@gmail.com> wrote: > DEAR MEMBERS > > I WANT TO CREATE A WORKBOOK CONTAINING DIFFERENT WORKSHEETS. FIRST > WORKSHEET WILL BE A MASTER WORKSHEET AND ALL OTHER WORKSHEETS A

Re: $$Excel-Macros$$ Index match multiple

Hi, Would it be possible for you to attach a sample sheet? Regards, Andy On Sat, Jun 26, 2010 at 4:34 AM, Nadine S wrote: > I have two worksheets: > Sheet 1 contains extracted data from an application > Sheet 2 is my working file > > I need to match 3 different columns in sheet 2 to those colu

Re: $$Excel-Macros$$ Urgent Help needed regarding using macro

Hi Dilip, This is an excellent solution you have provided.. Hats off to you for keeping it so simple.. Cheers, Andy On Fri, Jun 25, 2010 at 4:48 PM, Dilip Pandey wrote: > Hi Mathan, > > Attached file has been solved per your requirements. Please let me know if > it solves your problem else ge

Re: $$Excel-Macros$$ Formula Help Required Urgent

Hi Venkat, This can be achieved using array formulas in Excel. Suggest you to look into the discussion in the attached link that should resolve your issue: http://www.mrexcel.com/forum/showthread.php?t=312142 Regards, Andy On Thu, Jun 3, 2010 at 6:57 PM, Venkatesan c wrote: > Dear Group, > >

Re: $$Excel-Macros$$ From Excel send Email to multiple user separately

You Can use Mailmerge On Thu, May 27, 2010 at 3:23 PM, vibs wrote: > Dear Members, > > I have to send the emails using Microsoft Outlook to multiple users > individually (And not to all of them in one go) with their respective > records. For example, > > Users Pending transactions Email id >

Re: $$Excel-Macros$$ Convert 2007 to 2003

Hi Harry, Downliad teh compatibility from the link below: http://www.microsoft.com/downloads/details.aspx?FamilyId=941B3470-3AE9-4AEE-8F43-C6BB74CD1466&displaylang=en Alternatively you can use Open Office.. which is Free and has almost all the features of MS Office Regards, Aindril On Sun, May

Re: $$Excel-Macros$$ PAID LIST TRACER

Hi Siva, It would be great if you can send a sample file explaining the issue. REgards, Andy On Fri, May 28, 2010 at 3:37 PM, siva wrote: > Dear Team, > > Please help me . I HAVE LAST YEARS STUDENT PAID LIST . > i have NEW paid list of students NOW I WANT TO COMPARE IT THE BOTH > PAID LIST.

Re: $$Excel-Macros$$ Congratulations : We are 7000 today

Hi All Members Congrats to all and specially Ayush..for managing it so beautifully!!! Also to all active members.. who have selflessly kept this group going.. Looking forward for more and more achievements Cheers!!, Andy On Mon, May 24, 2010 at 8:26 PM, Indrajit $nai wrote: > Hi > All Grou

Re: $$Excel-Macros$$ Verifying Text Box input from excel spreadsheet prior to continuing

Hi Andy, The solution in the following links should be a good point to start for you.. http://www.ozgrid.com/forum/showthread.php?t=57799 http://www.mrexcel.com/forum/showthread.php?t=81826 Regards, Aindril On Mon, May 17, 2010 at 3:03 PM, Andy McGooner wrote: > Hi All, > > Apologies but i am

Re: $$Excel-Macros$$ Excel Wonders(Excel formulas)

Hi Rajesh, A nice one for quick reference... Thanks buddy Regards, Andy On Fri, May 14, 2010 at 12:33 AM, Rajesh Nair wrote: > Hi All, > > Please find attached Excel formula book . > This may help. > > Regards, > Rajesh. Nair > > -- > > -

Re: $$Excel-Macros$$ TOUGH QUESTION

Hi azhar, Are these images stored somewhere in your local disk or online? Regards, aindril On Fri, May 7, 2010 at 10:46 AM, Azhar Rai wrote: > Dear Members > > Can someone help me create a trick related to mail merge in Office > 2007/2010. > > I want to mail merge pictures FROM an excel sheet

Re: $$Excel-Macros$$-Macro to Prepare Letters

Hi atul, Why dont u use mail merge. Regards, Andy On Fri, May 7, 2010 at 12:38 PM, Atul Kesaria wrote: > Hello Team, > > I am looking at a macro to write letter in word (a predefine letter format) > with certain field to be picked from an excel-sheet source. > > Request you to send me macro cod

Re: $$Excel-Macros$$ Date formatting

Hi Azhar, PFA the solution Regards, Andy On Fri, May 7, 2010 at 10:27 AM, Azhar Rai wrote: > Dear Members > > I was just trying to calculate a similer thing but could not. Please help > me too. > > I need to add a certain number of years to a date and get the resulting > date. HOW? > > Thanks

Re: $$Excel-Macros$$ Date formatting

Hi Goldie, PFA the solution. Regards, Aindril On Thu, May 6, 2010 at 4:43 PM, dare2gold wrote: > Dear Members,., > > i want to know how to get a later date just by inserting present date > into one column and getting the date we desire just by typing the no > of days > > suppose i entered

Re: $$Excel-Macros$$ Help needed to calculate incentive

Hi Rajeev, Sorry for replying late.. Please send the sample file.. Regards, Andy On Wed, May 5, 2010 at 1:10 AM, Rajeev Nandan wrote: > Dear Group Member, > Please help me to calculate incentive for each technician. I have > tried to apply "countifs" but could not succeeded. Please suggest if >

Re: $$Excel-Macros$$

Hi Dheeraj, You have done half of the work...You have sorted the data as per the date and item. Now the only thing to do is to add the following formula in Sheet 2 in Column Qty =VLOOKUP(A4,Sheet1.$B$3:$C$27,2,0) What this does is it picks the first instance of the Item it encounters in the rang

Re: $$Excel-Macros$$ Extracting numbers from a string

Hi, There are two methods.. one using formula.. and another using macros Please check... http://office.microsoft.com/en-us/excel/HA011549011033.aspx - For Formula http://www.ozgrid.com/VBA/ExtractNum.htm - For Macro Please let me know if you need any further help.. Regards, Aindril On Sun, Apr 25,

Re: $$Excel-Macros$$ OFFICE ERR : SELECTION IS LOCKED

Vikas, Download and install the UBit menu http://www.ubit.ch/software/ubitmenu-languages/#c205 U can download the free for personal use...option Regards, andy On Fri, Apr 9, 2010 at 1:03 PM, vikas gupta wrote: > DEAR EXCEL GURUS > > I HAVE A PROBLEM IN EXCEL AND WORD 2007 > THERE IS NO MENU OP

Re: $$Excel-Macros$$ Network days with a tweak

This is another alternative solution: http://www.mrexcel.com/forum/showthread.php?t=86072 On Wed, Apr 7, 2010 at 3:29 PM, Aindril De wrote: > OOps.. Sorry missed the link... > Here is the link: > http://spreadsheets.about.com/od/excelfunctions/qt/080321networkda.htm > >

Re: $$Excel-Macros$$ Network days with a tweak

ur mail. Is there > any way to calculate networking days > > > > Regards > LKModi > > On Wed, Apr 7, 2010 at 2:20 PM, Aindril De wrote: > >> Hi Roopesh, >> >> The process given in the link below will be a good start. >> Regards, >> Aindr

Re: $$Excel-Macros$$ Network days with a tweak

Hi Roopesh, The process given in the link below will be a good start. Regards, Aindril On Wed, Apr 7, 2010 at 12:29 PM, RK wrote: > Hi Champs, > > I am looking for a formula or an add in that works like networkdays, > the only difference being that I want saturday to be included as a > working d

Re: $$Excel-Macros$$ Does anybody have games

Try these links http://www.excelgames.org/ http://www.automateexcel.com/2005/01/13/52_excel_games/ Regards, Andy On Wed, Apr 7, 2010 at 12:37 AM, Nani Ram <06n...@gmail.com> wrote: > Hi All, > > Does anybody have games in excel sheet, if so please send me. > > > Thanks, > Naniram > > -- > > ---

Re: $$Excel-Macros$$ CONVERT

Hi, Please use the macro in the following link: http://wordribbon.tips.net/Pages/T007755_Converting_Numbers_to_Text.html Regards, Andy On Tue, Mar 16, 2010 at 2:13 PM, Jai wrote: > > Hello All, > > Please Tell me That, > > Can we convert number to Text In Ms Word -2007, > > For Example 2000

Re: $$Excel-Macros$$ URGENT :Sumif Query

Hi Ayush, If you are using Exel 2007 then you can use Sumifs function, or otherwise you can use sumproduct function if you are using any version below 2007. Regards, Aindril On Wed, Feb 10, 2010 at 9:30 PM, Ayush wrote: > Dear Group, > > I have a query on sumif function that if I would like to

Re: $$Excel-Macros$$ Attendance Tracker

Hi Chandhrabhan, Your query might be a little misplaced as it is a forum mainly for Excel users. However I am attaching a few links as pointers that might help you to easily resolve your query. http://support.microsoft.com/kb/308459 http://office.microsoft.com/en-us/access/HA010345961033.aspx htt

Re: $$Excel-Macros$$ Very Urgent::Excel function to assign the 3rd substring of a string to a variable

Hi Bharghav, Try this in any cell other than A1, Suppose A1 contains the text Data for abc 07 =MID(A1,FIND(" ",A1,(FIND(" ",A1,1)+1))+1,(FIND(" ",A1,FIND(" ",A1,(FIND(" ",A1,1)+1))+1)-FIND(" ",A1,(FIND(" ",A1,1)+1))-1)) Regards, Andy On Wed, Dec 9, 2009 at 7:26 PM, bharghav r wrote: > All, > >

Re: $$Excel-Macros$$ combobox to show 01 instead of 1

you have to write '01 '02 etc in the named range On Sun, Dec 6, 2009 at 3:56 PM, Nasim wrote: > Hi, > > I have a combobox that is populated from a named range on a sheet > (days from1 to 31) I changed them to text to show as (01 to 31) but my > combo box still shows 1 instead of 01. Can this be

Re: $$Excel-Macros$$ URL Update -change of date

t; Andy could you please help with the syntax > > Like " URL;http.and how do i get the s (string variable) here ? > > > > On Thu, Dec 3, 2009 at 5:16 PM, Aindril De wrote: > >> Use a string variable say x >> And Pass x = Day(Date) & Month(Date) &

Re: $$Excel-Macros$$ Help on Date Function

Use Track Changes option of Excel... On Thu, Dec 3, 2009 at 10:11 PM, krishnan Gopi wrote: > Hello All, > > Facing problem with date function, the same is explained in the attachment. > > Regards > Gopi Krishnan > > -- > > -

Re: $$Excel-Macros$$ URL Update -change of date

Use a string variable say x And Pass x = Day(Date) & Month(Date) & Year(Date) And in your URL pass x instead of the date Regards, Andy On Thu, Dec 3, 2009 at 4:36 PM, Balachander S wrote: > > I am using a macro web query to update a table from intranet. > > Every day i have to change the date

Re: $$Excel-Macros$$ Date format problem

Type it as '01-01-01 On Fri, Nov 27, 2009 at 5:40 PM, Jitheesh Vazhapully <7jit...@gmail.com>wrote: > Good Evening Excel Gurus, > > I have a data in this format 01-01-01, however as soon as I enter them in > the excel sheet,excel picks it up as date and stores it in date format, Is > there any wa

Re: $$Excel-Macros$$ Help for Expiry Date with Hijri Date System

Dear Ahmed, We have to get to this solution Step by Step: 1) Convert Windows and Excel to recognize Hijri Date. 2) Resolve your query on the expiry date. 1) To use the Hijri date format in Windows and subsequently in Excel, you need to follow the following steps: The following steps show how we

Re: $$Excel-Macros$$ A Non-Excel Query

Hi Abhishek, Use the following command: XCOPY "E:\My Collection" "D:\My Collection" /E /S Let me know if you need any further help. Regards, Andy On Wed, Nov 25, 2009 at 2:19 PM, Abhishek Jain wrote: > Hi Guys, > > I am not sure whether I should ask it here or not because as the subject > sugg

Re: $$Excel-Macros$$ Calculation Of Expire Date

Hi Nandkumar, You can use the following formula in Cell P5 to calculate the expiry date. =DATE(YEAR(J5),MONTH(J5)+O5,DAY(J5)) And Copy it down Regards, Andy On Wed, Nov 25, 2009 at 1:19 PM, Nandkumar kakvipure < nandkumar.hindust...@gmail.com> wrote: > Hello > How to Calculate Customer Mature

Re: $$Excel-Macros$$ Re: Share your Coolest VBA codes!

share how to use this code. > > i mean to say how to start it after writing it. > On Mon, Nov 23, 2009 at 9:12 AM, Aindril De wrote: > >> Great Idea Hemant!! >> >> Here goes my code!! >> The following code is to Convert Currency to Words(Indian Style) >&g

Re: $$Excel-Macros$$ FILTER IN EXCEL

Dear Sunil, You can use the following UDF: This Custom Function can be used to highlight them. Enter the following code in a standard module. (Alt + F11, then Insert, Module from the top menu) Function FilterOn(myCell As Range) As Boolean On Error Resume Next With myCell.Parent.AutoFilte

Re: $$Excel-Macros$$ Re: Share your Coolest VBA codes!

Great Idea Hemant!! Here goes my code!! The following code is to Convert Currency to Words(Indian Style) 'Please make a Module and add the code... Option Explicit ' Function for conversion of a Currency to words ' Parameter - accept a Currency ' Returns the number in words format '**

Re: $$Excel-Macros$$

Dear Mahavir, I have done a solution from whatever I could understand from your sheet. Please find attached the solution as per my understanding. Let me know if you need further help. Regards, Andy On Fri, Nov 20, 2009 at 3:57 PM, Mahavir Bhardwaj wrote: > > Pls see attachment > > > -- > - > --

Re: $$Excel-Macros$$ Re: Count of Text

Attach a file in reply to this email.. On Fri, Nov 20, 2009 at 3:55 PM, mahavir wrote: > > i dont know how to attached file. pls tell me the procedure > > Mahavir > > > On Nov 19, 10:50 pm, mahavir wrote: > > Pls help > > -- > > --

Re: $$Excel-Macros$$ Change index number in filter mode

Hi Anil, It seems the file you have attached has virus in it. I have created a sample solution for you. Attaching the File. Hope this Helps... Let me know if u need further help. Regards, Andy On Fri, Nov 20, 2009 at 1:47 PM, Anil Saxena wrote: > Hi Ayush/Dilip > > plz How I can change index n

Re: $$Excel-Macros$$ Urgent help on simple macro

Hi VR Could you explain the requirement a little more. On Tue, Nov 17, 2009 at 10:26 PM, vinod rao wrote: > Thanks Andy. Plz help me on other file about deleting columns > > > On Tue, Nov 17, 2009 at 8:46 PM, Aindril De wrote: > >> Hi VR, >> >> Please use the

Re: $$Excel-Macros$$ Urgent help on simple macro

Hi VR, Please use the following code: Sub TispPAT() 'Macro created by Aindril De(Andy) 'Shortcut Ctrl + Shift + p Dim CurCell As Object Dim i As Integer i = 4 For Each CurCell In Range("B4:B11") Range("B" & i).Activate

Re: $$Excel-Macros$$ Fwd:Urgent. I have a Problem.Pls help

Dear Hemant There is nothing written in the attached sheet. Please resend Regards, Andy On Mon, Nov 16, 2009 at 12:55 AM, hemant shah wrote: > Hi Mr-excel, > > Pls help me on my query. Have a look at attached sheet > > > -- Forwarded message -- > From: hemant shah > Date: Thu, N

Re: $$Excel-Macros$$ COUNTIF

You can use OR() to do this... however.. if this does not help please attach a file with the problem so that we can solve it for you Regards, Andy On Sat, Nov 14, 2009 at 10:19 AM, TNS wrote: > I am trying to use COUNTIF for calculating the row count for the below > condition. > > COUNTIF("

Re: $$Excel-Macros$$ Need Urgent Help ~ Vlookup

a right way...was kinda frustrated in office.. :( > > > > On 11/13/09, Aindril De wrote: >> >> Dear Anish, >> >> You would need a UDF for this: >> >> Use the following code : >> >> Option Explicit >> >> Public

Re: $$Excel-Macros$$ Macro to Protect cell of a worksheet

Debashish, Could you please elaborate the requirement. If possible with an example workbook. Regards, Andy On Fri, Nov 13, 2009 at 5:03 PM, DEBASHIS BANERJEE wrote: > > Dear Friend, > > I need a Macro to Protect Cell of a work Sheet . Kindly help . it is > Urgent . > > Thanks and regards > >

Re: $$Excel-Macros$$ hi need ur help

g vlookup my answer should > come3 in this case but its not showing that > > > On Thu, Nov 12, 2009 at 12:42 PM, Aindril De wrote: > >> Hi Ashish >> >> =IF(EXACT(F7,VLOOKUP(F7,A5:B7,1,1))=TRUE,VLOOKUP(F7,A5:B7,1,1)," NO EXACT >> MATCH") >>

Re: $$Excel-Macros$$ hi need ur help

Hi Ashish =IF(EXACT(F7,VLOOKUP(F7,A5:B7,1,1))=TRUE,VLOOKUP(F7,A5:B7,1,1)," NO EXACT MATCH") Is the corrected formula. Regards, Andy On Thu, Nov 12, 2009 at 11:44 AM, ashish koul wrote: > hi sir > > can u please check whats wrong in the formual want to do case sensitive > vkooup > > thanks > >

Re: $$Excel-Macros$$ hi help please

Hi Ashish, You can simply use the exact match option of vlookup to do this. The following links from MS have the complete explaination: XL: How to Perform a Case-Sensitive Lookup http://support.microsoft.com/kb/214264 How to Use VLOOKUP or HLOOKUP to find an exact match http://support.microsoft.

$$Excel-Macros$$ Re: ANOVA

1. Click "Tools" - "Add-Ins". 2. Check "Analysis ToolPak". 3. Click "OK". 4. Follow the on-screen prompts or instructions. Regards, Andy On Tue, Oct 27, 2009 at 8:57 PM, Shimmy wrote: > > Hi excel Gurus, I am trying to calculate ANOVA in excel 2003, I am > failing to carry out this task. Howeve

$$Excel-Macros$$ Re: - AUTOMATICALLY RUN AFTER FILE OPEN

Hey Rolf, You have to put the code or call the macro from *Private Sub Workbook_Open() * ** Here are some examples http://www.ozgrid.com/VBA/auto-run-macros.htm http://www.ozgrid.com/VBA/IsWorkbookOpen.htm HTH Andy On Fri, Oct 23, 2009 at 6:58 PM, big smile wrote: > Hellow friends > Please

$$Excel-Macros$$ Re: Excel cell addresses

try this http://www.eggheadcafe.com/software/aspnet/31588321/find-last-row-value-in-co.aspx On Sat, Oct 24, 2009 at 11:04 PM, Robert Carneal USA wrote: > > Can anyone point me to a resource where I can read on cell > referencing? I.e., the address of the last match found in a column, > and be a

$$Excel-Macros$$ Re: Codes not supporting office 2007

Dear Ajith, You are getting this problem because Application.FileSearch is not supported beyond 2003. There have been several approaches suggested for an alternate way. The following links should help you : http://social.msdn.microsoft.com/forums/en-US/isvvba/thread/a450830d-4fc3-4f4e-aee2-03f799

$$Excel-Macros$$ Re: MYEXTRACT

Hey Michael.. Here u go Function MyExtract(MyText As String, ItemNo As Integer, FrontOrBack As String, Optional MySeparator As String) As String ' This function will scan a string containing at least TWO words, each separated ' by a specified character and extract one of the words. It

$$Excel-Macros$$ Re: MYEXTRACT

Hey Michael.. Here u go Function MyExtract(MyText As String, ItemNo As Integer, FrontOrBack As String, Optional MySeparator As String) As String ' This function will scan a string containing at least TWO words, each separated ' by a specified character and extract one of the words. It

$$Excel-Macros$$ HAPPY DIWALI to All Members!!

Dear Fellow Group Members, Wish you All and Your Families a Happy and Prosperous Diwali. Hope the festive season brings in health, happiness and prosperity to your lives. Warm Regards, Aindril De (Andy

$$Excel-Macros$$ Re: Please send me Urgent

Hi Amresh, Go through the link below. It has a lot of useful tips and usage of time calculation in excel. http://www.exceltip.com/exceltips.php?view=category&ID=111 Regards, Andy On Wed, Oct 14, 2009 at 6:48 PM, amresh kumar wrote: > Hi My All Friends, > > i requested to you please send me exa

$$Excel-Macros$$ Re: Subtract dates

Hi All, There is a worksheet equivalent of the VBA only datediff function. It is DateDif. This function calculates the number of days, months, or years between two dates. This function is provided for compatibility with Lotus 1-2-3. Syntax *DATEDIF*(*start_date*,*end_date*,*unit*) *Start_date

$$Excel-Macros$$ Re: HEY NEED HELP

Right Click on the cells Select Format Cell Under Number Tab Choose Custom in Category In the Type box type MM/DD/ Click OK Regards, Andy On Mon, Sep 21, 2009 at 2:05 PM, ashish koul wrote: >8/3/2009 8/3/2009 8/3/2009 8/4/2009 8/4/2009 8/4/2009 5/8/2009 5/8/2009 > 5/8/2009 5/8/2009 5/8/

$$Excel-Macros$$ Re: $$ TIP $$ Backing up Excel Files

Hats Off Ayush... Excellent Tip... Regards, Andy On Thu, Sep 17, 2009 at 7:31 PM, Ayush Jain wrote: > ** > Do you have important Excel files that would create nothing short of chaos > and disaster for you if you were to lose those files? > Now I'm sure that you regularly make copies of th

$$Excel-Macros$$ Re: Nested Formula

Please reply to this email with the attachment On Sat, Sep 12, 2009 at 4:07 PM, Jitu <7jit...@gmail.com> wrote: > > Please let me know how can i send the excel file or where can i upload > it > > > > --~--~-~--~~~---~--~~ --

$$Excel-Macros$$ Re: Hi My All Friends Urgent

Hi Amresh, This can be achieved doing the following steps: 1) Select the entire sheet. 2) Right Click on the selected area and select Format Cells. 3) In the format cells dialog box choose the Protection Tab. 4) Click on the Locked and uncheck it. 5) Click OK. 6) Now select the cell that you want

$$Excel-Macros$$ Re: Find the second highest no.

Dear Gaurav, Assuming that your data is in range A1:A10, =LARGE(A1:A10,2) will find the second highest number in the range. Let me know if this helps. Regards, Andy On Mon, Aug 24, 2009 at 7:39 PM, Gaurav Banerjee wrote: > Hi,, How to fnd the second highest no. in a grop of 10 No. using formul

$$Excel-Macros$$ Re: Excel 2002 Forms toolbar

How did you solve it?? Regards, Andy On Mon, Aug 24, 2009 at 8:39 AM, Tommy wrote: > > SOLVED > > On Aug 21, 10:58 am, Tommy wrote: > > When I bring up the Forms toolbar there are some controls that are > > grayed out, specifically the Dropdown List and some others. Can anyone > > shed any lig

$$Excel-Macros$$ Re: Excel 2002 Forms toolbar

YOu can try the following if it is not protected: Under Tools | Options | View Tab Check the radio button selection for Objects. Change from "Hide All" to "Show All" Please let me know if this helps. Regards, Andy On Sat, Aug 22, 2009 at 2:06 PM, Aindril De wrote:

$$Excel-Macros$$ Re: Excel 2002 Forms toolbar

Is your worksheet protected??? Regards, Andy On Fri, Aug 21, 2009 at 10:58 PM, Tommy wrote: > > When I bring up the Forms toolbar there are some controls that are > grayed out, specifically the Dropdown List and some others. Can anyone > shed any light on this. I am trying to construct a form a

$$Excel-Macros$$ Re: Sales tax discount calculation

Hi Norman, This should be possible with a solver/scenario manager. Could you please attach a file of Sample data, so that it is easy for us to give you a relevant solution. Regards, Andy On Sat, Aug 22, 2009 at 10:38 AM, Norman May wrote: > Michael, > > I'm not sure if this is what you want: >

$$Excel-Macros$$ Re: Please Help Me !!!!!!!!

Hi Amresh, Could you please clarify!! "Workbook in Word" Please send a sample file. Regards, Andy On Mon, Aug 17, 2009 at 7:15 PM, amresh kumar wrote: > Dear Freinds, > > please help me > > > i have a workbook in word there are many pages in workbook but i want > Separate > workbook

$$Excel-Macros$$ Re: Fwd: about to remove "#VALUE!" error

Dear Dhananjay, YOu can do a simple change in the formatting of the cells. Select the table, use custom format and choose General. Paste the following formatting. General;General;_-* "-"??_-;_...@_- Click oK. Now change all - with 0 . you will notice all 0 values will be represented as -. Hop

$$Excel-Macros$$ Re: replace when large data in cell

e your file) > Is you did it by find and replace? > > Is it possible in Office 2003? > > > ----- Original Message - > *From:* Aindril De > *To:* excel-macros@googlegroups.com > *Sent:* Wednesday, June 24, 2009 9:52 PM > *Subject:* $$Excel-Macros$$ Re: replace w

$$Excel-Macros$$ Re: please ... it's urgent

seful option/function in Excel). > > Regards, > Dhananjay > > > > On 8/9/09, Aindril De wrote: >> >> Dear Dhananjay >> >> Please find attached the solution. >> >> 1) For the rounding of the numbers, I have used : =ROUND(B2,-1) in the >> Co

$$Excel-Macros$$ Re: Anyone know this?

Dear Sandeep, could you elaborate your question a little more. May be with one sample.. Regards, Andy On Mon, Aug 10, 2009 at 12:07 PM, Sandeep wrote: > Is there is anyway to use values as range in formula. > Or is there is anyway to change values in range. > > Don't think for a vba solution i

$$Excel-Macros$$ Re: Anyone know this?

Dear Sandeep, could you elaborate your question a little more. May be with one sample.. Regards, Andy On Mon, Aug 10, 2009 at 12:07 PM, Sandeep wrote: > Is there is anyway to use values as range in formula. > Or is there is anyway to change values in range. > > Don't think for a vba solution i

$$Excel-Macros$$ Re: please ... it's urgent

Dear Dhananjay Please find attached the solution. 1) For the rounding of the numbers, I have used : =ROUND(B2,-1) in the Column C. 2) For the formatting of the numbers I have used the following custom format : [>=1000]##\,##\,##\,###.00;[>=10]##\,##\,###.00;#,##0.00 Please let me know if

$$Excel-Macros$$ Re: Need Help on Macro - image Resizing

Dear Kamal, Just add the following line to the top of your code to select all pictures in the worksheet ActiveSheet.Pictures.Select Hope this helps. Otherwise please post your code here so that we can take a alook. Regards, Andy On Thu, Aug 6, 2009 at 4:51 PM, kamal shah wrote: > Hi Excel G

$$Excel-Macros$$ Re: Submit data to a web site from excel

Dear Hemant, Look at this site. Hope it helps. http://www.vbforums.com/showthread.php?t=526835 Regards, Andy On Sat, Aug 1, 2009 at 7:43 PM, Hemant wrote: > > Hi dear friends > > Can any of you please tell me how to submit data (which is in a > workbook) to a web site from excel? > > I know t

$$Excel-Macros$$ Re: hi

Dear Ashwani, Please find attached the solution. Please let me know if you need any further help on this. Regards, Andy On Wed, Jul 29, 2009 at 10:11 AM, Ash Singh wrote: > Hi All, > > Please find attached the excel sheet with problem statement. > > > > -- > Regards, > Ashwani Singh > > > > -

$$Excel-Macros$$ Re: Multiply and/divide with a number

Dear Balbir, Please follow the steps below. 1) Write the number in a cell in the sheet. 2) Copy the cell containing the number 3) Select the range you want to Multiply/divide 4) Right Click on the Selected Range and choose "Paste Special" 5) In Paste Special dialog box. Under Operation Group, you

$$Excel-Macros$$ Re: Segregation of data on a button click in excel

Dear Pinky, Can you please attach a sample file. This will help a quick solution Regards, Andy On Mon, Jul 27, 2009 at 9:22 PM, Ayush Jain wrote: > > Dear members, > > Can anyone assist Pinky ? She is in urgent need. > > Thanks. > > On Jul 27, 3:48 pm, Pinky Sangani wrote: > > HI > > i need t

$$Excel-Macros$$ Re: Re : Retaining date format while concatenating

Dear Radhe Sham, Use Text(Date,"dd-mmm-yy") while concatenating e.g. "Today is "&Text(Today(),"dd-mmm-yy") will give Today is 27-Jul-09 as result. Please let me know if it helps. Regards, Andy On Mon, Jul 27, 2009 at 10:08 PM, Radhe Sham L wrote: > Hi Group > > This is a query regarding the

$$Excel-Macros$$ Re: Importing data for more than 65536 rows

Dear Prasad, Microsoft has already given a solution for this. Attaching the two links that will help you. It also has the macro to be written. http://support.microsoft.com/kb/190032 http://support.microsoft.com/kb/120596 Please let me know if you need further help on this. Regards, Andy On Su

$$Excel-Macros$$ Re: command buttons in excel

Hi Jiant Can you please send the sample file. Regards, Andy On Sun, Jul 26, 2009 at 6:01 AM, giant wrote: > > hello i am new to this group,and i would like help with command > buttons.I will have cells (A1:A10 and B1:B10) randomly selecting names > what i want is to put a button in c1:c10 to co

$$Excel-Macros$$ Re: Help me Plz

Hi Anil, Please use the following formula =IF(COUNTIF($A$2:A2,A2)=1,"Unique","") Regards, Andy On Wed, Jul 22, 2009 at 5:42 PM, anil panchal wrote: > Hi Group, > > > I want Unique name form countif > > Thanks & Regards > Anil Kumar > Executive - Database > SOLUTIONS DIGITAS > 3rd Floor, Cha

$$Excel-Macros$$ Re: PLEASE SEND ME URGENT!~!!!!!!!!

Hi Amresh, You can download one fromj the link below: http://www.geocities.com/accessreddy/excel/emi.htm Regards, Andy On Wed, Jul 22, 2009 at 3:43 PM, amresh kumar wrote: > Hi Friends, > If U Have EMI CALCULATOR IN EXCEL PLEASE SEND ME URGENT > > Regards > Amresh > > > > --~--~-~--~-

$$Excel-Macros$$ Re: Get yesterday's date but if a weekend give me friday's date-->function!

Hi Jonathan, Use the following formula: =IF(OR(WEEKDAY(TODAY(),2)=2,WEEKDAY(TODAY(),2)=3,WEEKDAY(TODAY(),2)=4,WEEKDAY(TODAY(),2)=5,WEEKDAY(TODAY(),2)=6,WEEKDAY(TODAY(),2)=7),TODAY()-1,TODAY()-2) Please let me know if this helps. Regards, Andy On Tue, Jul 21, 2009 at 6:35 PM, totalnatal wrote:

$$Excel-Macros$$ Re: Feedback Web Page

Dear Saurabh, Yeah your query is a little misplaced. however we are always happy to Help. [?] The easiest way to do this is to use the Form Mail system. This is free to work with as well. However there are various versions available and you can choose any as per your requirement. This Form Mail

$$Excel-Macros$$ Re: 1>Hardcode a cell value to the code(macro code) |||||||||||||| 2>code to save only a particular cell value at the time of closing the workbook

You can consider the following set of code: Sub dede() ' ' dede Macro ' ' Keyboard Shortcut: Ctrl+Shift+D ' Range("1:1048576,A1").Select Selection.ClearContents Range("A1").Select Range("A1").Value = "HardCoaded" End Sub Replace the value *HardCoaded *with any other value that you

$$Excel-Macros$$ Re: Best Excel Tip Award of Week # 27 goes to ****Aindril De (Andy)****

. Regards, Aindril (Andy) On Mon, Jul 6, 2009 at 10:41 PM, Ayush wrote: > > Hello Everyone, > > Please congratulate Aindril De (Andy) for winning the Best Excel Tip > award of Week # 27. It was really very useful trick to create a > validation list from the data in other sheet. Mo

$$Excel-Macros$$ Re: calendar pop-up

Hi Lynn, Please go thru the link below. This will help solve the problem. http://www.fontstuff.com/vba/vbatut07.htm Regards, Andy On Sat, Jul 4, 2009 at 7:25 PM, Lynn wrote: > > this is not what I wanted. I do not want the calendar to be shown on > the excel sheet. > It should only pop-up whe

$$Excel-Macros$$ Re: Printing filtered data only

Criteria1:=">0", _ Operator:=xlAnd Range("A1:E17").Select Range("A17").Activate Selection.SpecialCells(xlCellTypeVisible).Select ExecuteExcel4Macro "PRINT(1,,,11,,,TRUE,,FALSE)" Range("F21").Select End Sub On Fri,

$$Excel-Macros$$ Re: Printing filtered data only

Hi Louis, Can you send the sample file so that I can prepare the macro as per your sheet. Regards, Andy On Fri, Jul 3, 2009 at 2:46 PM, loconel wrote: > > I am new to VBA and do want to make viewing and printing a selection > of lines in an order sheet easy. > > In the order sheet (400 lines o

$$Excel-Macros$$ Re: help required

Dear Shivshankar, You can use the copy -> paste special -> transpose . The shortcut Key for the above is: Ctrl+C followed by ALT + e + s + e then hit return (for transpose) Or You can consider creating your own shortcut key (one time affair and will always help you) Create a macro that does wh

$$Excel-Macros$$ Re: Match date to enter data in table

Dear Amol, Please find attached the file with the solution. Regards, Andy On Wed, Jul 1, 2009 at 7:15 PM, Amol Shende wrote: > Dear Friends, > > Pl help me to enter in the yellow cell the information from table 2 based > on the highlighted (red) date > > > > > *06/02/2009* ** ** *Date* *0

$$Excel-Macros$$ Re:

Name: Aindril De (Andy) Tip: Create Validation List from Data in Different Sheet A lot of times, when creating a validation list, we might want to get the data from another sheet in the workbook. But by default, Excel does not allow the validation data to be captured from another worksheet. To

$$Excel-Macros$$ Re: MS PROJECT

Hi Rakesh, Try this http://www.mousetraining.com/ms-office-training-manuals.html Regards, Andy On Sun, Jun 28, 2009 at 5:35 PM, rakesh luthra wrote: > Dear All, > > Can anybody help me in understanding MS project? I shall be grateful if > somebody send material in powerpoint or guide with comp

<    1   2   3   >