Excel Forum

Ask a question
Search
Close
Results 2351 - 2400 of about 9,870
  • Autopopulating across tables Closed

    Hello, Hoping for some help with the following Excel conditional query. Hoping to automate so that Table 1 can autopopulate Table 2 with the re...

    Utopia18 | Latest reply: Utopia18 Jun 23, 2016
    0 replies
  • IF statement that adds 1 for specific text Closed

    Hello, I have a spreadsheet that I have a column (I2-I48) that contains text for different ticket types. I am trying to create a formula that give...

    Jet | Latest reply: Mazzaropi Jun 23, 2016
    1 reply
  • Copy cell value between sheets if it matches a criteria Closed

    Hello, I am looking for assistance in getting a formula to copy cell values between sheets if it matches criteria. Scenario - sheet 2 will have...

    Prashanth | Latest reply: Prashanth Jun 23, 2016
    0 replies
  • Find the last blank cell Closed

    Hello, I am looking for a formula/method of finding a last blank cell in a column example column A 1 2 3 4 blank cell 1 2 3 ...

    vutanhuynh | Latest reply: Mazzaropi Jun 23, 2016
    3 replies
  • Employee Scheduling using Excel Closed

    Hello, I'm trying to create an excel sheet for employee scheduling. If I type the name of the person, is it possible to create a formula or condi...

    Yeop | Latest reply: Yeop Jun 23, 2016
    0 replies
  • Auto populate cells based on the number in another cell Closed

    Hello, I was wondering if it's possible to "tell" excel to Auto fill in a row of cells with specific text, based on a value in another cell. For ...

    Wonderingabo... | Latest reply: Wonderingaboutexcel Jun 22, 2016
    0 replies
  • If then formula for dates and days of the week Closed

    i need an excel formula that will calculate days according to rules, so I have a list of dates and in the column next to it I need it to add 13 days t...

    anita | Latest reply: anita Jun 22, 2016
    0 replies
  • Merge data based on condition Closed

    Hello, I have multiple sheets with different columns, the header is mentioned in row 3 and there are few headers which are common across all the s...

    Shridhar | Latest reply: Shridhar Jun 22, 2016
    0 replies
  • Need a macro to duplicate rows of text based upon a cell value Closed

    Working on Mac vs. 15.17; I had a macro that use to work in a previous version of Excel. But I cannot get it to work now. I do not know VB or code. Ca...

    jnowell | Latest reply: jnowell Jun 22, 2016
    0 replies
  • Matching Names with two separate formats Closed

    Hello, I am trying to create a table where in one column has the names from File1 in format Last, First ex. Gates, Bill without duplicates. The in...

    Alex | Latest reply: Alex Jun 22, 2016
    0 replies
  • How to extract Date Before a particular word in a cell Closed

    Hello All, .I have a particular column in an excel worksheet that contain something like "AUXID9016700# 16/06/2016 8:54:25 AM call received fro...

    kayclan | Latest reply: kayclan Jun 22, 2016
    0 replies
  • Help needed for copying cells from one sheet to another Closed

    Hello, Guys i'm new here, so pleace don't be hard on me :) I need your help for doing the following: There is one column A filled with names on ...

    r.rafailov | Latest reply: r.rafailov Jun 22, 2016
    0 replies
  • Excel Formula Closed

    Hello everybody! That seems so simple but I can't do it :( I would like to know the formula for this: If any text is found in cells T23 U23 V2...

    augustaD | Latest reply: fdibbins Jun 22, 2016
    3 replies
  • Names matching Closed

    Hello, I have two columns A and B, in the both columns i have the names.i have to match the all the A columns names with the B column names and B ...

    venkataswamy... | Latest reply: fdibbins Jun 22, 2016
    1 reply
  • Copy all data from multiple sheets to one new sheet using VBA Closed

    Hello, I have Multiple files in a folder.i wants to copy all Files data (i.e.all columns to new sheet) to one new sheet. E.g. file 1 Contains 5 colu...

    @mar12 | Latest reply: @mar12 Jun 22, 2016
    0 replies
  • A Macro to Copy Rows by Value Cho Closed

    Hello, I would like to know if we can write a macro to copy a specific number of rows, which will be 24, 32 or 48. These values will be include...

    Goldenpetals | Latest reply: Goldenpetals Jun 21, 2016
    0 replies
  • insert all the photos I have in a "certain" folder. to excel Closed

    Hello everyone, I wonder if anyone can help to create a macros. What I want is to insert all the photos I have in a "certain" folder. to excel. ...

    Peter | Latest reply: Peter Jun 21, 2016
    0 replies
  • Roster Management Spread Sheet. Solved/Closed

    Hello, Can anyone help with a spreadsheet to manage fatigue management. I have a work project where I need 20 people and for both day and night ...

    ad1959 | Latest reply: TrowaD Jun 21, 2016
    1 reply
  • Finalizing MACRO Closed

    Hello, I've tired to work with this MACRO but I am trying to combine the content in order for it to work yet I keep getting bugs. The purpose of ...

    Eddie | Latest reply: TrowaD Jun 21, 2016
    1 reply
  • If certain 'type' is in col. K have whole row copy to new sheet Solved/Closed

    Hello, I am wondering if it is possible to have a whole row copy to a designated sheet based off of the value in a column. So for example if my ro...

    Dani | Latest reply: vcoolio Jun 21, 2016
    2 replies
  • Two-way relationship in PowerPivot Closed

    Hello, I have begun using a PowerPivot with the Excel 2013 Data Model to see if it could satisfy some of my needs. Basically, in my first simple ...

    TheJuice | Latest reply: TheJuice Jun 21, 2016
    0 replies
  • Finding MAX value with criteria list Solved/Closed

    Hello Chaps I don't often ask for help here but this one has stumped me. For a dashboard of sorts... I have a list of values in column S. E...

    RayH | Latest reply: fdibbins Jun 20, 2016
    11 replies
  • Change color of cells in Excel based on data in other cells Closed

    Hello, I have a question for Excel 2010 Conditional Formatting. How can I change the color of a cell to red if the value in another cell is diffe...

    brohera | Latest reply: Mazzaropi Jun 20, 2016
    1 reply
  • Change color of a cell if value in other cell is not the same. Closed

    Hello, I want to be able to change the color of a cell to red if the value in another cell is different. e.g if cell A1 is $0 and cell AF is $5 th...

    brohera | Latest reply: brohera Jun 20, 2016
    0 replies
  • Convert Single Column to Rows, into Matching Rows Solved/Closed

    Hi, I would really appreciate any help with an issue I currently have. I have a file which downloads as ASCII (text), and when opened in excel give...

    alansanderson | Latest reply: TrowaD Jun 20, 2016
    4 replies
  • Help with formatting Closed

    Hello, Hi everyone. I am looking to do some conditional formatting and I need some assistance. Can someone please help me to understand how I can ...

    JP | Latest reply: fdibbins Jun 20, 2016
    1 reply
  • How to do conditional colour fill. Closed

    Dear CCM team I want to have cell colour of cell AL3 to green if AK3 > or = D3 and the colour should be red if it do not meet this condition. Kindl...

    t_subhash | Latest reply: fdibbins Jun 19, 2016
    1 reply
  • Excel error Closed

    Hello, I am working with MS Excel 2010. While inputting data in a four-sheet file, older data of one sheet keeps being replaced by newly added dat...

    HangNguyen96 | Latest reply: HangNguyen96 Jun 19, 2016
    2 replies
  • VBA code for excel Closed

    Dear Expert, Hope you will be in good health! This is Santosh from India (Gurgaon). I need your help to get images saved in the excel sheet o...

    excelme | Latest reply: ac3mark Jun 18, 2016
    1 reply
  • Need help with counting value formula Solved/Closed

    Hello, I am brand new. I am trying to figure out a score based counting formula. I have columns with Name, Status, Rank and Value I want the v...

    QAA007 | Latest reply: QAA007 Jun 17, 2016
    3 replies
  • Extract data from one sheet to another Solved/Closed

    Hello, I have two sheets of data with almost same columns but sheet 2 has an extra column. How to match the data of sheet 2 with the data in sheet 1...

    phanikr | Latest reply: Mazzaropi Jun 17, 2016
    1 reply
  • Multi-Sheet budget Closed

    Hello, I'm trying to build an budget in Excel. I want a master sheet that lists all expenses/income with separate sheets for each line item in the...

    Theresa | Latest reply: Theresa Jun 17, 2016
    0 replies
  • copy and paste check box last row Closed

    Hello, I am trying to use check boxes in order to copy and paste values over to another worksheet automatically. This means multiple items nee...

    Roy | Latest reply: Roy Jun 17, 2016
    0 replies
  • i wants to copy single row data from multiple file to new sheet Closed

    Hello, i wants to copy single row from each xls file stored in a folder to sheet where i am coding on that sheet as a column. e.g. File1 contains...

    Amar | Latest reply: Amar Jun 17, 2016
    0 replies
  • move data Closed

    Hi I have list of 50 or so names with corresponding columns on one worksheet and i want to automatically all move the rows with the same name to ind...

    amessina | Latest reply: amessina Jun 16, 2016
    0 replies
  • Cant open a file. Closed

    Hello, I have some problems not with excel, but with a .xlsx file , I tryed to copy ,but system writes , that file has wrong end ,and copied file do...

    DarylSimon | Latest reply: DDson Jun 16, 2016
    1 reply
  • Copy a row from one worksheet to another, based on criteria Solved/Closed

    Hi Im a new user and im trying to make a roster sheet and really need some help any help is absolutely appreciated. I have some good formulas alread...

    Amegolas | Latest reply: TrowaD Jun 16, 2016
    5 replies
  • Cell updated when if condition is changed (macro) Closed

    Hello, Can anyone help me with a simple thing I cannot get done ? Using a macro, I want the value (integer) of a cell to be changed depending o...

    Jerry | Latest reply: TrowaD Jun 16, 2016
    3 replies
  • Macro to send an email when a cell value changes to an email Closed

    Hello, I use Office 2013 for everything. I am trying to write a macro that will send an email from outlook to an email address in a given cell ...

    Colin | Latest reply: Colin Jun 16, 2016
    0 replies
  • convert date of birth into words Closed

    if I write 11.07.1982 in A2 ,how to get the appearance like this Eleventh July Nineteen Eighty Two Thanks

    pandianjothi | Latest reply: Ambucias Jun 16, 2016
    1 reply
  • data transfer from all sheets to 1 Closed

    Hello, please help me.. i am trying to make a production report & for that i have to copy data from numerous sheets to 1 sheet & then calculate. s...

    amar | Latest reply: vcoolio Jun 16, 2016
    1 reply
  • is it possible to use 5'-2 1/2" in a formula instead of decimals Closed

    Hello, please a need some help. is it possible to use 5'-2 1/2" in a formula instead of decimals or converting it into inches with a decimal? Any ad...

    lynng | Latest reply: lynng Jun 15, 2016
    2 replies
  • date sort Closed

    Hello, I have an Excel spreadsheet with training expiration dates. How do I sort/select for "dates on or before [another date]"? I know it can be ...

    Notatechie | Latest reply: Notatechie Jun 15, 2016
    0 replies
  • Replacements Closed

    Hello, Is there a way to replace certain text with other certain text? for example... if I enter this column contains apple - red orange - ora...

    PJ | Latest reply: PJ Jun 15, 2016
    0 replies
  • Automatic Email Sending Macro Closed

    Pls, I need a VBA macro that can send a mail to a specified email address. when a command button is clicked in the Excel environment, a mail message i...

    Wingie | Latest reply: Wingie Jun 15, 2016
    0 replies
  • Write text in adjacent cells if one cell value is ___? Solved/Closed

    Hello, My knowledge of excel is very basic, but I am interested to know if I can find an easier way to enter information. I'm a tea manufacture...

    teaguru | Latest reply: teaguru Jun 14, 2016
    2 replies
  • Excel Macro for a very customized group by function Closed

    Hello, I would like to generate a report like the attached with this mail. The requirement is - In the Sample Data, Source tab contains data for pro...

    Indranil | Latest reply: Indranil Jun 14, 2016
    0 replies
  • How to convert Date of Birth to word in Excel Closed

    Dear sir, I have placed my date of birth 25/04/1977 in one cell in excel and I need the result as "Twenty fifth April Nineteen Seventy Seven "as in...

    kjustind | Latest reply: JDK Jun 14, 2016
    2 replies
  • VBA Formula; Automatically update multiple workbooks from MASTER Closed

    Hello, I am trying to help a friend with his restaurants. There is a MASTER list with all the food/drink items. There are 7 locations. Each...

    Jr | Latest reply: TrowaD Jun 13, 2016
    1 reply
  • Duplicate row Closed

    Hello, How would the formula look like for the following: Sheet 1 has 100 rows Sheet 1 has 6 columns Row 1 has headings Formula would go o...

    Hector | Latest reply: TrowaD Jun 13, 2016
    1 reply