Excel Forum

Ask a question
Search
Close
Results 1401 - 1450 of about 9,840
  • Excel-copy data in single sheet & populate multiple sheet by PO Closed

    I'm in need of some guidance: Excel- I have one Master sheet with numerous Purchase Order # with multiple products associated with PO#. We want to sep...

    parakaki | Latest reply: parakaki Apr 4, 2017
    0 replies
  • Move dated cells up to the top of a list Closed

    Hello, I have a spreadsheet that I am using for calibration dates. I'm using the traffic light layout for the cells. I would like to know how to...

    Chris87 | Latest reply: Chris87 Apr 4, 2017
    0 replies
  • Compare data pairs Closed

    I do not know if it can be done using excell formuals, but i have a task: i have a table of 3 columns and about 15000 rows of data. I'd like to find...

    romeo.malancu.m | Latest reply: romeo.malancu.m Apr 4, 2017
    0 replies
  • Trying to propagate the status of a project Closed

    Hello! I need help with a timeline project I am working on. I am pretty basic in excel, but can follow instructions and usually fumble my way to succe...

    Meluch17 | Latest reply: Meluch17 Apr 3, 2017
    0 replies
  • Excel codes Closed

    Hello, I would like to be able to set up a spread sheet so when I type March on sheet1 in column A it copies the entire row onto sheet 2

    Exceldummy | Latest reply: TrowaD Apr 3, 2017
    1 reply
  • vba code Closed

    Hello, sir , i am trying to copy data from one row and paste that data into column of another sheet. this process is continuous till all row no...

    ravi singh | Latest reply: TrowaD Apr 3, 2017
    1 reply
  • Cell Color Count with a condition Closed

    Hello, I need a help. I need to count cells in a range having a specific color (In one column) & cells in a range having a text (In another co...

    Manu | Latest reply: TrowaD Apr 3, 2017
    1 reply
  • Conditional Formatting based on two cell values Solved/Closed

    Hi There, I'm using Excel 2016 and am trying to apply a conditional format that searches cells in column A for the text "*DEMO*", and also has a c...

    JamesA82 | Latest reply: Mazzaropi Apr 3, 2017
    3 replies
  • Copying cond. format for entire row based on 1 cell to other row Solved/Closed

    I have conditional formatting for an entire row based on the value of 1 cell. For example: cell value>$A$2 = red, cell value

    TheBigMac | Latest reply: Mazzaropi Apr 3, 2017
    3 replies
  • Create separate worksheets/excel files Closed

    Hello, I need to create an excel file with the following I have a base file and a summary sheet I need to create separate sheets and rename them...

    abhihabi | Latest reply: Brooke_Harper Apr 3, 2017
    1 reply
  • Print selected data from a sheet based on the date period select Closed

    Dear All, I have worksheet that gets updated on a daily basis and want to be able to set it up to automatically print based on the date period sel...

    christossol | Latest reply: christossol Apr 2, 2017
    0 replies
  • Excel data validation Closed

    I manage a ongoing membership list in Excel. I've noticed typing errors in the the date field for the entered date. Is there a way I can alert the...

    fateague | Latest reply: fateague Apr 1, 2017
    0 replies
  • Macro to compare two excel file Closed

    Hi Team, I need excel macro to compare two excel file and highlight the difference in the respective cell with both the values in file 1 and 2 .

    sridhar4159 | Latest reply: ac3mark Mar 31, 2017
    1 reply
  • Drop down lists Solved/Closed

    Hi All, i have a drop down list in excel and the data for the list in a sheet in the same workbook. If I copy the spreadsheet with the list to anot...

    christossol | Latest reply: Mazzaropi Mar 31, 2017
    3 replies
  • Excel Combine worksheets into one Closed

    Newbie here, I have a question on how to do this in excel. I have lots of worksheets, 200+, each with different names, and I was wondering if its p...

    Bobby12345 | Latest reply: ac3mark Mar 30, 2017
    1 reply
  • Removing False Value Solved/Closed

    Hello, I would like to know how to remove the "False" Value when if function is nested. Here is an Example =IF(G23=0,P15/Sum(D11:F11,IF(G23>0...

    danmanuele | Latest reply: ac3mark Mar 30, 2017
    5 replies
  • Copy rows to other sheets based on value in column Solved/Closed

    All, I have an Excel file with three sheets: Sheet1 contains all my data. Sheet2 named "MACH" and Sheet3 named "FAB" I am looking for a way with a...

    LeedMe | Latest reply: vcoolio Mar 30, 2017
    6 replies
  • Automatically save data to another excel sheet. Closed

    Hello, System Configuration: Windows / Chrome 57.0.2987.110 Please give me suggesstion & Advice to my query, Whenever I enter date in Ex...

    satyender | Latest reply: vcoolio Mar 30, 2017
    1 reply
  • Macro for copying and pasting (related to answered question) Closed

    Hello, You recently provided this answer to a question (see below). I'd like to do almost exactly what you recommend, except my spreadsheet has si...

    kk | Latest reply: kk Mar 29, 2017
    0 replies
  • VBA date Closed

    Hello, please can anyone help me? With the below code i'm trying to format the cell color when an date in a cell reaches the system date or a set ...

    lynng | Latest reply: lynng Mar 29, 2017
    0 replies
  • how to calculate values using COUNTIF Closed

    I have 2 sheets sheet1 is a Summary sheet and sheet2 is data sheet sheet 2 has columns from A TO R, in that column G is Severity (heading) wit...

    narsing18 | Latest reply: ibrahim Mar 28, 2017
    1 reply
  • Trying to create a multi-column formula. Solved/Closed

    Hello, I need help making a formula. I will do my best to describe. The letters (A-I) refer to separate columns. A-B=C to be divided by D the res...

    oduana777 | Latest reply: TrowaD Mar 28, 2017
    9 replies
  • formula for multi answers Closed

    Hello, I'm not yet a member, first time user, however interested to be registered as soon. Hi looking for the right formula for the following....

    mandyl | Latest reply: mandyl Mar 28, 2017
    0 replies
  • Paste Values copied in alternate rows in a single column Closed

    Hello, I need to paste some data from 1 column to another column but in alternate rows. for Example:- Data to be copied is as below. Cell Valu...

    Vikasgohel | Latest reply: Vikasgohel Mar 28, 2017
    0 replies
  • Autopopulate from master sheet? Closed

    Hello, I've been making, essentially, copies of my and my husbands pay stubs. Currently I'm just copy pasting an "empty pay stub form" and manuall...

    Liakami | Latest reply: Liakami Mar 28, 2017
    0 replies
  • copy and insert rows Closed

    Hi, Everyone! I just need help I need a formula or a macro code that everytime I will manually type something on column a,b,c it will be also ge...

    Serenitylai | Latest reply: Serenitylai Mar 28, 2017
    0 replies
  • Changing current font color based on other cell's value? Closed

    Hello! I would like to change the default font color when entering text in Column B based on the text in a different cell. BUT, I would like to ret...

    Brittonica | Latest reply: Brittonica Mar 27, 2017
    0 replies
  • Removing FALSE from return Closed

    Hello, I have this formula that returns FALSE, can someone tell me how to remove this? Thanks, Ed =IF(Tama!E8,+(Tama!C8))

    Ed | Latest reply: Ed Mar 27, 2017
    0 replies
  • Date with condition Closed

    Hello, What could be the answer and how If function play Three or more condition applying in date formula? Problem A=Employment Type, B=Join...

    Sharif Jaman | Latest reply: Sharif Jaman Mar 27, 2017
    0 replies
  • Update sheet - may be by using a macro Closed

    Hello, I am trying to make a kind of template file which will be used by different users, most of them even more simple excel users than me :-) The ...

    Obonden | Latest reply: Obonden Mar 26, 2017
    0 replies
  • VBA/Copy Paste Closed

    Hello, I have a dataset with 300 rows and 10 columns. the first 4 columns have the metadata and then 6 columns with different values. what I want t...

    Ezzath | Latest reply: Ezzath Mar 26, 2017
    0 replies
  • Sum product and countif Closed

    Hi, I'm trying to calculate the number of each type item on the column B that has the condition X on the column A and wich numbers on the column C ...

    nunnoduarte | Latest reply: nunnoduarte Mar 25, 2017
    0 replies
  • Move cells based on their values Closed

    Hi, I did this a few years ago once but I can't remember how I got it to work. I have 2 sheets named BOQ and V.O. The BOQ sheet has a list of items ...

    Neiljnb | Latest reply: Neiljnb Mar 25, 2017
    0 replies
  • Update sheet by macro Closed

    Once a month I want to import data from an external workbook to my excel sheet (let's call it "Master") and change some of the content in Master, both...

    Obonden | Latest reply: Obonden Mar 25, 2017
    0 replies
  • Paste two columns under each other for multiple columns Closed

    Hello, I am new to VBA coding and trying to get things sorted for an excel document (work purpose). Unfortunately I am stuck in a [articular step un...

    su | Latest reply: su Mar 24, 2017
    0 replies
  • Paste 2 columns under each other for multiple columns with the s Closed

    Hello, I am looking for a code to paste series of 2 columns under each other. Ex: Sheet1 1 Col 1 Col 2 Col 3 Col 4 2 ABC DEF GHI JKL 3 MON PQR...

    su | Latest reply: su Mar 24, 2017
    0 replies
  • Help with Excel Closed

    Hello, I have two excel files. one is a staging inventory and the second one is the a delivery file. The inventory files has all assets number, seri...

    Thinker782 | Latest reply: Thinker782 Mar 24, 2017
    0 replies
  • VBA Paste based on Date Criteria Closed

    Hello, I would be very grateful for some assistance with this spreadsheet I am attempting to create. I've Googled what I am trying to do several tim...

    tomwilliams | Latest reply: tomwilliams Mar 24, 2017
    0 replies
  • Possible to copy/paste row based on dates? Closed

    Greetings, I would like to automatically copy rows from one worksheet into another based on dates contained in each sheet. The rows containing the da...

    Shawn0 | Latest reply: Shawn0 Mar 24, 2017
    0 replies
  • Paint cell based on another cell value with Macro Closed

    Hello, I want to paint one cell, based on value of another cell using Macro. And i want Macro to do that for entire column. Example: COLUMN A ...

    Donald | Latest reply: Donald Mar 24, 2017
    0 replies
  • VBA Paste below row with Dates Criteria Closed

    Hopefully someone can help me. I've Googled this several times and couldn't quite get the answer I'm looking for. I have data that I load and sort e...

    tomwilliams | Latest reply: tomwilliams Mar 23, 2017
    0 replies
  • Two excel sheets copy new data input on one sheet to new row on Closed

    Hello, I have an excel spreadsheet that I have to update periodically overwriting old data. I have another sheet where I need to update the same inf...

    WintersJ73 | Latest reply: maheshmahi Mar 22, 2017
    1 reply
  • i am mahi solve it Closed

    Hello, =IF(ISERROR(SEARCH("*keyword*",A1,1)),"","keyword") it is only for one cell it perfectly ok for multiple cell its not ok this formula how...

    mahi mahi | Latest reply: mahi mahi Mar 22, 2017
    0 replies
  • Need To extract data from a column to another worksheet. Closed

    Hello, I need code to extract all data containing a name from a column on sheet1 and copy it to Sheet2 and remove all blanks. The name is pulled fo...

    smv1 | Latest reply: vcoolio Mar 22, 2017
    3 replies
  • Excel problem Solved/Closed

    Hello, I want a formula in which, If I enter the number in cell, the name of that number should appear in adjacent cell. Ex: Emp No Name 1 ...

    John | Latest reply: Mazzaropi Mar 22, 2017
    3 replies
  • Populate a work schedule based on a matrix on a separate sheet Closed

    I am trying to populate a work schedule on one sheet of a workbook based on a date matrix on a separate sheet of the workbook. I have a list of nam...

    GuamDave | Latest reply: GuamDave Mar 22, 2017
    0 replies
  • How to solve Date Format dd/mm/yyyy Closed

    Hello, How to solve Date Format dd/mm/yyyy

    Mohini | Latest reply: Mohini Mar 22, 2017
    0 replies
  • Help with Index Match or VLOOKUP Closed

    Hello, I have a worksheet with about 2000 rows. In column C and Column J i have a common Key. In Column K I have data that i want to write to Colu...

    mwilke | Latest reply: Mazzaropi Mar 21, 2017
    1 reply
  • EXCEL: If number in 2 sheets match, transfer row to third sheet Closed

    Hello! I have a question. I'm going to try to be as clear as possible. I have sheet 1 that contains all customers who are NOT on paperless billing. ...

    whitneyiei | Latest reply: whitneyiei Mar 21, 2017
    0 replies
  • Need help with storing data Closed

    Hello Guys I am new to ccm.net and excel. My question is, how can i save one excel data to another .. Let me explain in detail... I want to make a ...

    muhammed361 | Latest reply: muhammed361 Mar 21, 2017
    0 replies