Excel Forum

Ask a question
Search
Close
Results 5251 - 5300 of about 9,840
  • Merging two excel sheets Closed

    Hello guys im totally new here and i want to ask a question. I have two excel sheets that i want to merge. Let me explain what i want to do and i ho...

    savgeorg | Latest reply: TrowaD Nov 12, 2013
    11 replies
  • Conditional formatting for a range Closed

    Hi! I am working on a file where I have to format the cells in one column based on a list place in the same sheet in a different column. Basically...

    christieramos | Latest reply: rizvisa1 Nov 10, 2013
    1 reply
  • duplication Closed

    Hi, I a have a column A i.e names . for ex. 1 Row shailendra, 2 Row sailendra, 3 Row shylendra. above (3) names are same but spelling change now i...

    9000966 | Latest reply: 9000966 Nov 10, 2013
    2 replies
  • Dating Problem! Solved/Closed

    Hi Can you help? I need a cell to only input if a lead cell is blank but if the lead cell has a date format i.e 24/11/13 then to input that sam...

    rbmastertitan | Latest reply: rbmastertitan Nov 8, 2013
    6 replies
  • Matching data from two spreadsheets Closed

    I have 2 spreadwheets. One is a master equipment list with info stored according to Equipment #. The second is an invoice for equipment that is on th...

    jphorn | Latest reply: venkat1926 Nov 7, 2013
    1 reply
  • how to add a value to a cell if the other cell has text Closed

    Hi, i am not able to find how to do the following formula in excel. what is the exact formula for: "if the value of the cell A2 is text then t...

    jormis | Latest reply: ac3mark Nov 7, 2013
    5 replies
  • Link image as per cell value : Complicated Closed

    The explanation of the required details is in the attached sheet itself http://speedy.sh/M5SHA/Images.xlsm regards Pooja

    Pooja V | Latest reply: BunoCS Nov 7, 2013
    2 replies
  • Hide/Unhide an Autoshape or Picture in Excel Solved/Closed

    Hi All, Could anyone tell me the method to Hide/Unhide an Autoshape or Picture in Excel Spreadsheet? I know it is possible through Macro Codes, an...

    madambath | Latest reply: jerangkung Nov 7, 2013
    6 replies
  • conditional formatting of a cell if another cell is blank Closed

    Hello, All i am challenged in resolving the following problem I have and am hopefull that someone can help in Column E I have specific text "tier ...

    Ant104 | Latest reply: venkat1926 Nov 7, 2013
    4 replies
  • trying to copy data from one sheet to another and rearrange Closed

    I have an Excel sheet, and I need to clean the data and copy it to another sheet. The cells change by 11 between records. I tried creating the initial...

    wakesk8 | Latest reply: wakesk8 Nov 6, 2013
    1 reply
  • conditional formatting if a cell is blank and other has value Closed

    Hello, in Column E i have specific text "tier 2" or "Tier 1" i would like to format the color column L if Column E = Tier 2 and the value in the cor...

    Ant104 | Latest reply: Ant104 Nov 6, 2013
    0 replies
  • Need to copy a whole sheet into another Closed

    Working with 2 sheets, one as the invoice and the second as the master record. Everything entered into the invoice will be automatically copied into t...

    logsmein | Latest reply: TrowaD Nov 5, 2013
    1 reply
  • Excel count sheets in a workbook Closed

    how to count the no of sheets in my workbook, like a list or whatever, also get the sheet name against it,

    Muniz Reza | Latest reply: ac3mark Nov 5, 2013
    1 reply
  • excel how to change to value Closed

    Please help me to change this data which is highlighted in Yellow color to the other cell in values.. i cannot do any calculations on it...

    Muniz Reza | Latest reply: ac3mark Nov 5, 2013
    1 reply
  • Excel if statement using time Closed

    Hello, I am trying to do some conditional formatting using if statement. I have a spreadsheet that is supposed to flag targets based on a 24hr clo...

    carview | Latest reply: Kevin@Radstock Nov 5, 2013
    1 reply
  • Nested And/IF Statments Solved/Closed

    Hello and good day. I am in the process of putting together an annual bonus/vacation accural sheet and need some assistance with building a comple...

    nelsojm | Latest reply: nelsojm Nov 4, 2013
    3 replies
  • Excel worksheet auto generator Solved/Closed

    Hello, i have a workbook with a names sheet that has all the info I need put onto timecard and a master sheet with the timecard that the employee wil...

    Chemopp | Latest reply: rizvisa1 Nov 1, 2013
    10 replies
  • conversion of excel files to dbf files Closed

    need to convert excel (win 7) to dbf what software options are available

    roundengine | Latest reply: ClarkShane Nov 1, 2013
    3 replies
  • Formula to count if cells in consecutive columns are populated Closed

    Hello, I need an equation that will return a 1 in column F if data is available (cell is populated) in 2013 or last two years (2012 & 2013) or las...

    nycm | Latest reply: venkat1926 Nov 1, 2013
    1 reply
  • Need help with lookup? or if? command Solved/Closed

    Hi Everyone, Can someone help me with a command or macro that will look up the price of a product in a country from a reference worksheet and then fi...

    nycm | Latest reply: nycm Oct 31, 2013
    3 replies
  • formula needed. Closed

    Hi dear i am looking for an formula that can resolve the following issue. I have a table of: Actual...............................................

    ahamaz | Latest reply: Kevin@Radstock Oct 31, 2013
    2 replies
  • Compare cells of two columns excel 2007 Solved/Closed

    Hello, I have two columns with identical cells and I need to find those that are not the same. For example: Column1 Cell1 = "a", Column2 Cell1 = "...

    Baruch | Latest reply: Rajen Oct 31, 2013
    5 replies
  • cap-locks Closed

    Hello, Is there a way to make a spreadsheet only type in all caps? Configuration: Windows 7 / Internet Explorer 10.0

    KGRIFFITH | Latest reply: TrowaD Oct 31, 2013
    1 reply
  • CONDITIONAL FORMATTING Solved/Closed

    I need a formula stating that if cell R7 is blank, then Q7 is yellow. So if anything is entered in R7 then the cell Q7 is no color

    KGRIFFITH | Latest reply: KGRIFFITH Oct 31, 2013
    6 replies
  • Creating a new customised Excel workbook from a main workbook Closed

    Greetings First it is nice to join you in this forum, hoping I can add value in the future to whatever endeavors you have been delivering till date...

    Apprentice007 | Latest reply: Apprentice007 Oct 31, 2013
    0 replies
  • Excel Enter Key Closed

    Viewed your site to advise how to press the enter key and have the cursor move right in lieu of down as it is doing now. The instructions listed ...

    Tom Roberts | Latest reply: venkat1926 Oct 31, 2013
    1 reply
  • Copying data into a master spreadsheet Closed

    Hi i am trying to copy different worksheets on to a complete worksheet, i have recorded a macro but it doesn't collect any new information, how do i m...

    Princess1474 | Latest reply: TrowaD Oct 29, 2013
    1 reply
  • Formula help Closed

    I have a huge excel spreadsheet that I am needing to sort by type of loan (J3:J132) and then select the totals from that type of loan (D3:D132) and to...

    rgreen | Latest reply: TrowaD Oct 29, 2013
    1 reply
  • Help With Major Excel Problem Closed

    Please help with the problem if you can I have a single column of data numbering in 650k The Problem I have here is within this column I have com...

    nilnaij | Latest reply: TrowaD Oct 29, 2013
    5 replies
  • Need Macro- Copy Row and Insert 10 times Solved/Closed

    Hello, I have a similar question as this previous thread: https://ccm.net/forum/affich-107673-copy-row-and-insert-n-times but I'm not sure which ...

    nycm | Latest reply: nycm Oct 29, 2013
    2 replies
  • Delete selected data in Excel 2007 Closed

    Attached a link which will give the details http://speedy.sh/bQWZM/OutletsCode.xlsm thanks JS Desai

    JS Desai | Latest reply: JS Desai Oct 28, 2013
    2 replies
  • attach and excel file in kioskea Closed

    can you send me a stepwise info to attach an excel file. I am new to Kioskea and do not see any button or option. I have a question but need to at...

    JS Desai | Latest reply: JS Desai Oct 27, 2013
    2 replies
  • looking for a excel formula. Closed

    Hello, i have rate sheet of 20,000 entries. rate sheet have data like this. ---------Rate-1------Rate-2-------Rate-3 A-------0.16211 B-----...

    ahamaz | Latest reply: ahamaz Oct 26, 2013
    4 replies
  • How do I create a seperate .XLSM workbook for each list item? Closed

    Here is the data: A B C 1 Data1 Data2 Data3 2 0002 ABC $3.00 3 0002 ABC $4.00 ...

    Steve Gardipee | Latest reply: venkat1926 Oct 26, 2013
    1 reply
  • Excel to find a word within a cell within a sentance Closed

    2 things... 1. I need to find a word (several individual words actually) within a cell that is part of a sentence. The search will need to cover...

    MeNotYou | Latest reply: venkat1926 Oct 25, 2013
    4 replies
  • How do I change the formula based on text in another cell... Closed

    Example: In column C, I have either "C&D", "Concrete", "Dirt", or "Asphalt". Column D is a weight. Column E is the weight *$30 for "C&D" only....

    GrimmLynne | Latest reply: ac3mark Oct 25, 2013
    1 reply
  • using VBA to assess the result of different input variables Closed

    Hello, I have absolutely no idea how to go about this problem, and my VBA skills are quite weak. I have this data, consisting of 3 columns and a n...

    ugo234 | Latest reply: venkat1926 Oct 25, 2013
    1 reply
  • Creating search and update command buttons in a userform Closed

    Hello, Good afternoon. I am just new here. I am glad that i found this forum where in every one has right to inquire about solutions to there pro...

    sottojeromey | Latest reply: sottojeromey Oct 25, 2013
    0 replies
  • add blank rows Closed

    Hello, I am facing a problem in my excel sheet. i shall highly grateful to you if kindly give me a solution to my problem. In b column of the sheet ,...

    bijnan | Latest reply: venkat1926 Oct 25, 2013
    3 replies
  • excel VBA Solved/Closed

    Hi all, Greetings, could I get help, I am trying to write data into cells in a spread sheet, using an initial value, then adding a specific increme...

    ugo234 | Latest reply: ugo234 Oct 24, 2013
    5 replies
  • YES OR NO...IF SO.... Solved/Closed

    Hi I need to ask a cell to do two functions. So if a cell (drop down list) has yes/no...then another cell will.....when yes is selected then d...

    rbmastertitan | Latest reply: Tim Oct 24, 2013
    2 replies
  • Need to move data from one sheet to another with a comparesion Closed

    i have a column name bld_id in both sheets , need a compare if value is same then move the second column to sheet 2

    anilsahu7118 | Latest reply: anilsahu7118 Oct 24, 2013
    0 replies
  • Regarding email notification in Excel 2010 Closed

    Hello, I am preparing a sheet for my company leaves and in this sheet I want users to put their leave date and once they make changes in the leave it...

    Ansha_1 | Latest reply: ac3mark Oct 23, 2013
    1 reply
  • changing date format Closed

    i am unable to change my date format in excel sheet. please help me

    rajani chalu... | Latest reply: ac3mark Oct 23, 2013
    1 reply
  • Macro to Export Data to New Sheet with tabs Closed

    Hello, I am trying to create a way to export select data from a spreadsheet to a new one and send certain bits of data associated with a number to ...

    darkstar911 | Latest reply: darkstar911 Oct 22, 2013
    0 replies
  • add row Solved/Closed

    I am trying to create a macro that will insert a set amount of blank rows into an existing spreadsheet Here is a sample: Currently: in column ...

    bijnan | Latest reply: bijnan Oct 22, 2013
    0 replies
  • Converting Rows of data into Columns Solved/Closed

    Hi everyone, I hope you all can help. I have a file in with 17,000 lines of data in rows that I need converted into columns. I don't work with Ex...

    chuaf24 | Latest reply: chuaf24 Oct 22, 2013
    3 replies
  • How can I create a macro for a new spreadsheet Closed

    Hi I need to create a Macro that generates a new spreadsheet based on the values that have an X on the third column. Here is an example of the data. ...

    CVV | Latest reply: ac3mark Oct 21, 2013
    1 reply
  • Macro to traspose data Solved/Closed

    Hi I need a help I need to transpose my data following way for a longitudinal analysis; ID Day1 Day2 Day3 Day4 Day5 Day...

    aac1975 | Latest reply: TrowaD Oct 21, 2013
    5 replies
  • want one cell to be highlighted if i type something in next one Solved/Closed

    Hello, I want B1 to be highlighted as green if i type any text in C1. Please help me. Regards Saurabh

    Saurabhmitra07 | Latest reply: Saurabhmitra07 Oct 20, 2013
    2 replies