Excel Forum

Ask a question
Search
Close
Results 751 - 800 of about 9,840
  • VLOOKUP, IF? Question assigning value to text options Solved/Closed

    Hello, I need to make an spreadsheet that corresponds different text values and gives them a score. I have several tables set up, that I was tryin...

    Soupies | Latest reply: Soupies Jan 17, 2018
    2 replies
  • Data showing who pays a doesnt after manually input receipts Solved/Closed

    Hello, Hope im clear on this. Im a bit lost. I have sheet one. This is a spredsheet where we input a secuential number with the name of the ...

    ramaemachado | Latest reply: Mazzaropi Jan 17, 2018
    5 replies
  • Sorting a massive amount of data Closed

    Hello, My boss has asked me to find out how much each sales person has sold in their first 8 weeks, 16 weeks, 24 weeks,40 weeks, 1 year, 2 years a...

    bubsyboo | Latest reply: bubsyboo Jan 16, 2018
    0 replies
  • Finding a cell and adding 1 to a cell in an adjacent column Closed

    I am working on a simple stat program to replace a tally sheet we use in basketball practice. I have created a page to choose names and statistics to...

    aarnold@wane... | Latest reply: ac3mark Jan 15, 2018
    1 reply
  • Difficulty to open Excel files Closed

    Good day! The problem is the following! When opening any Excel files (no matter what size and no matter of the mesh open or locally with a computer) t...

    gamma86 | Latest reply: ac3mark Jan 15, 2018
    2 replies
  • Compare sheets and put missing rows into third sheet. Closed

    Hi to all the CCM members. I have a problem that I need assistance with and I would greatly appreciate it if a VB guru could help me with a script ...

    Biffzs | Latest reply: vcoolio Jan 15, 2018
    1 reply
  • Copying rows into new sheet Closed

    Hello beautiful people of CCM, This is my first time posting and I am so excited to be part of such a wonderful community of intelligent minds. I t...

    mattlake23 | Latest reply: mattlake23 Jan 12, 2018
    0 replies
  • Compare Excel worksheets Closed

    Hello, I need to compare one Excel Sheet1 with Sheet2 by comparing the data and putting all missing rows data not in Sheet2 into Sheet3. Sheet1 co...

    Biffzs | Latest reply: Biffzs Jan 12, 2018
    0 replies
  • Linking by contents not by cell number in Excel Closed

    Hello, I currently have two workbooks open on excel. One is a shipping list of spare parts that I have sent out and the other is the one I use to ke...

    moondogs92 | Latest reply: moondogs92 Jan 12, 2018
    0 replies
  • Excel data transfer Closed

    Hello, I have a spreadsheet that we have weekly billing sheets on. We have a sheet on it to track our PO numbers as well. There are also a variety...

    Bridget2589 | Latest reply: Bridget2589 Jan 12, 2018
    0 replies
  • Update one sheet excel sheet from the other Closed

    Hello, I was wondering if anyone could help , I have a large excel sheet (AW - 2506) which holds info for each employee, we are currently moving s...

    katietempletoe | Latest reply: kftempletoe Jan 12, 2018
    3 replies
  • Allow Inserting Hyperlink after Protecting a Sheet with VBA Closed

    Hi I have a spreadsheet which a user must complete, but he must select how many times the form must get created. My coding allows that, but I'm prot...

    JohanVorster | Latest reply: JohanVorster Jan 12, 2018
    0 replies
  • Copying rows into a new sheet Closed

    Hello I am trying to do the following If the quantity listed in column C on sheet "Area 1" has a value of 1 or greater then pull rows A through...

    mattlake23 | Latest reply: mattlake23 Jan 12, 2018
    0 replies
  • Create new worksheets using date data Closed

    Hello, I've been asked to find a way to sort data comprised of visit dates in to worksheets (within the same workbook) by age. The dates range fro...

    Erich | Latest reply: ac3mark Jan 11, 2018
    4 replies
  • Automated filter, copy, paste... Recommendations appreciated! Closed

    Hello, I am a self-taught rookie attempting to create a document that will distill necessary information on a contract and spec sheet without havi...

    tjgibbs | Latest reply: ac3mark Jan 11, 2018
    3 replies
  • Compare 2 cells then use data in 3rd cell Closed

    hi there hope you can help me with this please i need to do the following for a stock vs sales management sheet if a1 = b1 then d1*c1 Lo...

    Danielaes | Latest reply: ac3mark Jan 10, 2018
    3 replies
  • Update from one sheet the other Closed

    Hello, I have a large excel sheet (AW - 2506) which holds info for each employee, we are currently moving systems and I am storing and updating al...

    katietempletoe | Latest reply: katietempletoe Jan 10, 2018
    0 replies
  • Logging web data excel Closed

    I’m trying to log some data imported from the web. I’ve already managed to import the data as a table and set an auto refresh to every minute. What I...

    Excelneebie | Latest reply: ac3mark Jan 9, 2018
    3 replies
  • IF statement returning false Closed

    Hello, The following IF statement is returning false. Please let me know how to get it to return a value. Thank you =IF(D6

    danithompson99 | Latest reply: ac3mark Jan 9, 2018
    1 reply
  • Macro to copy data to new workbooks based on condition Closed

    Hello, I have a workbook with data that looks something like this (except thousands of entries): Name Type Group Master John ...

    hosinsul | Latest reply: ac3mark Jan 9, 2018
    1 reply
  • Filter the data in Excel through formula Solved/Closed

    Hello, I need a formula of the following quotation: Column A Belongs To Customer Name Column B Belongs The Date Column C Belongs To Item ...

    Game Start Now | Latest reply: Ash Jan 9, 2018
    27 replies
  • transfer certain information from one sheet to another Closed

    I have multiple employees. I have my payroll broke down into months. I need to have a sheet for each employee. Can i use a formula so I only have t...

    candice | Latest reply: candice Jan 8, 2018
    0 replies
  • Unable to format any date prior to 1900 as dd/mm/yyyy Closed

    This is my second request for help. I am unable to format any date prior to 1900 as ddmmmyyyy. No matter how many times I try to custom format it, t...

    jrpawl | Latest reply: jrpawl Jan 6, 2018
    0 replies
  • Highlight Cell Question Closed

    Hello, I am trying to find a way to use conditional formatting on an inventory spreadsheet that I am working on. I would like to highlight cell C3 ...

    DParson55 | Latest reply: Mazzaropi Jan 5, 2018
    6 replies
  • Help with Formula calculating time on 24H shifts Closed

    Hello CCM community!, Here I am again with a question that's being bugging me for a while A while ago I created my own version of a work scheduler...

    leoojeda | Latest reply: ac3mark Jan 4, 2018
    5 replies
  • Insert rows on change of value in Excel table Solved/Closed

    Hello, I have an excell spreadsheet that contains a table. I want a macro of vb to insert a row into the table when the values in a particular colum...

    theHawk | Latest reply: Counselor Jan 4, 2018
    13 replies
  • date and time format change Closed

    Hello, hi I want to change 15:07:2017 19:51:54 date format in 15/July/2017 19:51:54 System Configuration: Windows / Chrome 62.0.3202.94

    Islam | Latest reply: Islam Jan 2, 2018
    0 replies
  • Copy all csv file data in one master sheet through VBA Closed

    Hello, I am in new in VBA ; Almost around 3000 csv file in folder, I want all CSV file data copy in one master sheet using VBA along with file ...

    YAMRAJ2018 | Latest reply: YAMRAJ2018 Dec 30, 2017
    0 replies
  • Excel date formula doesn't work past the new year Closed

    Hello, I have a problem with a date formula in a spreadsheet that I would very much appreciate help with. It seems that the formula doesn't work p...

    PaiviM | Latest reply: PaiviM Dec 30, 2017
    5 replies
  • IF formula with dates and rates - complex! Closed

    Hello, i'm trying to get a very complex IF formula with many dates and outcomes. if an employee's starting date is 18 Oct 2017 (cell A5), then ...

    samasteph | Latest reply: Mazzaropi Dec 28, 2017
    1 reply
  • IF function for multiple cells and options Closed

    Hi, I'm trying to use the IF function but even when I copy a formula, I can't seem to get the correct answer. I thought it might be because the cell w...

    BacktotheFuture | Latest reply: Mazzaropi Dec 25, 2017
    3 replies
  • Formula for calculating work hours on overnight shifts Closed

    Hello CCM community!, Here I am again with a question that's being bugging me for a while A while ago I created my own version of a work scheduler ...

    leoojeda | Latest reply: leoojeda Dec 22, 2017
    0 replies
  • Consolidate different workbooks into a new one Closed

    Hi guys, I have 3 excel workbooks (A, B, C) with multiple worksheets. Each one of the workbook have 2 worksheets (1, 2) with the same columns and sam...

    anacastelhano | Latest reply: ac3mark Dec 21, 2017
    1 reply
  • How to send an email automatically when values are met. Closed

    Hello, Let me start with that I'm a rookie when it comes to VBA programming. I'm attempting to set up a code that will send an email automatically...

    Appositive | Latest reply: ac3mark Dec 21, 2017
    1 reply
  • How to retreive datas form one sheet to another sheet in excel Closed

    Hello, If having the datain one sheet per example A column and Values column data are entered ., in next sheet if i enter the A it has to show th...

    vinutha vagata | Latest reply: ac3mark Dec 21, 2017
    1 reply
  • VBA to populate multiple sheets from master Closed

    Hello, I have a spreadsheet that I use to track my customers bookings. I have multiple customers and multiple bookings. I would like to have my mas...

    jessalyn2293 | Latest reply: ac3mark Dec 21, 2017
    1 reply
  • IF Function Using a Date Range Closed

    I'm looking for a function that will assign a specific date or day of the month when another cell containing a date falls within a date range: If C...

    Morranda | Latest reply: ac3mark Dec 21, 2017
    1 reply
  • Help with formula: IF, variable, add time into a different cell Closed

    Hello, I found this website after bumping my head with the keyboard trying to find a solution to a question I have. I am trying to create a spreadshe...

    leoojeda | Latest reply: Mazzaropi Dec 21, 2017
    3 replies
  • Formula IF contains certain text, then will add time to another Closed

    Hello, A1 is original time, B1 will be a type of equipment, C1 will be 40, 45 or 55 minutes, depending on types on B1, D1 will add C1 and A1 and thr...

    leoojeda | Latest reply: leoojeda Dec 21, 2017
    0 replies
  • How to convert numbers into words in Excel? Closed

    Hi, How to link or create formula in converting figures to amount in words? Thanks

    GIEBAYACA | Latest reply: xpcman Dec 20, 2017
    1 reply
  • Data Comparison in excel Closed

    Hello, I have two data like in one sheet Names are started with First name and in other Sheet data is started with the Last name.So how can i compar...

    Shivani | Latest reply: ac3mark Dec 19, 2017
    1 reply
  • VBA template Closed

    Hello, Hi, I'm new to excel,i want a template which will take the data from one workbook & paste it to other workbook,but it has to be done da...

    akshay1722 | Latest reply: ac3mark Dec 19, 2017
    1 reply
  • Macro which will determine a new scanned file Closed

    Hello, I am trying to organize my records and here is what it comes down to, I have 4 separate folders, in which I am planning to copy scanned fil...

    paulamerica | Latest reply: ac3mark Dec 19, 2017
    7 replies
  • Formula/ Conditional Formatting Help please Closed

    Hello, I am trying to create a tracker spread sheet. I need to enter the date a course was completed, the date it is due (2 years later) and I need...

    Amygreen85 | Latest reply: Mazzaropi Dec 19, 2017
    3 replies
  • Excel VBA Template Closed

    Hi, I'm new to excel,i want a template which will take the data from one workbook & paste it to other workbook,but it has to be done daily lik...

    akshay1722 | Latest reply: akshay1722 Dec 19, 2017
    0 replies
  • Copy and paste data from different sheet. Closed

    Hello, I have a small problem. I have made dependent lists in excel to capture the data. However, to sum up the data, I need to pick up the entire...

    weshall.rain | Latest reply: weshall.rain Dec 19, 2017
    0 replies
  • Use a macro to copy data from rows into destination range Closed

    Hello, I want to create a macro to copy data from one range (eg. A2 to C2) and paste it to another destination in the same file. then select next...

    Subradeep | Latest reply: vcoolio Dec 19, 2017
    1 reply
  • Excel formula to subtract a value based on a date condition Closed

    I need a formula for my budget in excel. I have the date automatically updating and I would like to use the due date for an automatic payment to ch...

    cmwjames | Latest reply: cmwjames Dec 18, 2017
    0 replies
  • Copy two sheets data in new work book with two sheets. Closed

    Dear Concern, Please resolve the query I requested below... I have a work book like.... Sheet 1: It has student detials (Enrollment No, Name, ...

    Krishna Tej | Latest reply: ac3mark Dec 18, 2017
    8 replies
  • Macro coding Closed

    Dear concern Macro for copying a particular sheet from a workbook and pasting only values in new work book and saving that new workbook with speci...

    Srinivasan | Latest reply: Srinivasan Dec 17, 2017
    0 replies