Excel Forum

Ask a question
Search
Close
Results 4701 - 4750 of about 9,840
  • Search and transfer data between workbooks Closed

    Looking at reviews, I know this request will have a simple answer. I am new to Excel, and I need help on this spreadsheet. I have workbook open. On...

    SPREADSHEETGAL | Latest reply: TrowaD Jul 29, 2014
    1 reply
  • Moving data from one spreadsheet to another on Excel Closed

    I really need to be able to set up a macro & formula so that once I pick an option from a drop down list on my work book, that will automatically plac...

    heather93 | Latest reply: TrowaD Jul 29, 2014
    3 replies
  • Need help comparing dates... Solved/Closed

    I have dates in one column, I want to enter a $0 value in another column if that date is >= 5 years in the past. Obviously, I'm a relative newbie with...

    l_gavacho | Latest reply: Mazzaropi Jul 28, 2014
    3 replies
  • automatic copy on excel Closed

    hi sir/mam, i want to automatic copy a data from sheet to another. all those qty on out column in big warehouse sheet must be copy to small warehou...

    belonio | Latest reply: venkat1926 Jul 26, 2014
    5 replies
  • Excel 2003 Date format Closed

    Hello, Excel 2003 Date format yymmdd I use Excel 2003 (because I like it) and use the International date format yymmdd (it is the shortest versio...

    kirkie007 | Latest reply: kirkie007 Jul 25, 2014
    0 replies
  • Step by Step help creating a link Closed

    Good afternoon all, I would like to create a link in a cell that will create a new worksheet in the same workbook. I am new to VBA and Macros so I ...

    ellamm50 | Latest reply: TrowaD Jul 24, 2014
    1 reply
  • If function with dates in one cell and numbers in other one Closed

    Is it possible to use if function for following: I have dates in on cell and numbers in other one. Dates are for the whole month and numbers are betwe...

    excelamateurr | Latest reply: excelamateurr Jul 24, 2014
    0 replies
  • How do I make relative worksheet references?-excel 2010 Closed

    How can I reference the current sheet in a formula for a chart data range?

    Collin10592 | Latest reply: Collin10592 Jul 23, 2014
    0 replies
  • Reference the current sheet in a formula for chart data ranges? Closed

    How can I reference the current sheet in a formula for a chart data range? I am making a large number of graphs; each one references data on the sa...

    Collin10592 | Latest reply: Collin10592 Jul 23, 2014
    0 replies
  • Less than/greater than Closed

    I need a formula that will allow me to show if any cells in a range have a greater value than 100,if so show "YES". If not, have cell remain blank. I...

    Gus1 | Latest reply: Mazzaropi Jul 22, 2014
    1 reply
  • Create a worksheet when information is typed in a cell. Closed

    Hello, I am trying to have a new worksheet created (from a template) when I type information in a cell. For example, if I type Ellen McKay in ...

    ellamm50 | Latest reply: ellamm50 Jul 22, 2014
    0 replies
  • Auto Generate a new worksheet from list in another worksheet Closed

    How can I automatically create and name worksheets in a workbook based on a list that exists in another sheet "Summary" in the workbook? The list begi...

    ellamm50 | Latest reply: ellamm50 Jul 22, 2014
    0 replies
  • Automate Excel to shift data so the values in two rows match? Solved/Closed

    Hello! Please help me with this quandary for my internship. I would greatly appreciate it :) Here is my problem: I want to match ID numbers in two co...

    excellenthelp | Latest reply: excellenthelp Jul 22, 2014
    5 replies
  • Excel Auto-Data Transfer Closed

    Hello, 1. How do you transfer a whole row of data into a new tab if an X is put in the first blank column of data 2. How do you move a whole row...

    shweiny23 | Latest reply: TrowaD Jul 22, 2014
    1 reply
  • Copy X Row N Number of Times Solved/Closed

    Hi. I need the formula to Copy X Row N No.of Times. For Example Col 1 Col 2 ABC 3 DEF 5 GHI 4 O...

    lionsclaw | Latest reply: smiller1712 Jul 21, 2014
    2 replies
  • copying data in excel -only figures but not formulas Closed

    I would like to copy data from one worksheet to the other but do not want the formulas and calculations to pass from one worksheet to the other - just...

    pinhole | Latest reply: Mazzaropi Jul 21, 2014
    1 reply
  • Need help for Combination macro Closed

    Hi someone, Please help me out the following problem. I have 10 nos. of machine as A, B, C, D, E, F, G, H, I, J and K. Combined to 2, 3, 4, 5, 6,7 ...

    jasidul | Latest reply: venkat1926 Jul 21, 2014
    1 reply
  • Need to total a column with text in it? Closed

    Hi I am looking to total a column that has specific text in it. e.g My column has the words Leave, Public Holiday or Sick in it so at the botto...

    ClaireDoherty | Latest reply: Mazzaropi Jul 20, 2014
    1 reply
  • DATABASE FORMAT Closed

    I kindly needed help on developing a workplace using database format for entering my medical equipment such as specification, model, serial numbering ...

    rabtun01 | Latest reply: rabtun01 Jul 18, 2014
    2 replies
  • Conditional formatting based on information in two sep. Cells. Closed

    Hey guys. This is for Google sheets, but since its mostly the same, the answer should work. Heres my problem. I have a Data point in B3/B999. In D...

    Danziboy | Latest reply: Danziboy Jul 18, 2014
    0 replies
  • Vba Code worksheet with a list of 67 competencies and 3 criteria Closed

    Hello, I have a worksheet with a list of 67 competencies and 3 criteria for each competency. A button is created on the same sheet such that upon c...

    Ram08 | Latest reply: ac3mark Jul 18, 2014
    1 reply
  • Who to identify least one in excel Closed

    Hi, I have 10 Cells can be filled with between the text "L1" to "L20". In that we want find what is the least LXX text is . Someone can we help me ...

    kathapr | Latest reply: TrowaD Jul 17, 2014
    2 replies
  • Macro Help Needed - Copy data row(s) from column into new file Closed

    Hello and thank you in advance. I was trying to follow along with the answer given here, but I'm not well versed in macros. https://ccm.net/faq/213...

    Burt_Macklin | Latest reply: Burt_Macklin Jul 17, 2014
    5 replies
  • Change Date Format - dd/mm/yyyy HH:MM:SS to mm/dd/yyyy HH:MM:SS Closed

    Hello all I have some 1000 cell of date format. which has " 13/05/14 16:53:59 " Excel not recognize as date.. How can I change.. Tried Format...

    asmfiaz | Latest reply: Mazzaropi Jul 17, 2014
    2 replies
  • Running a Macro Automatically Closed

    Hi Guys, I'm using the below code in VBA to hide and unhide colums in Excel. Sub Hide() If Range("A1") = "Summary" Then Columns("B:Z").Hidde...

    Vikram | Latest reply: ac3mark Jul 16, 2014
    1 reply
  • add blank rows based on the value in a cell. Closed

    Hello, How to add blank rows based on the value in a cell. Say if value in cell is 9, then 9 number of blank rows to be entered automatically....

    Kritika Dixit | Latest reply: mdazgt Jul 15, 2014
    3 replies
  • Change the text colour based on the value in the cell Closed

    Hello, I want to change the text colour if the value is between -10 to 5 to green and the value between 5 to 40 amber and value between 40 a...

    aravind | Latest reply: TrowaD Jul 15, 2014
    2 replies
  • Automatic data transfer Closed

    Hello, I have two tabs in a work book, Materials and Hire. In materials I have column A - PO Number Column B - Job Number and Column C - Date I am...

    sam | Latest reply: TrowaD Jul 15, 2014
    1 reply
  • Autofill cell with color based on deadline Closed

    Hello, I would like to ask for help on a task I need to do dealing with dates and deadlines. I have "C" with the due date of the task and would li...

    ROME | Latest reply: venkat1926 Jul 15, 2014
    3 replies
  • Need to pull data from particular cells and add to another sheet Closed

    I've got about as far as I can with my limited knowledge of Excel so am searching for guidance, any and all appreciated. I have a sheet which measu...

    jaridyard | Latest reply: TrowaD Jul 14, 2014
    1 reply
  • Split of row data into different subsequent rows Closed

    Dear Sir, I have query relating to split of data of one row into other subsequent rows upto certain number of characters till the width allowed to...

    caimshah | Latest reply: MyHelpster Jul 14, 2014
    1 reply
  • Excel returns FALSE sometimes.... why Solved/Closed

    I'm using this formula to show the persons age based on date of birth. In some cases it works but in others it returns FALSE. If I change the date of ...

    plato2 | Latest reply: plato Jul 11, 2014
    2 replies
  • Date Formate Issue Closed

    Dear Friends i have one column of Date in A1 cell issue is diffrent date formate in Column A1 and i want convert in one formate shap Expample is ...

    akram786 | Latest reply: MyHelpster Jul 11, 2014
    2 replies
  • Transfering data Closed

    I have a charts with 2000 lines a colums of first names, a colums of last names, 3 address colums. I have a similar chart on a second sheet. Which...

    Katzman | Latest reply: ac3mark Jul 9, 2014
    3 replies
  • Help with VBA Code to Copy and Paste Data Needed Closed

    I want to create a worksheet and copy and paste rows with a specific value in Column A to a worksheet named for the value. The new sheet should have s...

    swolford | Latest reply: MyHelpster Jul 9, 2014
    1 reply
  • excell automatic filters Closed

    Dears kindly i need fourmala to do the following i have a sheet have column A & B& C A have 3 different value (type1 ,Tybe2 & Tybe 3 ) and each on...

    aymandaoud | Latest reply: venkat1926 Jul 9, 2014
    3 replies
  • Excel 2003 IF Function using Dates & Text Solved/Closed

    Hello, I'm trying to write a function for a cell which refers to a date in another cell - which if it is between 01/01/1994 and 31/12/1995 the cell w...

    Jen | Latest reply: depu Jul 9, 2014
    7 replies
  • ms office entreprise 2007 browse folder probl Closed

    when am installing ms office entreprise 2007 it shows browse for folder ....i cant do anything plz tell me friends I already formated my system and do...

    ravitejad23 | Latest reply: manideep Jul 9, 2014
    2 replies
  • IF Function return FALSE Closed

    Hello anyone, I need help on my formula. I use an IF formula but if the cell shown zero it returns false. the formula is like this =if(L7=0,0,...

    drbram2379 | Latest reply: Osama_bb11 Jul 9, 2014
    1 reply
  • Conditional Formatting: column A based on text values in columnB Closed

    Hi, I am trying to figure out a way to use conditional formatting to highlight the cells in column A based on the specific text in column B. I ...

    ceeubank | Latest reply: BunoCS Jul 8, 2014
    1 reply
  • Help comparig data in two different excel spreadsheets Closed

    Hi. Im a little overwhelmed. i have one spreadsheet that i keep that has my 125 contracts and task orders on it. example: row 1 contract number ro...

    eric_2902 | Latest reply: TrowaD Jul 7, 2014
    1 reply
  • multiple processors for Excel Closed

    I work with very large spreadsheets in Excel on a Mac and I often have to wait for Excel to execute things like sort and fill. I'm hoping too solve...

    greepaul | Latest reply: greepaul Jul 6, 2014
    2 replies
  • auto generate invoice number Save and Clear Closed

    I'm new to this site. I'm using excel 2013, I want a macro to auto generate invoice number, at the same time when I save it should copy and clear th...

    jinah | Latest reply: xpcman Jul 5, 2014
    1 reply
  • If... Then Closed

    Greetings all, I hope I can explain this correctly as this is my first time asking questions on a public forum. All me to set the stage. A = ...

    chrisdantonelli | Latest reply: Osama_bb11 Jul 5, 2014
    2 replies
  • Format fill colour based on another cell Solved/Closed

    Hi I would like to format my excel page so that the rows alternate between two fill colors based on whether two cells are equal or not. Here is an ex...

    EndlessDread | Latest reply: EndlessDread Jul 2, 2014
    2 replies
  • calculating text to result certain text result Closed

    hi, if I enter S into cells a1 & b1 & c1 I need cell D1 to result 'CO'. if either cells a1,b1 or c1 has NYS entered into either cell or all 3 cells I ...

    simonchef | Latest reply: Mazzaropi Jul 2, 2014
    3 replies
  • Search values in one workbook and paste into another workbook Closed

    I have to paste monthly figures from one Excel workbook to another workbook I want to write a code that search for the departments name within the...

    NatsJou | Latest reply: NatsJou Jul 2, 2014
    0 replies
  • Transfer cell data from one workbook to another workbook Solved/Closed

    I am using two workbooks to track account spending for quarterly reporting. Workbook 1: Day Expenses Workbook 2: Monthly Expenses WB1: I have fo...

    txljh | Latest reply: Osama_bb11 Jul 2, 2014
    4 replies
  • Question about my if statement Closed

    Hello, I have an excel file with portions of addresses and i want to take the city state and zip code and put it in a separate cell. For that i u...

    Derrall | Latest reply: Mazzaropi Jul 1, 2014
    1 reply
  • Date format change in excel Solved/Closed

    Hi, I have an excel worksheet with a date column in the format m/d/yyyy h:mm:ss AM/PM. How can I change it to the format d/m/yyyy h:mm? I tried the '...

    booor | Latest reply: booor Jul 1, 2014
    2 replies