Excel Forum

Ask a question
Search
Close
Results 1501 - 1550 of about 9,840
  • Data auto change on multiple status in one column Solved/Closed

    Hello again, Few days ago i am looking for a command that can use to change data status in one same column. Example : 'Activated' change to 'Expired...

    -Hta- | Latest reply: Mazzaropi Mar 3, 2017
    10 replies
  • Master sheet auto-populating anniversary dates into new sheets? Closed

    Hello, I have a master sheet that has our employee information and start dates where I have broken up their start dates into different columns for t...

    ImmaUnicorn | Latest reply: vcoolio Mar 3, 2017
    1 reply
  • identify the frequency of times Closed

    Looking for a way to identify the frequency of times a name in column A exceeds the value of its outcome in column c when compared to its expected out...

    Lnj4ever | Latest reply: Lnj4ever Mar 3, 2017
    0 replies
  • separate version type and names Closed

    Hello, I have data on browsers used by users where in I need to separate version type and names. I am struck up in the middle. Formula used by me is...

    saif178 | Latest reply: saif178 Mar 3, 2017
    0 replies
  • Multi Sheet formula Closed

    I am trying to figure out how to automatically find and remove duplicates across several sheets. The purpose of this is to have a master list of my in...

    Wayne | Latest reply: Wayne Mar 2, 2017
    0 replies
  • Date adjustments by 6 months Closed

    Hello, I am in search of some expertise advice. Im trying to figure out if there is a formula to add 6 months from a date to another cell. What I ...

    Trinads | Latest reply: Trinads Mar 2, 2017
    0 replies
  • adding 6 months to dates Closed

    Hello, Im trying to figure out if there is a formula to add 6 months from a date to another cell. What I have is training that occurs twice a year ...

    Trinads | Latest reply: Trinads Mar 2, 2017
    0 replies
  • VBA button to move a range of data Closed

    Hi. So, here's what I would like to do: Excel Workbook (Cert_Master) local 1. I enter various information about a job into Worksheet (DATA); it po...

    Minatrea | Latest reply: Minatrea Mar 1, 2017
    0 replies
  • Change bunch if cell colours when cell pressed Closed

    Hello, I would like to be able to click on a yes cell, no cell and a selected amount of cells in a column change to either green/red. Effectively ac...

    KeepinTidy | Latest reply: KeepinTidy Mar 1, 2017
    0 replies
  • i want to create spred sheet Closed

    How do I open excel?

    kdeeter | Latest reply: Mazzaropi Mar 1, 2017
    1 reply
  • Preventing a cell from being populated if different cell is popu Closed

    Hi there, I have created a spreadsheet for units for a Diploma that assessors can use to select various units from a number of possible options. I h...

    TessF | Latest reply: TessF Mar 1, 2017
    0 replies
  • copying dates in Excel Closed

    Hello, when I copy a date from one cell to another(not to the cell directly below), it appears as a number(eg 48123) rather than the date I copied(e...

    ahector2017 | Latest reply: ahector2017 Mar 1, 2017
    0 replies
  • Repeat row x times Closed

    Hello, I want to make some labels for products. i have a sheet with info in columns A-F(name, sku, size, description, date, and quantity. Column F...

    Richard | Latest reply: vcoolio Mar 1, 2017
    10 replies
  • How to get entire row based on unique value of multiple column Closed

    I have to get entire row with unique values based on multiple columns as shown below, in that only one row(3 with same value as 2) is repeated and in ...

    Gowria17 | Latest reply: Gowria17 Mar 1, 2017
    0 replies
  • Just general VBA to copy a sheet from one workbook to another... Closed

    and paste it into that workbook. Any help you could give me for this would be so greatly appreciated. Thanks. System Configuration: Windows / Inte...

    dak7983 | Latest reply: dak7983 Feb 28, 2017
    0 replies
  • IF series formula Closed

    I have an excel sheet with Column A thru I and rows 1 thru 23. I am trying to have my cell H2 return a word if cell D2 has a number 15 thru 21 in it....

    cotimorris | Latest reply: cotimorris Feb 28, 2017
    0 replies
  • How to SUM responses from cells with list data validation Closed

    Hello, I want know if it is possible to total (SUM) the number of responses I have on cells which have the data validation. I have set up a sprea...

    Tara961 | Latest reply: TrowaD Feb 28, 2017
    1 reply
  • Question on VBA code Solved/Closed

    Hello, can someone explain this code to me? I have this file that has a macro button transferring all the information(KPI's to be exact) from a data...

    Griever666 | Latest reply: Griever666 Feb 28, 2017
    2 replies
  • Excel - Repeat Last row into N number of times Closed

    Hello, Can anyone help me to repeat last row into N number of times into same sheet. Sample Data Where N=5 Column-A Column-B abc 111 AAA...

    Abu.hamna | Latest reply: TrowaD Feb 28, 2017
    1 reply
  • Please help excel 2016 Closed

    Hello, I have an excel workbook for our call center metrics and i need to accomplish the following On the sheet named calculations and a sheet nam...

    Txsky84 | Latest reply: TrowaD Feb 28, 2017
    1 reply
  • Unable to display pic in mac platform Closed

    Hello, Please help me to solve this for my project ...need help as soon as possible Already Macro enable,picture display issue message is "The Link...

    Hazlina94 | Latest reply: TrowaD Feb 28, 2017
    1 reply
  • Formula help - if cell contains a number, +1. Solved/Closed

    Hi there, Just a simple one for you guys! I'm currently making a spreadsheet to tally up sickness days and occurrences. I currently enter how many s...

    Crozzers | Latest reply: Mazzaropi Feb 28, 2017
    3 replies
  • Covert date of Birth Solved/Closed

    Dear Sir I want to convert date of birth in excel like below mentioned Example : 11/07/1982 then it should be reflect as Eleventh July Nineteenth...

    sushim1399 | Latest reply: sushim1399 Feb 27, 2017
    2 replies
  • Need help with Macro to generate Monthly Overview Solved/Closed

    Hi all! I have been trying to build a Macro that allows me to generate a new worksheet with the information from a Master Sheet where i will key in t...

    ZhengPeng | Latest reply: ZhengPeng Feb 27, 2017
    12 replies
  • Help on excel Closed

    Hello, I have a table of date time and value for a month, would like to find the value searching the date and time ex Date tim...

    eddyb | Latest reply: eddyb Feb 27, 2017
    0 replies
  • Conditional Formatting Solved/Closed

    I am trying to format column 'O' if the value is greater than zero but where column 'P' does not include "SBNAS735" or "SBTDP443". Help! System Conf...

    cmenzies | Latest reply: Mazzaropi Feb 27, 2017
    3 replies
  • Update cells in a particular column from one sheet to another Closed

    How do I update cells in a particular column from sheet to sheet. I have a payroll worksheet and occasionally our employees borrow money, I need to co...

    lrodeheaver | Latest reply: TrowaD Feb 27, 2017
    1 reply
  • CountIf statement driven by spesific date and text criteria Closed

    Hello, Employee Work Code Report I need to summarize every occurrence in column C within each of the same dates in column D (1/1-1/31) and based ...

    bobcoozey | Latest reply: TrowaD Feb 27, 2017
    1 reply
  • Formula to completed fields Closed

    Hello, I need a formula to look up values that if it shows all false it's a green light and if it contains at least 1 true value, it's red light. I...

    padvang | Latest reply: TrowaD Feb 27, 2017
    1 reply
  • Timesheet adding rows Closed

    Hello, I'm trying to work out a formula so that I can hand off my timesheet to a new manager and have it work correctly. Right not I sum a row of to...

    nicoleevelyn | Latest reply: TrowaD Feb 27, 2017
    1 reply
  • Unable to display pic Closed

    Already Macro enable,picture display issue message is "The Linked image cannot be displayed. The file may have been moved, renamed or deleted. Verif...

    Hazlina94 | Latest reply: Hazlina94 Feb 26, 2017
    1 reply
  • Copy data from 1 excel list to another excel list Closed

    How to copy info from 1 excel spreadsheet to another excel spreadsheet. For example, need to copy identification numbers from master list to monthly ...

    Ruth Smith | Latest reply: Ruth Smith Feb 26, 2017
    0 replies
  • Conditional formatting in googlesheets Closed

    Hello, I'm using Google Sheets, not sure how big of a difference will be. I'm trying to use conditional formatting between two columns, and I'm not...

    Shanzeh Sohail | Latest reply: Shanzeh Sohail Feb 25, 2017
    0 replies
  • Need some programming in excel Closed

    Hello Sir, I am A basic user & new to excel & coding. I will explain what I am looking for , than you can let me know weather it's possible or not. ...

    Iffiz | Latest reply: Iffiz Feb 24, 2017
    0 replies
  • copy and paste from workbook to another workbook Closed

    Hi, I have a master workbook that has various tables on several worksheets. The information carries forward to the master page. I copy lines from thi...

    Debncatz | Latest reply: Debncatz Feb 24, 2017
    0 replies
  • Need urgent help with spltng the data copied in another workbook Closed

    Sub Copy_Script() 'Finds the last non-blank cell in a single row or column Dim myFile As String, cellValue As Variant, i As Integer, j As Integer, a...

    vignesh | Latest reply: vignesh Feb 24, 2017
    0 replies
  • Transfer data from one sheet to another Solved/Closed

    Hello, I require some assistance please. I looked at a few answers on this forum, but I am stuck as my VB keeps on giving errors. I wish to automa...

    Anita80Olivier | Latest reply: vcoolio Feb 24, 2017
    3 replies
  • Look up a word within a sentence and copy into a next column Closed

    Hello, I have an excel file with over 10 000 entries, each entry contains a city within the sentence - I also have a database (another sheet) with a...

    Erika | Latest reply: Erika@83 Feb 23, 2017
    4 replies
  • How to transfer data to another work book in excel Closed

    Hello, I would like to automatically transfer the data to another work book but I do not want to transfer the rows that have blank data. could you ...

    Surya | Latest reply: Surya Feb 22, 2017
    0 replies
  • Date formats Solved/Closed

    Hello, Can you tell me how to change the format from Sep-01-2015 to the format 2015-09-01? I have tried the format tab under the Date section and Cu...

    jbeasley | Latest reply: ac3mark Feb 22, 2017
    3 replies
  • Adding number of days in filtered excel sheet Solved/Closed

    how to add number of days to columns in a filtered excel sheet

    rashiken | Latest reply: rashiken Feb 22, 2017
    0 replies
  • complicated auto populate possible or not and if so how. Solved/Closed

    Hello, I'm using excel to schedule for my business, I have all the customer information on the first sheet and would like to auto populate the other s...

    jmp2009 | Latest reply: vcoolio Feb 22, 2017
    9 replies
  • Compare columns in two sheets and copy info across Closed

    Hello, I have two sheets open. Sheet 1 has two columns of data (PO number, Value) Sheet 2 has two columns of data (PO number and supplier) What ...

    pashnak | Latest reply: Mazzaropi Feb 22, 2017
    1 reply
  • excel formual help Closed

    Hello, I need a formula, hope someone can help! If i add a date in to cell A2, i want the number 1 to appear in cell A1

    ssey | Latest reply: ssey Feb 22, 2017
    0 replies
  • Making Labels Closed

    Hello, I want to make some labels for products. i have a sheet with info in columns A-F. Column F contains quantities. I need to make a sheet that ...

    Rich | Latest reply: Rich Feb 21, 2017
    0 replies
  • Transfering information from one worksheet to another Closed

    Hello, I am trying to transfer information from one worksheet to another, but only if the name shows up on the second worksheet. For example, I h...

    faithhof74 | Latest reply: faithhof74 Feb 21, 2017
    0 replies
  • Formula for assigning numerical value to text Closed

    Hello, I have a very large excel sheet with names. Some of the rows of names duplicate, sometimes more than once. In each row next to the name is a...

    daisy | Latest reply: TrowaD Feb 21, 2017
    1 reply
  • code to check if a work centre on sheet 1 appears on sheet 2 Closed

    Hi, Please help me write a code that will check if a work centre on sheet 1 appears on sheet 2. If it appears in sheet 2 the work centres in sheet 1 ...

    MsVictorry | Latest reply: TrowaD Feb 21, 2017
    1 reply
  • My arrow key move only four cells Closed

    Hello, My arrow key move only nearest few cells even in new worksheet My computer HP probook Please help System Configuration: Windows / Chrome...

    Sunil Rajapakse | Latest reply: Sunil Rajapakse Feb 21, 2017
    0 replies
  • iso 27005 Risk Value Solved/Closed

    Hi All, I have the following problem: I have two cells that have a text value which can either X or M or H X value is 0, M value is 1 and H value i...

    christossol | Latest reply: Mazzaropi Feb 21, 2017
    5 replies