Excel Forum - solved topics

Ask a question
Results 1301 - 1350 of about 1,710
  • Solved
  • hiding a different sheet in workbook Solved/Closed

    Dear sir, I have one worksheet and there are 20 different sheet in that worksheet. I want to show 1 or 2 sheet and want to hide rest sheet. May i...

    ram | Latest reply: venkat1926 May 21, 2011
    1 reply
  • Report from Excel Data Sheet Solved/Closed

    Dear Sir, I am new in excel. I am trying to use excel for my work easier. I have one excel file where there are different sheet of monthly salary ...

    ram sharma | Latest reply: ram May 21, 2011
    4 replies
  • Excel VB Macro Solved/Closed

    Hello, I am new to vb and excel. I am trying to create a Macro that will look through all the worksheets in a workbook and find the column named "...

    b_85 | Latest reply: b_85 May 20, 2011
    4 replies
  • Codes for Reminder creation in Excel VBA Solved/Closed

    Hello, I want to get Reminder message box automatically, according to the date and time in Excel worksheet. What are the VBA codings & procedures?...

    koyel | Latest reply: vivek May 17, 2011
    23 replies
  • can not run macro Solved/Closed

    hello sir, I am trying to put macro in any excel sheet then "can not run the macro" the macro may not be available or all macros may be disabled. ...

    ram sharma | Latest reply: ram sharma May 17, 2011
    1 reply
  • how to create shortcut keys to xl 2007macros Solved/Closed

    Hi, I created few Macros in excel 2007,these working fine but how to assign short cut keys to these macros.In macros window in options property is ...

    Gowind | Latest reply: RWomanizer May 17, 2011
    3 replies
  • Ignoring rows with zero value Solved/Closed

    Hello, A couple weeks ago ya'll helped me with some code to compare two sheets and create a new worksheet with all of the values that were identic...

    ChrisCoR | Latest reply: RWomanizer May 16, 2011
    3 replies
  • Highlighting the values entered in an excel Solved/Closed

    Hello, Dear All, I have a question to ask, Actually i am working with an Excel File which has so many sheets under one file, and this file ...

    umair | Latest reply: TrowaD May 16, 2011
    3 replies
  • Copying Data To Another Worksheet Solved/Closed

    Hello, I have the following data in worksheet named "Auto Entry" Cell A1= X Cell A2 =Y Cell A3 =Z Cell A4=Input Value(1,2,or 3) In Cell A4 is...

    azmiismail | Latest reply: TrowaD May 16, 2011
    1 reply
  • Excel: matching and sorting Solved/Closed

    Hello, Ok, how sould a computer dummy to this (the dummy is me): I have a list of 300 bike racers. In the columns next to the racer is items such a...

    joecrosstime | Latest reply: lew13 May 12, 2011
    13 replies
  • can someone please write me a macro for excel Solved/Closed

    I want to be able to input a number into a cell and have that number recorded in a list elsewhere within the same sheet. Then be able to replace tha...

    Paul | Latest reply: TrowaD May 12, 2011
    3 replies
  • copy selected cells to new sheet in a row Solved/Closed

    Hello, dear all, I have an invoice template in the range b6:f57 in one sheet.. I want to select only some cell contents like c17, f17, f 19 , f 32, ...

    suryam | Latest reply: suryam May 10, 2011
    9 replies
  • macros help Solved/Closed

    Dear Friend i want to convert number to text in excel programme Example : ( 055555 : Zero five Five Five Five Five ) As This Format ...

    dilip | Latest reply: suryam May 5, 2011
    4 replies
  • Transfering data to a new sheet Solved/Closed

    I'm running excel 2007 on windows 7, if that's important. I'm trying to find a way to transfer data from a master sheet (or basically sheet 1) to...

    Stickihasit | Latest reply: Stickihasit May 4, 2011
    3 replies
  • Format data in excel for Db transaction Solved/Closed

    Hello, I have a simple question, I have a range of cells with numbers in each cell. I want to add a single quote or apostrophe in the start and end...

    ms.pre | Latest reply: holly May 4, 2011
    3 replies
  • Excel Macro to copy text and append Solved/Closed

    Hello, I recorded a macro in Excel where I copied the text from one cell and appended that text to the values in several other cells. The problem...

    sgriffis | Latest reply: RWomanizer May 2, 2011
    4 replies
  • cell reference to locate /store data in excel Solved/Closed

    Hello, Hello , I am working for a newly started airline agency. I am enclosing my working file (for privacy sake , I have changed names and oth...

    Suryam | Latest reply: suryam May 2, 2011
    8 replies
  • Excel macro help Solved/Closed

    Hi there, I am getting an error when I try and run the following macro. I am trying to find the value in one worksheet (final) in another worksheet ...

    Fi | Latest reply: venkat1926 Apr 29, 2011
    1 reply
  • Delete AllowEditeRanges by VBA Solved/Closed

    Dear All, Can some-body help me to correct the following code: Private Sub CommandButton1_Click() Dim WS As Worksheet Dim aer As AllowEditRang...

    issa | Latest reply: Issa Apr 26, 2011
    3 replies
  • Delete AllowEditeRange by VBA command Solved/Closed

    Dear All, Can anyone help me to correct the following code: Private Sub CommandButton1_Click() Dim WS As Worksheet Dim aer As AllowEditRange...

    Celina | Latest reply: Celina Apr 26, 2011
    2 replies
  • Excel Conditional Formatting Rows to Columns Solved/Closed

    Hello, I have a data set that looks like: A B 1 20 2 21 3 21 4 03 1 19 2 34 3 23 4 25 1 23 2...

    em | Latest reply: em Apr 25, 2011
    2 replies
  • HELP about macro copy and paste Solved/Closed

    Hello, Just want to seek help to anyone about my problem about copying and paste multple raw and column thru new sheet also with designated raw an...

    marvs | Latest reply: venkat1926 Apr 20, 2011
    3 replies
  • Copy to first open cell in rowB/sheet 2 Solved/Closed

    Hello, Thanks for trying to help! I have a sheet as shown below. We do sales every day and would like the values/ estimates and sales that have...

    Stormdronk | Latest reply: Stormdronk Apr 20, 2011
    6 replies
  • VBA - how to replicate the value n times Solved/Closed

    Hello, I have to write in VBA a macro that allows to replicate value n times (input). Let's say, I have a list one two three and I have to re...

    gradelle | Latest reply: gradelle Apr 18, 2011
    5 replies
  • Help required in MS Excel Solved/Closed

    Hello, I have a list of text strings in rows separated by blank rows. For example: Row 1: Name of the publication Row 2: Authors Row 3: Organiz...

    eskagsms | Latest reply: eskagsms Apr 16, 2011
    7 replies
  • how to compare columns of 2 different Excel Solved/Closed

    I want to compare column named employeeid in two different EXcel sheets and have to retrive the rows with same employeeid ex: sheet1 emp name ...

    prathibha | Latest reply: RWomanizer Apr 15, 2011
    3 replies
  • Excel If Then, create a new column Solved/Closed

    Hello, I'm trying to write a VBA code, because I have too many factors to create a nested function. I can do it fine if there were less than 7 variab...

    AprilZ | Latest reply: RWomanizer Apr 14, 2011
    7 replies
  • VBA to Protect sheets & keep some options on Solved/Closed

    Dears, I will be very grateful if some one can help me. I have excel file include 50 sheets, so I made one sheet that include all the basis info fo...

    issa | Latest reply: Issa Apr 13, 2011
    2 replies
  • Indirect function on Excel Solved/Closed

    Hello, I need to know how I can add the following to an exsiting cell reference in a whole column. ='Sheet1'!A2 to show =INDIRECT("'Sheet1'!...

    PM | Latest reply: tipsindeed Apr 13, 2011
    10 replies
  • searching names in drop down list in excel 07 Solved/Closed

    Hello, I have placed a drop down listbox in my excel 2007 work sheet and selected the range of names which are in the same sheet. In the list I hav...

    suryam | Latest reply: RWomanizer Apr 11, 2011
    5 replies
  • Excel formula problem Solved/Closed

    Hello, Please Help =IF(V12=1,2*(R12*50%)) I have a problem with this formula: What I need, is if v12 = 1, 2, 3, or 4 count R12 times 50%...

    Stormdronk | Latest reply: Stormdronk Apr 4, 2011
    3 replies
  • Excel: If A1 = a 4 the comy content of b1,2,3 Solved/Closed

    Hello, Please help! If A1 = a 4 the comy content of b1,2,3,4,5 to c1,2,3,4,5 The 4 in a1 are generated by a formula. Thanks Confi...

    Stormdronk | Latest reply: rizvisa1 Apr 3, 2011
    3 replies
  • Excel - Help! Solved/Closed

    Hello, I require a formula which will recognise months in a column and select taht value from a different cell on the same row. The data is the...

    The_g | Latest reply: TrowaD Apr 1, 2011
    1 reply
  • Format using Macro Solved/Closed

    Hi I have some data in sheet1. Eg: Column A Column B Column C Column D 1 2 3 4 ...

    Rahul | Latest reply: harry Mar 29, 2011
    16 replies
  • Filter rows in one sheet Solved/Closed

    Hello, I have large amounts of data in one work sheet(say it as Sheet1) and another worksheet(sheet2) has few records(100) which are also present ...

    gd | Latest reply: RWomanizer Mar 29, 2011
    5 replies
  • converting rows data into columns on conditon Solved/Closed

    Hello, I have data which looks like below ColA-----------ColB-------ColC--------ColD------------ColE---------ColF-------ColG----ColH-------- AA-...

    gd | Latest reply: RWomanizer Mar 29, 2011
    3 replies
  • delete cells/rows but keep row info intact Solved/Closed

    hello, I am trying to import data from an excel spread sheet to access. I want to clean up my excel report before I import the date. In my report...

    lenice | Latest reply: TrowaD Mar 25, 2011
    2 replies
  • Dates in Excel Solved/Closed

    Hello, I have a list of people's birthdays in a list in Excel. I want to retain only the day and month of the birthday and get rid of the year. For ...

    eskagsms | Latest reply: RWomanizer Mar 24, 2011
    1 reply
  • Excel Comparing 2 columns removing duplicates Solved/Closed

    Hi, I would like to cmpare 2 columns in an Excel spreadsheet & remove duplicates from Column B if any matching fields are found e.g. A B 1 ...

    Ben | Latest reply: rizvisa1 Mar 23, 2011
    3 replies
  • Excel 2007 VLOOKUP and MATCH problem Solved/Closed

    Hello Long time lurker, first time poster. I'm having an issue with a Vlookup and match function. I have a set of data that is organised and sorted...

    Nikeyg | Latest reply: Nikeyg Mar 23, 2011
    1 reply
  • How to do if statements in Excel Solved/Closed

    Hello, I am having a problem trying to get an if formula right. If fig1 is +- 10% of fig2 I want it to say Fail If fig1 is within 10% of fig...

    Emerbeamer | Latest reply: Emerbeamer Mar 18, 2011
    2 replies
  • Summary Sheet Solved/Closed

    Hello Sir, I Have 30 Data Sheets Of Individual Date & 1 Summary Sheet. The Example Of Those 30 Sheets Are: A1------------B1------------------...

    Game Start Now | Latest reply: RWomanizer Mar 18, 2011
    9 replies
  • Found Cell Color And Worksheet Viewing Solved/Closed

    Hello, The code below had cause the found value cell color to remain there even after I closed the Input Box.I would like to have the color to be re...

    azmiismail | Latest reply: TrowaD Mar 14, 2011
    2 replies
  • Macro to define a interval Solved/Closed

    Hello, i have a excel sheet of details of employee of the organisation. in that sheet I have a column D of age. I have to define age interval f...

    RWomanizer | Latest reply: rizvisa1 Mar 9, 2011
    12 replies
  • Adding new data sets to multiple worksheets Solved/Closed

    Hello, I am creating a spreadsheet database for data to determine the best vendor to use. I have multiple vendors on different worksheets and the...

    Aaron | Latest reply: Aaron Mar 4, 2011
    2 replies
  • Macro To Copy Rows From One Worksheet To Anot Solved/Closed

    Hi , I'd like to know if there's a macro that can be run to check one worksheet. In this worksheet there is a column where the value should be "true"...

    Gowind | Latest reply: Gowind Mar 4, 2011
    9 replies
  • One Button To Execute Two Macros Solved/Closed

    Hello, I got one macro in Sheet1 and another macro in sheet2 under the same workbook.I want to assign a button in sheet1 so it can execute both the ...

    azmiismail | Latest reply: azmiismail Mar 3, 2011
    4 replies
  • Excel formula A+B=C with the following except Solved/Closed

    Hello, I really could use some help please. I am working on an 2010 excel spreadsheet. Would anyone know if there is a formula to do the following....

    Scott | Latest reply: Scott Mar 3, 2011
    2 replies
  • Use Excel VBA to create an e-mail w reminder Solved/Closed

    Hello, I create a file in Excel that does some calculations based on a small database and some user input. I then added a button to open an e-mail...

    BrunoD | Latest reply: Bruno Mar 2, 2011
    2 replies
  • Macro to highlight a row if cells match value Solved/Closed

    Hello, I sorry but I am very new to macros and trying to create one in Office 2003. I need to bold a row if for example column E is greater than a...

    sgriffis | Latest reply: sgriffis Feb 22, 2011
    2 replies