Excel Forum

Ask a question
Search
Close
Results 4001 - 4050 of about 9,830
  • Highlight any dates that exceed a target date Closed

    Hello, Wonder if someone can help me, I have a sheet that i want to calculate and highlight if one date is beyond another then highlight it red IF...

    harpo1885 | Latest reply: cmarzahn Mar 10, 2015
    3 replies
  • i am trying to add a calender to excel but getting Compile error Closed

    Hello, This is the code i am using but getting Compile error can't find project or library. Private Sub Calendar1_Click() ActiveCell.Valu...

    Dean | Latest reply: Dean Mar 10, 2015
    0 replies
  • Updating master sheet, then automatically update other sheet Closed

    Hello, Can you please help I have 6 worksheet in my Workbook, so I'm trying to come up with a way in which I can update master sheet, then it auto...

    Otshepeng | Latest reply: Otshepeng Mar 10, 2015
    0 replies
  • Compare Common names Closed

    Hello, I have a excel sheet in which I want to highlight any time there is a common name between the two columns. the problem is naming is differe...

    Arun | Latest reply: Arun Mar 10, 2015
    0 replies
  • how to convert number in word in excel Closed

    how to convert number in word in Excel

    28965 | Latest reply: Computertech Mar 10, 2015
    3 replies
  • excel formula Closed

    Hello, I'm looking for a simple formula to convert numbers in to words in Excel 2007. with example. Configuration: Windows 7 / Internet Explo...

    mayuri | Latest reply: kieferschild Mar 10, 2015
    1 reply
  • Sheet One Items Transferred to Sheet Two. Closed

    I have few items in sheet one and want to transfer to sheet two. Please help me.. Sheet 1 consist of:- S.no Tanker Date Voucher ...

    srigopal | Latest reply: vcoolio Mar 10, 2015
    22 replies
  • scroll lock Closed

    Hello, Don't have a scroll lock key and no F14 key. I unlocked scroll on Excel Sheet and arrows are still scrolling and do not navigate side to s...

    MG | Latest reply: MG Mar 9, 2015
    0 replies
  • Ops Mgr Closed

    im trying have the current date go into one cell (A1) when an order number is entered in another cell (A2) but don't want the date to automatically up...

    dbmich | Latest reply: dbmich Mar 9, 2015
    0 replies
  • Copying Data from One Excel Workbook To Another Closed

    Hello, Newbie here, on my organization my reportees are sending me a report on a daily basis, the pain is to collate each of these sheets onto 1...

    sandeep | Latest reply: sandeep Mar 9, 2015
    0 replies
  • requesting Formula in excel on if condition / date function Closed

    Hello, I need the Formula in Excel sheet If A2 is having a date. I need the date on C2 After 2 days. If the second day is Saturday it should b...

    KANNAN | Latest reply: cmarzahn Mar 9, 2015
    1 reply
  • compare data in two different excel files Closed

    Hi, How to write a macro to compare data in one excel file with data in other excel file i.e., cell wise for ex: I have one file with two columns...

    Archu | Latest reply: Computertech Mar 9, 2015
    1 reply
  • Drop down list treated as a selection variable Closed

    Hello, I am trying to see if this is possible and if so how: Problem: Make the same "selection variable" ,i.e. word or number chosen from the dro...

    JKonecz | Latest reply: JKonecz Mar 9, 2015
    0 replies
  • Excel Date Function dd/mm/yyyy Closed

    I have a column in excel as dd/mm/yyyy with my date function set as English (US) however excel is sometimes picking up some dates as mm/dd/yyyy and ot...

    Lindsay | Latest reply: cmarzahn Mar 8, 2015
    1 reply
  • Excel 2011 not recognizing keyboard shortcuts? Closed

    Hello, I have been given an assignment which gives me quite specific instruction on Excel however while things like command+C works the more complic...

    HeiHei | Latest reply: cmarzahn Mar 7, 2015
    1 reply
  • For AND condition Closed

    Hello, ANd condition on two different columns - what is the solution please Configuration: Windows 7 / Chrome 41.0.2272.76

    Ashok | Latest reply: cmarzahn Mar 7, 2015
    1 reply
  • Copy data to new sheet.. more tricky than I imagined Closed

    Hi all, Could someone please help me out with this? I've tried looking at other similar questions and solutions but as an Excel beginner I couldn'...

    ElPolloDiablo | Latest reply: venkat1926 Mar 7, 2015
    3 replies
  • Compare on a condition and Highlight the Difference Closed

    Hello, I have a requirement to compare two different tabs on same sheet and display the difference either by highlighting the rows or add a comment....

    HolyAngel | Latest reply: RayH Mar 6, 2015
    3 replies
  • I want to label specific cells with numbers in a sequence Closed

    Hello, I am new to VB and trying to write a script that has the below functionality, could anyone help me get started or point me in the right dir...

    paul | Latest reply: paul Mar 6, 2015
    0 replies
  • Excel formula Closed

    Hello, I want the answer of this formula =IF(AND(L13

    Simran | Latest reply: Computertech Mar 6, 2015
    1 reply
  • adding a loop to macro to insert pictures Solved/Closed

    Hello, Could someone please help me in writing a loop in this macro in excel : I have an excel sheet where it contains the name of the pictures in c...

    vba | Latest reply: M_TheJax Mar 5, 2015
    7 replies
  • I want to label specific cells with numbers in a sequence Closed

    Hello, I am trying to write a script that has the below functionality: - From top of sheet, check cells with a value in a specific row - Replac...

    Paul | Latest reply: Paul Mar 5, 2015
    0 replies
  • Color Coding variable Pivot Row Label Interior Closed

    Hello All I have a coding problem I have tried numerous ways to solve with no success. I have a macro generating a pivot table for weekly data tha...

    BwanaBill | Latest reply: BwanaBill Mar 5, 2015
    1 reply
  • Problem with adding and updating comments from value in VBA Closed

    Hello and Greetings, Thank you for taking the time to read my post; I do appreciate it. I have been struggling with a trying to write a specific VB...

    cmorris9893 | Latest reply: cmorris9893 Mar 5, 2015
    0 replies
  • Entering a range of data in an IF formula Closed

    Hello, I am trying to write a formula where: if any of the values in colum B are equal to the values in column M, then an email address in N1 will po...

    Bekaboo | Latest reply: Bekaboo Mar 5, 2015
    0 replies
  • using if condition in excel sheet. Closed

    Hello, I need the Formula in Excel sheet If A2 is having a date. I need the date on C2 After 2 days. If the second day is Saturday it should b...

    KANNAN | Latest reply: KANNAN Mar 4, 2015
    0 replies
  • excel assistance Closed

    Hello, Can i PLEASE get some help with this problem? 5KM or more and less than 15km, the cost will be 5... Thanks to everyone in advance

    njiebadou | Latest reply: njiebadou Mar 4, 2015
    2 replies
  • transfer 5000 records to a new spreadsheets with 50 records in e Closed

    I have a excel file which contains 5000 recores, i want to transfer 5000 records to a new spreadsheets with 50 records in each new spreadsheets i.e to...

    khanjandesai | Latest reply: venkat1926 Mar 4, 2015
    1 reply
  • Help in Duplicating Row Info based on adjoining Cell Response Closed

    Hello, I am seeking assistance in determining the best way to complete a worksheet wherein I need to create a new row which duplicates some inform...

    gtpinoy | Latest reply: gtpinoy Mar 3, 2015
    0 replies
  • A Macro to repopulate a row into a new row based on the response Closed

    Hello, I would like a macro that would repopulate a new row based on the results of a cell within that row. Example: Project A Complete...

    Glenn | Latest reply: Glenn Mar 3, 2015
    0 replies
  • How to export data from different tabs in Excel Closed

    Hi, I need help with a spreadsheet that has 4 tabs. My tabs are: Manager, Analyst_1, Analyst_2 and Analyst_3. I need a formula that can t...

    JSharon | Latest reply: JSharon Mar 3, 2015
    6 replies
  • VBA code to update excel comments when the cell value changes Closed

    I have a workbook with several worksheet tabs. One of the worksheet tab contains a column of percentages (that are composed of a VLookup formula from ...

    cmorris9893 | Latest reply: cmorris9893 Mar 3, 2015
    0 replies
  • Change calculated to a hard date Solved/Closed

    I used a +1 formula to create dates in column A. Now I want to make these "hard" dates so they don't keep changing every time I add a row. Thank you...

    Ritabook | Latest reply: Ritabook Mar 3, 2015
    2 replies
  • VBA : Copy "Pivot like layout" to "data dump layout" data Closed

    Hello, I am looking for a solution to my challenge. I have a spreadsheet that looks like this. Name - Column Name 1 - Column Name 2 Column...

    stan-star | Latest reply: TrowaD Mar 3, 2015
    1 reply
  • Create a search box and then copy to new worksheet. Please help Closed

    Hello, this is what I have so far by searching online and it is not working :( It keeps sending me a message " Variable not defined " Please help me ...

    ctran123 | Latest reply: ctran123 Mar 3, 2015
    0 replies
  • Macro creation Closed

    I need to combine data in two different Excel worksheets. 1. list with user names and their ids and groups and to input this data to the list with j...

    techinheals | Latest reply: TrowaD Mar 3, 2015
    1 reply
  • Excel-Changing calculated dates to "hard" dates Closed

    Hello, I used a simple +1 formula to create dates in column A. Now that I have the dates, I want to make them "hard" dates so they don't change eve...

    Ritabook | Latest reply: TrowaD Mar 3, 2015
    1 reply
  • Changing cell color with either conditional formatting or macro Closed

    Excel 2003 or 2007, 3 preferred. I have a column 'E' that contains either 2 or 4 digit text codes (MR, SP, BA SC, EU WO, etc), up to 50 unique codes....

    bealerusa | Latest reply: bealerusa Mar 3, 2015
    6 replies
  • Auto Fill Form? Closed

    Hello, I have a spreadsheet on which I have formulas for all my recipes. I have a column that I enter the amount of each recipe I want to mix. I h...

    Todd | Latest reply: Todd Mar 3, 2015
    0 replies
  • If function with date Closed

    Hello, The concept is "If the days exceeds 30, the entire cell should be applied with some color or highlighted". Please respond Configurati...

    ramya | Latest reply: vcoolio Mar 3, 2015
    1 reply
  • VBA code to copy "Pivot like layout" to "data dump layout" d Closed

    Hello, I have a spreadsheet that looks like this. Name - Column Name 1 - Column Name 2 Column Name 3 - Column Name 4 Johnny - 5 - 0 - 0 - 4 ...

    stan-star | Latest reply: stan-star Mar 2, 2015
    0 replies
  • Macro is not working Closed

    Hello, The first time the macro worked, I was so happy! (I used it once) Now is not working anymore, no idea why. Can someone help me? I rea...

    Nery | Latest reply: TrowaD Mar 2, 2015
    1 reply
  • Filter according to 'typed' value Closed

    Hello, I need an autofilter to change according to a 'typed' value on another worksheet. I have found this code, which works when the typed val...

    QPRMinty | Latest reply: TrowaD Mar 2, 2015
    1 reply
  • conditional replication of cell data Closed

    I am using Excel 2013 I am using a spreadsheet for a TO DO list. The column headings are: "Item" (with rows numbered from 1, 2....) "Task Descri...

    ramjar | Latest reply: ramjar Mar 2, 2015
    0 replies
  • move data from one wrksheet to another using submit button Closed

    hello im working on a project and ive create a workbook in which I place data into a worksheet known as "processing" which serves as a main page in w...

    all4love | Latest reply: vcoolio Mar 1, 2015
    2 replies
  • changing of number into word Closed

    Hello, Can you please help me how to change number into word in Excel 2007 Configuration: Windows 8 / Chrome 40.0.2214.115

    Ghafoory | Latest reply: xpcman Feb 28, 2015
    1 reply
  • Transpose convert columns to rows macro for excel Closed

    Issue I have huge data in a single column & each data group is seprated by single empty cell For Example : Company Name 1 Address ...

    coolpiece | Latest reply: coolpiece Feb 28, 2015
    0 replies
  • Transferring numbers to new worksheet automatically Solved/Closed

    Hello, I'm making a spreadsheet showing weekly costs. I've set it up so that each worksheet is a week, with totals using =SUM. I want to transfer th...

    Tresi | Latest reply: tresi Feb 28, 2015
    2 replies
  • Notification Closed

    Hello, I was wondering if it is possible to create a popup when a user has a shared excel spreadsheet open preventing others from using it. The popup ...

    Abukova | Latest reply: vcoolio Feb 27, 2015
    1 reply
  • convert number into words Closed

    how i can convert numircal in words

    RKB0375 | Latest reply: Computertech Feb 27, 2015
    1 reply