Excel Forum

Ask a question
Results 951 - 1000 of about 9,850
  • Conditional Formatting Closed

    I wondered if you could assist please? I currently have a column of dates that change to a bold red if the date is past. However, I require the date...

    TraceyLongstaff | Latest reply: Mazzaropi Oct 10, 2017
    1 reply
  • How to update data between 2 sheets using Google Spreadsheet Closed

    Hello, I have created a form linked to Google Spreadsheet(named Form) to collect customer data like name, email, phone number and concern. I have an...

    faizan | Latest reply: faizan Oct 10, 2017
    0 replies
  • How to use a macro to check data in 2 work sheets Solved/Closed

    Hi team I have 2 work sheets with thousands of data. I need a macro to compare data in these 2 work sheets and show the result(matching or not matc...

    MadhaviLakshmi | Latest reply: ac3mark Oct 9, 2017
    1 reply
  • Counting Number For Similar Value Closed

    I have 2 Excel Sheets where i want to Use data from one Column from one sheet and compare those values in Other Sheet Colum to know how Many types the...

    Prasad | Latest reply: Prasad Oct 7, 2017
    0 replies
  • Use Macros to copy worksheet and rename using a list of names Solved/Closed

    Hi all, I'm an excel novice and hoping for help. I need to write a macro to 1. Copy worksheet "Alstromeria" and 2. Rename worksheet to the name...

    eswhi | Latest reply: eswhi Oct 7, 2017
    0 replies
  • How to generate a STATIC unique identifier for each Excel row Solved/Closed

    Hello, How can generate a unique identifier for each Excel row that WILL NOT change when I delete or add rows? System Configuration: Windows /...

    Musicar | Latest reply: ac3mark Oct 6, 2017
    4 replies
  • Two IF forumlas inside an IF formula Solved/Closed

    Hello, I am very new to using excel but somehow have managed to bluster my way around so please let me know if I am barking up the wrong tree! ...

    AdrianHowland | Latest reply: Mazzaropi Oct 6, 2017
    4 replies
  • Formula with varying information need pasted multiple times Closed

    Hello, I have what may be a simple issue. I have a spreadsheet that I need to apply a formula to in certain fields. One formula may need to be =...

    huestis | Latest reply: ac3mark Oct 5, 2017
    1 reply
  • Master Sheet to affect multiple sheets Closed

    Hello, I am not sure how to explain this... I have a master sheet that has a list of all the names and grades for each row alphabetically. I have ...

    akiroche | Latest reply: vcoolio Oct 5, 2017
    1 reply
  • how to find grade Closed

    How find grade in excel, old tell me about the formula

    kowsalyanaga... | Latest reply: xpcman Oct 5, 2017
    1 reply
  • Autopopulating multiple sheets from one main sheet Solved/Closed

    Hello, I'm making an accounting workbook for an organization I am the treasurer for, and I've run into a problem. On the first sheet "Account"...

    Mikey | Latest reply: TrowaD Oct 5, 2017
    45 replies
  • How to sum a number from a range of cells, based on value Solved/Closed

    Hello, I'm trying to update a spreadsheet that contains our wedding mailing list. The rows contain the invitee name, address and email address....

    cathcam | Latest reply: TrowaD Oct 5, 2017
    3 replies
  • Excel Closed

    Hello, i have 5 numerical values in 5 columns but in same row and these 5 values need to be compare(e.g whether the five values lies between the t...

    irshad | Latest reply: irshad Oct 5, 2017
    0 replies
  • Subtracting numbers based on data in another cell Closed

    I use a cell to show that a number has been deducted from an account. How can I make a subtraction of that amount form a total amount based on the inp...

    drspinner | Latest reply: ac3mark Oct 4, 2017
    1 reply
  • Name check Closed

    Hello, How to check the name with two cells. if any part name matched with second cell, it have to be show as TRUE. What formula for this?

    kalai | Latest reply: Mazzaropi Oct 4, 2017
    1 reply
  • Change the date format in Excel Closed

    Hello, how I can chnage the format of 12-07-2003 to 2/22/2017 in excel 2010. Give the exact route inder

    inder | Latest reply: inder Oct 3, 2017
    0 replies
  • Self-generating sequenced number each time a sheet is opened Closed

    How do you create a ( for example an invoice) self-generating sequencing number so every time an excel sheet is opened it will generate the new number...

    kevdoc | Latest reply: ac3mark Oct 3, 2017
    1 reply
  • Rank of numbers between specified range Solved/Closed

    Hello, Dear Sir, I have following data Marks Desired Rank 91.3 2 91.4 2 91.5 1 91.7 ...

    talent.anand | Latest reply: TrowaD Oct 2, 2017
    3 replies
  • Paste x Times with Multiple Conditions Closed

    Hello, I have no real knowledge of macro, but I think macro has a solution to my question I have data in Sheet1 and would like output in Shee...

    anshul1233 | Latest reply: anshul1233 Oct 1, 2017
    2 replies
  • Formatting cells based on certain criteria Solved/Closed

    I want to make a cell change colour based on a number of different criteria: Cell A1 Has an incident date B1 Displays the date 14 days after the inc...

    sailingdemon | Latest reply: sailingdemon Sep 29, 2017
    7 replies
  • New Tab Copy Paste Closed

    Hello, Being extremely new to VBA I am trying to create a macro that Creates a new worksheet and then have it copy and paste data into the new works...

    Justinjwx | Latest reply: ac3mark Sep 29, 2017
    1 reply
  • save as in a macro Closed

    Hi i am trying to save a copy of my workbook ie p&l report plus the date so i can save it each week, so far the macro i have will print all info and c...

    darrenwillia... | Latest reply: ac3mark Sep 29, 2017
    4 replies
  • How to use AutoFilter Macro in Excel Closed

    Complete Macro Newb, so I apologize for my ignorance. I know what the problem is, I am just not sure how to fix it. I am filtering one spreadsheet...

    WorldsOkayes... | Latest reply: WorldsOkayestExcelUser Sep 28, 2017
    0 replies
  • Creating Macro for Auto Updating Multiple Workbooks Closed

    Hello, I have been assigned a daunting task to create multiple reports(5) for specific clients in one workbook. This project is large as there ar...

    WorldsOkayes... | Latest reply: ac3mark Sep 27, 2017
    4 replies
  • Need help with a Macro that can copy and paste last 10 active da Closed

    Hey Guys, I am a newbie to these Macros. I need desperate help from the EXPERTs. A few things I need for my macro are: 1. I have multiple d...

    fidduma | Latest reply: ac3mark Sep 26, 2017
    1 reply
  • Attendance log help Closed

    Hello, I have an attendance workbook I am working on and need to make different worksheets according to age. I have everything entered into the fi...

    necklacemerida | Latest reply: ac3mark Sep 26, 2017
    1 reply
  • Copy paste rows from one sheet to another n times. Closed

    Hello, I need help with Macros. I have my primary data(seeking production schedule) on sheet 1. I will have 100-120 rows Of data. Column A(no of ...

    maddy1562 | Latest reply: ac3mark Sep 26, 2017
    1 reply
  • How to compare excel sheets Closed

    Hello, Hi I'm stopping by to know if any one could help me to compare between to sheets in excel with some conditions. Like it finds somethin...

    alorchi | Latest reply: alorchi Sep 26, 2017
    0 replies
  • Find matching data in two worksheets and copy entire row Closed

    I have one sheet that has about 350k rows and columns A-AW. Column Z contains phone numbers. I have a second sheet that only has phone numbers (about ...

    fairhope221 | Latest reply: vcoolio Sep 25, 2017
    1 reply
  • SUM IFS function Solved/Closed

    Hello, I need a formula to sum the values in a range of cells if the content in another range of cells equals the text currently in a cell in a co...

    dshaviv | Latest reply: dshaviv Sep 25, 2017
    2 replies
  • Excel Macro: Copy formulas across worksheets Solved/Closed

    So first off, I have no Idea how to program, but I can kind of understand simple programs. Either way, I'm trying to figure out a macro in MS Excel...

    Bobo | Latest reply: OCG Sep 24, 2017
    12 replies
  • Rajbha Closed

    I have some columns like this A. B. C. D 8 66 1 86 1 86 1 79 3 78 1 16 99 2 14 8. 10 3. 78 4 11 4 11 1 79 8 66...

    Rajbha | Latest reply: Rajbha Sep 24, 2017
    0 replies
  • How To Get B Column Value Against A Column Closed

    Hello I have 3 columns like A B C D 1 2 5 2 5 4 3 9 2 4 8 1 5 7 3 Now I Will Compare A And C Column...How To Get B Column Value...

    Rajbha | Latest reply: ac3mark Sep 22, 2017
    1 reply
  • formula search keywords in multiple columns Closed

    Hello, I need to find a excel formula (column A) to track keywords in a table with multiple columns. the key words are for example Accor F...

    simbaloo | Latest reply: ac3mark Sep 22, 2017
    1 reply
  • Help : Copy Paste to end of list without formatting Closed

    Hello everyone :) System Configuration: Macintosh / Chrome 60.0.3112.113 I'm new to Macros in Excel so I really need some help. Basically I ...

    Markmm | Latest reply: ac3mark Sep 22, 2017
    3 replies
  • Enter value in cell, have range of cells copied to another sheet Closed

    Hello, I have an materials list spread sheet that when I order a line/row, I'd like that row with the amount ordered to transfer to blank sheet 2. ...

    Ann | Latest reply: vcoolio Sep 22, 2017
    1 reply
  • Help with comparing and merging 2 spreadsheets Closed

    Hi, I have 2 spreadsheets; each contain an employee number, but 1 contains the department of the business and the other contains the employee's hom...

    Spursgirl | Latest reply: Spursgirl Sep 21, 2017
    0 replies
  • How to do a macro in Excel with random pics? Closed

    I need to do a macro with random pics. When in column "K" in scheet "SHEE4" find word "OK" then replace or paste in next cell random image from folde...

    umbur | Latest reply: ac3mark Sep 20, 2017
    1 reply
  • Arrow keys scrolling in Excel Solved/Closed

    Hello, I'm working in Excel and my arrow keys are moving the entire spreadsheet and are not moving cell by cell up, down, right or left. I do not...

    Deb | Latest reply: Upthewall Sep 20, 2017
    24 replies
  • Excel work sheet not copy to another sheet Solved/Closed

    Hello, System Configuration: Windows / Firefox 52.0 I am =DGET(Sheet1!1:156,"NAME",$A$1:E$2) but it is not work

    a g doddamani | Latest reply: a g doddamani Sep 20, 2017
    0 replies
  • Filters will not include cells beyond the first blank? Closed

    Hello, its not working for i checked into other system System Configuration: Windows / Chrome 60.0.3112.90

    Prashant pawar | Latest reply: Prashant pawar Sep 19, 2017
    0 replies
  • Help with formula please Solved/Closed

    Hi, please could someone help me with a formula to add up cells that have data in them. My spreadsheet has data in columns B-N - some of them have ...

    CB7373 | Latest reply: CB7373 Sep 19, 2017
    3 replies
  • Criteria dependent data transfer. Closed

    Good Morning, I would really appreciate some assistance with regards to a workbook I am creating in Excel 2010 to track equipment movements. I have ...

    SFRIAR616 | Latest reply: vcoolio Sep 19, 2017
    8 replies
  • Subtract last column from first column Solved/Closed

    Hello, I am having a problem i have a excel sheet there are the data for various employees timing. first of all i want to search the last colu...

    Gaurav Kumar | Latest reply: vcoolio Sep 18, 2017
    3 replies
  • merge 3 general cells to one date cell Closed

    Hello, I made a mistake formatting my HUGE tour schedule. I thought I was so smart using 3 cells for dates a1= 10 (for 2010), a2= month 1-12, and a...

    Kate | Latest reply: visitor Sep 16, 2017
    3 replies
  • Bank reference changed format help Closed

    Hello, I am trying to reconcile some standing order income at work, we have changed bank account and the reference has changed format! The process...

    PixelPixie | Latest reply: ac3mark Sep 15, 2017
    1 reply
  • Need help with data sorting & updation Closed

    Hello, I have a sheet with 6 coulmns each with (ABC & DEF) some value and different data Column A & D have same values. e.g. A B C D E F I want...

    rthunukle | Latest reply: ac3mark Sep 15, 2017
    1 reply
  • Cut and paste using vba script Closed

    Hello, I'm looking for a VBA script for the following scenario, kind request to suggest a method. Ques: I've a series of columns Range (A:HZ) (...

    Sree | Latest reply: Sree Sep 14, 2017
    0 replies
  • if then else Closed

    Hello, Please help me with a formula for Excel(?) in Open Office. I want to say....If =IF(G59=date;then_date;otherwise_0) I am trying to say i...

    Terryl | Latest reply: ac3mark Sep 13, 2017
    1 reply
  • Filters for Rows label coming as (blank) Closed

    Hello, I ran a Pivot on office2013 and some reason my filters for Rows label coming as (blank) Any idea?please? System Configuration: Windows /...

    MA | Latest reply: ac3mark Sep 13, 2017
    1 reply