Excel Forum - solved topics

Ask a question
Results 1451 - 1500 of about 1,710
  • Solved
  • More than 3 conditional formats in Excel Solved/Closed

    Hello, I am working with an Excel spreadsheet, and need the cell background in one column to change to red if its value is within a range of numbers...

    Trevin | Latest reply: Trevin Jul 26, 2010
    6 replies
  • Excel 2003 - Change Row Colour with VBA Solved/Closed

    Hi, hope somebody can help I've got a spreadsheet when I need to change the row colour dependent on the data entered into a particular cell. The...

    StevieB | Latest reply: StevieB Jul 25, 2010
    2 replies
  • Import webpage data into Excel spreadsheet Solved/Closed

    Hello, I am attempting to import the web page data from "http://bet1.hkjc.com/racing/pages/odds_wp.aspx?date=19-10-2008&venue=HV&raceno=1&lang=en" th...

    Jeffrey | Latest reply: stuccohound Jul 23, 2010
    23 replies
  • Open excel file into worksheet of open workbk Solved/Closed

    Hello, MS Excel 2000, VBA I'd like to be able to open a file directly into a new worksheet of an open workbook, thus adding the new sheet in the...

    hedles | Latest reply: Fetzel Jul 23, 2010
    4 replies
  • Excel Formula Solved/Closed

    Hello, I need a formula to accomplish the following. 5 + years => 15 10 + years => 20 15 + years => 25 20 + years => 30 eg. say I was h...

    Neo | Latest reply: Neo Jul 23, 2010
    10 replies
  • Match colums from sheets Solved/Closed

    Hello, I have two sheets - S1 and S2. In S1 are colums A and B. In S2 are columns B and C. I want to join columns A and C using colums B (which is...

    icicici | Latest reply: rizvisa1 Jul 20, 2010
    2 replies
  • shade the rows for different working days Solved/Closed

    Hello, I need a VBA code that allow me to shade the row color in blue when the date in a cell is performed in the last 3 days of working days . Othe...

    Carman | Latest reply: Carman Jul 19, 2010
    2 replies
  • Combine columns in excel Solved/Closed

    Hello, i have got two sheets of data and i have arranged them into ideal orders. Now i want to place data on sheet 2 behind data on sheet 1.( in the...

    Carman | Latest reply: Carman Jul 19, 2010
    3 replies
  • problem with dates in Excel 2004 MAC Solved/Closed

    Hello, I'm working in MAC OSX MS Office 2004 11.5.3 (081114) I have two workbooks opened at the same time. I copied 54K+ rows of data from o...

    Szimitar | Latest reply: Daisy Jul 19, 2010
    5 replies
  • Macro to copy a certain cell onto another row Solved/Closed

    I'm trying to copy values from one cell to another excel via use of a macro, where E#99999 is the employee number to be put to column A until it reach...

    DesertMoon20 | Latest reply: DesertMoon20 Jul 19, 2010
    5 replies
  • Conditional formatting of a column of cells Solved/Closed

    Hello, I am working on a task list/project sheet and I am trying to set a conditional format for a column of cells that is based on two (technical...

    Richard | Latest reply: Trowa Jul 16, 2010
    4 replies
  • problem moving records to another worksheet Solved/Closed

    Hello eberybody I have a doubt, I know how to move records from one sheet to another, as this: Worksheets("Sheet1").Range("A" & i + 2).Resize(1,...

    Mike | Latest reply: MIKE Jul 15, 2010
    6 replies
  • Transfer records to another worksheet Solved/Closed

    Hello, I have tried everything to move these records to a sheet called "Data" , but I wasn't able to get any good results. what I have been trying...

    Molie | Latest reply: MOlie Jul 15, 2010
    4 replies
  • Extra cells removal. EXCEL Solved/Closed

    Hello, Does anyone know how to hide unused cells in excel? I have got a program that does all the matching for me, but everytime when i finished ...

    Carman | Latest reply: Carman Jul 13, 2010
    3 replies
  • link cell to another worksheet Solved/Closed

    hi there, What i want to do is to link a worksheet to another worksheet. Like, when I type data on cell in sheet1... then, same data will auto...

    ehlblackstar | Latest reply: Mansoor Jul 13, 2010
    8 replies
  • how to select the sheet name from ddm Solved/Closed

    Hello, I want to select which sheet to store data from the drop down menu. thank you . Private Sub UserForm_Initialize() Dim i As Integer Fo...

    yogesh01 | Latest reply: rizvisa1 Jul 13, 2010
    1 reply
  • compare columns containing dates Solved/Closed

    Hello, I have the dates and the close prices of 5 indices in 10 columns. I want to compare the 5 columns containing the dates in order to get the c...

    tonia | Latest reply: venkat1926 Jul 12, 2010
    5 replies
  • One cell calculation Excel - Time Interval Solved/Closed

    Hello, I need to calculate the elapsed time in hours if the start time and end time are contained in the same cell. Example: If A1 contain...

    yyzxyz | Latest reply: yyzxyz Jul 10, 2010
    4 replies
  • Excel : Different Criteria for excel to look Solved/Closed

    Hello, Please could anyone help? Attached please find the example. https://authentification.site/files/23122635/nono.xls The sheet (Say in doc...

    abcde | Latest reply: carman Jul 8, 2010
    20 replies
  • Excel Macro Solved/Closed

    Hi I am new to Excel macros, I need help with the following automation: I am trying to copy data from the main spreadsheet name "PMO Report" where...

    Moe | Latest reply: Moe Jul 8, 2010
    8 replies
  • MS Excel 2007 Macro/Formula problem Solved/Closed

    Hello, ##Please help! I am new to this and so fed up!! I need to transfer data from two worksheets onto another worksheet and I just cannot do it!!...

    cellbar | Latest reply: cellbar Jul 7, 2010
    3 replies
  • Excel Macro Help Please Solved/Closed

    Hello Everyone, I am sking for some help with an Excel macro please. I have a 1,900 hundred static HTML pages that I have converted to text for ...

    mathisjr | Latest reply: rizvisa1 Jul 7, 2010
    45 replies
  • need to declare a cell as numeric in macro Solved/Closed

    Hello, i need to declare a cell in excel as numeric so that only numbers can be entered in that cell and if any other text is entered then it di...

    amit | Latest reply: rizvisa1 Jul 6, 2010
    1 reply
  • Excel VBA Solved/Closed

    Hello, currently i have 2 worksheets one which users would use to complete a template and the other to store the information in. i am trying to...

    ChrisBelfast | Latest reply: rizvisa1 Jul 6, 2010
    13 replies
  • Excel 2007 time and date problem Solved/Closed

    Hello, I have a sheet that has a date column and a time column (brought in from a csv file). My date column is showing in the format of MDDYYYY wi...

    Karen | Latest reply: David Jul 2, 2010
    4 replies
  • Excel VBA colour alternate rows Solved/Closed

    Hello, I am creating a report, and I want to shade alternate cells in a light grey colour. I need all columns and rows, starting at A5, that conta...

    tora | Latest reply: tora Jul 2, 2010
    6 replies
  • Uneditable selected Columns/Rows/Cells Excel Solved/Closed

    Hello, Kindly teach me how to keep the slected [Column or Rows or set of Cells] in Uneditable Mode in Excel, so that users can not change the info...

    AD | Latest reply: AD Jun 30, 2010
    2 replies
  • how can i compare one excel sheet to other Solved/Closed

    I have 1 main sheet of all the data which i send to my client, now he has slelcted some thing and sended it in new sheet. now i wanna highlight his se...

    adamya | Latest reply: dzigner Jun 29, 2010
    2 replies
  • Excel unique data rows Solved/Closed

    Hello, I need to compare two columns of data for uniqueness. Column a has a list of names and column b has a list of date/times. I need to be ab...

    quiz | Latest reply: quiz Jun 29, 2010
    9 replies
  • My excel macro silently exploded... :( Solved/Closed

    Hey, so I have a set of macro that were working, then dropped dead on the spot. before i paste the macros I'll give it some context So I have seve...

    Bobo | Latest reply: rizvisa1 Jun 28, 2010
    4 replies
  • macro Solved/Closed

    Hello, https://authentification.site/files/22774798/Copy_of_sample.xls please see the attached to see what i want done. Configuration: Win...

    Neo | Latest reply: Neo Jun 28, 2010
    28 replies
  • Background color of cell in Excel Solved/Closed

    Hello, I am trying to write a simple formula that will give me the backgroud color of a cell (in Excel). Something along the lines of, if background ...

    Dancing Waves | Latest reply: Pankaj Jun 25, 2010
    3 replies
  • How to add time reminder in excel file Solved/Closed

    Hello, I have made a work to do list and I would like excel to remind me at every task time. as I have made a column for work to do item and ti...

    Nis | Latest reply: nis Jun 23, 2010
    2 replies
  • load sheet with drop down menu Solved/Closed

    Hello I have the userform1, and a combo box linked to two cells callled "UNIVERSAL BOL" AND "BLANK BOL", plus two sheets called "BOL" and "BLANK BO...

    Alexandra | Latest reply: Alexandra Jun 20, 2010
    4 replies
  • Excel Move Cells to Right. Solved/Closed

    Hello, I have a task to move several cells in a few column to the far right column (like below) Number of column can be up to 25. ...

    j3kj3k | Latest reply: j3kj3k Jun 17, 2010
    4 replies
  • Protecting column in worksheet Solved/Closed

    How to protect only one particular column in worksheet?

    Nav | Latest reply: Saky Jun 17, 2010
    4 replies
  • EXCEL 2007 FIND MAX VALUE Solved/Closed

    Hello, date time value 05/11/2008 205 102 FALSE 05/11/2008 205 110 TRUE 05/11/2008 205 108 FALSE 05/11/2008 240 123 TRUE 05/11/2008 240 104 FA...

    bigband | Latest reply: rizvisa1 Jun 17, 2010
    9 replies
  • Excel Macro to insert a new row Solved/Closed

    Hello, I would like to create a macro in excel to automatically insert a new blank row immediately after the last row of filled-in data and for th...

    Joper | Latest reply: rizvisa1 Jun 16, 2010
    4 replies
  • Help with If VBA Statement Solved/Closed

    Hello, I have this code that i can not get to work all the way i get the error of "Too many local, nonstatic variables" i am new to this and all i...

    Boysenb | Latest reply: Boysenb Jun 15, 2010
    2 replies
  • Excel function or macros Solved/Closed

    Hello, I have a table in which every number from 1 to 52 expresses a specified text For example 1 = Sofia 2 = London ... I n...

    Philip | Latest reply: Philip Jun 15, 2010
    2 replies
  • Macros Solved/Closed

    Hi, I need a macro coding for the below scenario. In column D(Application) i have created a validation in which i have included the list of appl...

    Saky | Latest reply: Saky Jun 14, 2010
    18 replies
  • Excel Help with Percent calculations Solved/Closed

    Hello, I use "=AVERAGE(B2:AR2)" to calculate percentages based on information from 40 sheets. Example, On one sheet that compiles the data from 40 she...

    Scorchy | Latest reply: rizvisa1 Jun 13, 2010
    8 replies
  • VBA language for a range of cells Solved/Closed

    Hello, I created a calendar cell pop-up and I wanted to include it in a range of cells. However I can't figure out how to include an entire range of c...

    proudcuban | Latest reply: rizvisa1 Jun 11, 2010
    1 reply
  • Compare multiple cells and return other value Solved/Closed

    Hello, a problematic case, when comparing values in multiple cells (rows) in Excel. In a single cell , "A1" I would need an answer depending on...

    Vince | Latest reply: Vince Jun 11, 2010
    4 replies
  • Need Excel Percentage!! HELP Solved/Closed

    Hello, I am having diffficulty writing a formula to calculate a percentage. I need to calculate 25% of $ 3,100 - I thought I had it figured ...

    Deanna | Latest reply: Deanna Jun 9, 2010
    2 replies
  • copy row to different sheet based on cell Solved/Closed

    Hello, I am need to have a script run each time a cell changes to a date in column O, line 12 and after. I have a spreadsheet that has one tab ca...

    gregoryps | Latest reply: gregoryps Jun 9, 2010
    8 replies
  • Calculating exact percentages in excel Solved/Closed

    Hello, I'm trying to add exact percentages like 99.54%, 84.23% in six cells then calculate the average. I've tried =AVERAGE(A1:B1:C1) but it only ...

    DL | Latest reply: rizvisa1 Jun 8, 2010
    2 replies
  • EXCEL: Partial Cell matches in dfrnt sheets Solved/Closed

    Hello, I searched a lot and found quite some useful results about searching Partial Cell matches. But if the cells belong to different sheets how ...

    fairooz | Latest reply: fairooz Jun 8, 2010
    2 replies
  • Please help - run macro when switching sheets Solved/Closed

    Hello, If someone could tell me how to run a macro upon switching worksheets, that would be extremely helpful. If this is not possible, perhaps ru...

    D | Latest reply: D Jun 7, 2010
    2 replies
  • undoing a macro to retrieve info back Solved/Closed

    Hello, If I accidentally run a macro, can I (edit undo) to retrieve the information back to how it was? Configuration: Windows XP / Internet Ex...

    kat | Latest reply: kat Jun 7, 2010
    2 replies