Excel Forum

Ask a question
Results 4851 - 4900 of about 9,870
  • 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
  • VBA Module with checkboxes to use in excel Closed

    Dears, I will be very grateful if some one can help me in the following. I have excel file include 50 sheets for customers, in each sheet I have 2...

    issa | Latest reply: RayH Apr 14, 2011
    1 reply
  • Delete data in excel with macro Closed

    Hello, plz can u sent coding for following matter: i want to use macro in exl which is find the total word & del all data from right side plz pl...

    Jayesh | Latest reply: RWomanizer Apr 14, 2011
    1 reply
  • 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
  • conditionnal formatting using macro Closed

    Hello, I am trying to create a calendar in excel in which certain days shoulded be marked with a colour. In my excel file, one day is one column ...

    Nikita | Latest reply: Niki Apr 13, 2011
    2 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
  • Visual basic find number if can't find look in next sheet Closed

    Hello, I have a list of 240,000 numbers in excel on 4 sheets is it possible to write a macro to open up an input box put in the number and it search...

    flyreel | Latest reply: RWomanizer Apr 13, 2011
    1 reply
  • Deleting rows and columns in a spread sheet Closed

    Hello, I'm doing a project that requires 31 rows and 7 columns in a spread sheet i want to delete all the rows and have only 31 rows left but i ...

    cooljennifer11 | Latest reply: venkat1926 Apr 13, 2011
    1 reply
  • Macro run time error Closed

    Configuration: Windows 7 / Firefox 3.6.16 Hi, I have a peice of code that filters a column for zero values and returns the rowcount. I tried...

    Lopez | Latest reply: LopezGG Apr 12, 2011
    6 replies
  • If a range of cells = to a name Closed

    Hello, Hope someone can help me? I have a list of text in 1 sheet, lets say: A1 Image Gallary A2 Welcome Message This list are generated...

    Stormdronk | Latest reply: venkat1926 Apr 12, 2011
    1 reply
  • 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
  • Comparing Two excel files Closed

    Hi I need VBA code to compare two sheet's cell content in different workbook.Its very urgent pls help me. Thanks in advance. Configuration: Wind...

    joe | Latest reply: RWomanizer Apr 11, 2011
    1 reply
  • 100 Mails data in on excel Closed

    Hello, I want to macro, where i can copy 100 Emails data in one excel. Thanks, Kolturra Configuration: Windows XP / Safari 534.13

    Kolturra | Latest reply: RWomanizer Apr 8, 2011
    1 reply
  • Excel macro, if > 0 add 1 to cell!?!? Closed

    Hi all I am fairly new to writing macros and am completely baffled by what you guys know. I have been reading for hours on various websites etc ...

    Craig Farish | Latest reply: RWomanizer Apr 8, 2011
    1 reply
  • Advanced spreadsheet help needed Closed

    Hello, im tryin to setup a spreadsheet but the stuff i learnt was oh so long ago....... i need a cell to look at another cell and if the value is...

    Marshski | Latest reply: RWomanizer Apr 8, 2011
    2 replies
  • Excel Data Intervals Closed

    Hello, In worksheet 1, I have data in columns. I want to revise the formatting of this data in worksheet 2 so that a single record, the data from...

    stone-guy | Latest reply: RWomanizer Apr 8, 2011
    1 reply
  • Excel 2003 Closed

    Hello, I know that you can use conditional formatting in excel 2003 to format a blank cell a certain color until text is entered into that same cell...

    Mac | Latest reply: venkat1926 Apr 7, 2011
    1 reply
  • need to pull data from deferent sheets Closed

    Hello, I need to pull data from diferent sheets but I need to pull only if the names are the same. I need to pull from colum AI from diferent s...

    me | Latest reply: RWomanizer Apr 7, 2011
    1 reply
  • Macro for delete a mail as soon as it read Closed

    Hello, I want to send a mail to some one, the attachment contains some personal data. so i wants that as soon as he read the mail the mail will b...

    RWomanizer | Latest reply: RWomanizer Apr 6, 2011
    4 replies
  • Excel formula question Closed

    Hello, Im not good at terminology. Sorry in advance. I have a spreadsheet that has several formulas. for this instance, M2 =Q1-(O2) where the ...

    jimmy | Latest reply: aquarelle Apr 5, 2011
    1 reply
  • Match two rows with same values but not in order excel Closed

    Hello, I'm New bee if some one could help, I wanted to match coloumn B with the values of column C which has the same values as C but less in num...

    NewBee | Latest reply: RWomanizer Apr 5, 2011
    4 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 - Formula for taking avg with filters Closed

    Hi Experts, I am new with excel and want to do the follwing. 1. I have sheet of all students with their names, subjects and grades 2. I have a...

    sj | Latest reply: RWomanizer Apr 4, 2011
    2 replies
  • Microsoft excel macros - Workbook names Closed

    Hello, I am having a slight issue with a Macro within excel. I have a template file, with a working macro which does X Y and Z, (Summary is tha...

    Dan | Latest reply: rizvisa1 Apr 3, 2011
    1 reply
  • Macro between workbooks Closed

    Hello, I tried to look for answers for some questions i couldn' find. My question is I have to run a Macro in such a way that. I have to sel...

    Naveen | Latest reply: Ambucias Apr 3, 2011
    1 reply
  • 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
  • Can you take the same row of data from different sheets and paste them in differ Closed

    Hello, I have 12 sheets. I want to take the data (same row on each sheet) and paste that data into a new sheet but each row from the sheet will be ...

    Ali | Latest reply: rizvisa1 Apr 1, 2011
    6 replies
  • Find and replace with excel macros Closed

    Hello, What I am trying to do is copy a cell from tab one (always the same cell) and then look for it in a column in another tab. Once I have fou...

    Rachel | Latest reply: rizvisa1 Mar 31, 2011
    3 replies
  • how to sort more than one condition in excel Closed

    Hello, I have a spreadsheet that determines quotes that need to be turned in there are several situations when the quotes have to be turned in suc...

    Mare | Latest reply: TrowaD Mar 31, 2011
    1 reply
  • Time sheet Closed

    Hello, This is quite complicated to explain, therefore, I hope I don't confuse you. I am doing out timesheets. The criteria is as follows: Time p...

    Karl | Latest reply: Ambucias Mar 31, 2011
    2 replies
  • 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
  • Excel personnel tracking sheet Closed

    Hello, I am trying to make an excel sheet that counts consecutive days that a person is on the list...the list being days that certain person...

    hudabble | Latest reply: RWomanizer Mar 28, 2011
    2 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
  • If/Then Excel Question Closed

    Hello, I'm trying to get the If / Then function to do what I want and apparently I'm missing something. For example, If d2 is greater tha...

    Mike | Latest reply: rizvisa1 Mar 24, 2011
    1 reply
  • 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 Macro to convert 'AAA-####' to 'AAA ### Closed

    Hello, I'm working on a project and need a macros that will look at all the cells in a column and covert the value in the cells from AAA-#### to A...

    john | Latest reply: rizvisa1 Mar 23, 2011
    1 reply
  • 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
  • help me with excel 2003 Closed

    hello, i need some help with excel 2003. i have the date in d6. And an amount in e6. Now, I want the g6 cell to reflect the following values- a) ...

    grace | Latest reply: RWomanizer Mar 22, 2011
    7 replies
  • I have 3 columns of numbers, if my number is between columns 1 and 2 Closed

    Hello, I have three columns with 198 numbers in each. I want to find a formula to find if a specific number is between column 1 and 2, returns value...

    Frustrated i... | Latest reply: RWomanizer Mar 22, 2011
    2 replies
  • Pivot table + VBA Closed

    Hello, I am very much new to VBA programming in Excel. This is the code. Private Sub Worksheet_Change(ByVal Target As Range) Dim r As Range I...

    shockers | Latest reply: RWomanizer Mar 21, 2011
    1 reply
  • To compare substrings of two columns Closed

    Hello, I was looking to compare corresponding cells of two columns for match in substrings of both the columns in Excel 2010.My data looks as Col...

    GD | Latest reply: rizvisa1 Mar 20, 2011
    5 replies
  • Problem in excel Closed

    dear sir, i have a problem in excel In column A have 50000 data including 9 digits . and in Column B I have 25000 data with 9 digit number. most o...

    dungel | Latest reply: rizvisa1 Mar 20, 2011
    1 reply
  • Excel: Matching/Sorting Closed

    Hello, I'm dumb, lazy, and having trouble finding an efficient way to complete a price list for my store. Here's what I need to do. I have two fi...

    needysheep | Latest reply: rizvisa1 Mar 18, 2011
    1 reply
  • Compare 2 sheets - output in sheet 3 - Excel Closed

    Hello, I have 2 sheets. For example: Sheet 1: A2 = 777 B2 = 5 A3 = 438 B3 = 4 A4 = 555 B4 = 3 Sheet 2: A60 = 777 ...

    vicgarin | Latest reply: TrowaD Mar 18, 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