Excel Forum

Ask a question
Results 4601 - 4650 of about 9,840
  • Automatically transfering rows from one sheet to another Solved/Closed

    Hi, I was wondering if anyone could help. I've created a spreadsheet to track all contracts complied within our department. I have a "Contract Sta...

    madi9749 | Latest reply: madi9749 Sep 26, 2014
    4 replies
  • IF function with Date addition Solved/Closed

    Hello, I'm having trouble finding an answer as to how I can add 5 more days in my condition. I have 4 columns: one for an Order date (A2)...

    garycrant | Latest reply: garycrant Sep 25, 2014
    4 replies
  • Dealing with 'Today()' formula in Excel VBA code Solved/Closed

    Hi Everyone, I have this VBA code in a Excel sheet (specifically in the Module) which does the following: - finds the empty cell in range "B:B" -...

    masinyaka | Latest reply: masinyaka Sep 25, 2014
    4 replies
  • Macro needed to delete rows with certain condition. Closed

    Hi, I have about 169,000 lines of items to go through and I'm trying to figure out a macro to delete every row that contains the word "Discontinue...

    tsunamibomb | Latest reply: venkat1926 Sep 25, 2014
    1 reply
  • Excel > Macro for Defined Range Dates Solved/Closed

    Hello, I've a question that I have starting date in Column "E3" Sheet 1 and ending date in Column "F3" Sheet 1. I want a macro that insert dates i...

    Game Start Now | Latest reply: Game Start Now Sep 23, 2014
    13 replies
  • Macro or VB code Help on Moving data from one sheet to another Closed

    Hello, Would request you to please help on the following query I have. I have an Input sheet which has data entered in Column A to F like name, emp ...

    DSDaisy | Latest reply: TrowaD Sep 23, 2014
    1 reply
  • Find second empty cell/row and start pasting from it Closed

    I've already did a lot of research and couldn't find a solution. I'm trying to find the second empty cell/row (or other especified cell) in a column a...

    scafy | Latest reply: TrowaD Sep 23, 2014
    1 reply
  • Excel place a vaue in a cell if a number is in a certain range Closed

    I need to setup ranges and place a number associated with-in that range. 150 300 450 600 750 900 This data is from column M. I need to b...

    rangebob | Latest reply: TrowaD Sep 23, 2014
    1 reply
  • Formula compare two different cells containing the scores of tes Closed

    Hello, I am trying to create a formula that will compare two different cells containing the scores of two tests. A student can only get PASS remark ...

    ayili | Latest reply: TrowaD Sep 23, 2014
    1 reply
  • Macro or VB Code Closed

    Hi, Input sheet will have data entered in Column A to F like name, emp id, date etc and I need this data to move in specific cells of a pre formatted...

    DSDaisy | Latest reply: DSDaisy Sep 23, 2014
    0 replies
  • static dates Closed

    Hello, I'm new to the abilities of excel and would appreciate any help. I'm trying to create a worksheet where when any data is entered in column A ...

    jaddiso | Latest reply: venkat1926 Sep 23, 2014
    1 reply
  • Referencing like numbers with different extensions Closed

    I'm not sure how to ask this, but I have multiple workbooks sent to me (new job-set up by someone else) with one of the sheets that I am to use in eac...

    denalraab | Latest reply: denalraab Sep 22, 2014
    0 replies
  • How to copy data based on criteria met Solved/Closed

    Help! I am totally stuck and this is probably a very simple fix. I have two sheets "Priority Accounts" and "ACN Dashboard". I need to move data i...

    katcrisjul | Latest reply: TrowaD Sep 22, 2014
    12 replies
  • Transferring data from one workbook to another Closed

    I want to copy data from one work book to another. I have got a data which will be entered by the user on their excel sheet in the specified format...

    innocentspy | Latest reply: innocentspy Sep 22, 2014
    0 replies
  • Sum total numbers of the same date Closed

    I have a column with various birthdates 1953, 1983, etc. In the column there may be 10 1953's and 30 1983's. how do I get excel to sum up all the ce...

    brian | Latest reply: brian Sep 18, 2014
    0 replies
  • Excel formula Closed

    how to convert no in words. pls give me formula ex. 132507 Ans - one lac thirty two thousand five hundred & seven

    annasaheb | Latest reply: annasaheb Sep 18, 2014
    0 replies
  • SUM invoice number and invoice amount Closed

    I am looking to sum up multiple rows containing currency, while disregarding the text. I want to take the "amount" and subtract the multiple ...

    ShannonKAllard | Latest reply: ShannonKAllard Sep 17, 2014
    0 replies
  • stuck Closed

    Hello, I'm new to excel's advanced abilities. Is there a way to transfer the total of column E in sheet 1 to cell C3 in sheet 2? Configuratio...

    jaddiso | Latest reply: jaddiso Sep 17, 2014
    0 replies
  • Excel 2010 VBA Date Formula Solved/Closed

    Hi, I am trying to get a formula setup so when you click on a cell in excel it automatically enters the date. I am using the formula below which wo...

    Oz_Dex | Latest reply: dave Sep 17, 2014
    3 replies
  • Create a Sales by Week Combined Report Closed

    Hi I want to create a report where I but in sales a use a Macro to insert a date and then insert all of the data in the worksheet into a seperate w...

    Mr S | Latest reply: Mr S Sep 17, 2014
    0 replies
  • Copy values in row to columns in spaces Solved/Closed

    Hello, I am a beginner in VBA, and would mcuh appreciate some guidance on transposing data in a row to a column via VBA. My row data is as foll...

    LearnVBA | Latest reply: LearnVBA Sep 16, 2014
    4 replies
  • Excel report Closed

    Hello, I create a seller report Worksheet 1--- I named it as Price list ... is a Data for my seller report that I set a code, name, points and ...

    Winndixie | Latest reply: Winndixie Sep 13, 2014
    0 replies
  • Copying data from one data sheet to another automatically excel Closed

    Dear Excel Gurus, What I want excel to do is, if a name put in a certain category on sheet one, then it automatically get copied into another sheet w...

    arropes | Latest reply: venkat1926 Sep 13, 2014
    3 replies
  • Adding comment to a Pivot Table using VBA Closed

    I have a requirement to put comment in a paticular pivot table column . The user can insert column or delete column ,the comment should dynamically p...

    ajita | Latest reply: ajita Sep 12, 2014
    0 replies
  • Formula to perform range of sums based on range of words Closed

    HI I am trying to find a formula that will basically: Check B2 to see if it contains the word "Fortnight" or "Month" or "Annual" and then "equal th...

    jesstopher | Latest reply: jesstopher Sep 12, 2014
    0 replies
  • Compare multiple spreadsheets + conditional pivot formatting Closed

    I have a list of 200 locations that are looking to renew their internet contract. I am asking 30 different vendors to provide their best available pri...

    NW | Latest reply: NW Sep 11, 2014
    0 replies
  • Tranferring Data from one spreadt to another Closed

    How do I transfer info, including the result of a formula and keep them updated from one spread sheet to another

    Johnny4567 | Latest reply: Johnny4567 Sep 11, 2014
    0 replies
  • Conditional Formatting Solved/Closed

    Suppose I have date in Column A (from A1 to A100) and in Column B (from B1 to B100), Both data are numerical. If the data in Column A is greater than...

    tareqnaser95 | Latest reply: Osama_bb11 Sep 10, 2014
    2 replies
  • Movind data from one cell to another via a Macro Closed

    Hello all-- I am in need of someone's valued assistance. Here's the story: I have an excel spreadsheet that contains address data in Cell B6 & B...

    mpstockdale | Latest reply: venkat1926 Sep 10, 2014
    3 replies
  • REMOVING " FALSE " VALUE IN "IF&quo Closed

    Hello, I would like to know how to remove the "False" Value when if function is nested. Here is an Example =IF(C13="",IF((K13>="06:00"+0)*(K13="...

    dieselkhan | Latest reply: RayH Sep 9, 2014
    1 reply
  • Excel 2010 code that clears content of a cell on open Closed

    Hi I am looking for code that clears content of a cell based on a value when the workbook opens. I have several sheets in the workbook with varied...

    jamhome | Latest reply: TrowaD Sep 9, 2014
    1 reply
  • Conditional formating of row based on other cells Closed

    Hello, I am trying to format cells A7-E7 based on the relationship between C6 and C5. Ideally they would be coloured on a scale between green and y...

    Bitbull | Latest reply: TrowaD Sep 9, 2014
    1 reply
  • Specific data from one worbook to another (Excel 2010). Solved/Closed

    Hello there, I have two workbooks, one is an accounting spread sheet (named Cash Book) and the other has an Invoice Template (sheet 1) and Invoice...

    vcoolio | Latest reply: vcoolio Sep 9, 2014
    29 replies
  • If then formula using a date Closed

    Hi, I'm trying to create a formula where if the date falls on or after 08/01/2012 the value returned is .0464 and if its before 08/01/2012 the value r...

    chashare | Latest reply: Mazzaropi Sep 8, 2014
    1 reply
  • excel 2007 custom filter problem Solved/Closed

    Hello, I have been using Excel 2003 to sort phone numbers easily, using the custom filter and 'begins with' for example on numbers starting with 123. ...

    h4 | Latest reply: mark Sep 8, 2014
    6 replies
  • Macro to Insert Multiple Images to Multiple Sheet of a Excel Closed

    Hello Everyone, Greetings to All. I have some Issues in the below Macro. My intention is to Copy/Insert the multiple Images in a folder that I se...

    Nimalan_Dude | Latest reply: Nimalan_Dude Sep 8, 2014
    0 replies
  • Multiple columns using countifs Closed

    I have a column such as a1 --- 'Vendor' ----> (Win/Loss) column N ...

    jclegg42002 | Latest reply: venkat1926 Sep 7, 2014
    1 reply
  • VBA/Formulas for Repeating Values by Cell Value, w/Offset Closed

    Hello, I have a pretty complex little thing going on, but I'm having trouble getting through the next part. Using VBA, two lists are generated ...

    crochenemg | Latest reply: crochenemg Sep 5, 2014
    0 replies
  • Making date appear on master copy Closed

    Could anyone help with a formula for the date to appear on my Master copy of Items sold and purchased. i.e .A. .B. ...

    Bigmick | Latest reply: Bigmick Sep 5, 2014
    0 replies
  • Comparing Excel Columns - Help ASAP Please! Closed

    Hello, I need help, please! I have two worksheets (C & Q). Each worksheet contains four columns, each column has different information(A=Date, B=Mis...

    Lori | Latest reply: Gary Myers Sep 4, 2014
    2 replies
  • run VBA automatically when criteria is met Closed

    I want to be able to run a macro automatically when criteria is met.. If any cell in column A is change to "re-let" run "rowformat" macro can an...

    Debs269 | Latest reply: venkat1926 Sep 4, 2014
    1 reply
  • time calculation Solved/Closed

    Hello, dear all please I need a help for formula to calculate the duration ( hours ) between two dates for example : A1 ---> 1-8-2014 1...

    Osama_bb11 | Latest reply: Osama_bb11 Sep 3, 2014
    2 replies
  • Macro that copies certain cells Closed

    Hello All , I need a Macro that copies certain cells , from other workbooks in a folder . it should open the first workbook, copy 3 cells , past...

    SAG123 | Latest reply: SAG123 Sep 3, 2014
    0 replies
  • Automatic update of date from one sheet to another Closed

    Hi I need to make a form that will update any written information from one spreadsheet to another automatically. E.g. I have one work-folder wi...

    loegborg | Latest reply: loegborg Sep 3, 2014
    0 replies
  • How to compare 2 sheets in Excel Closed

    Hi, Could you please let me know how to compare data in 2 work sheets. I have the data in sheet1 and sheet2. I need to test whether the data in t...

    raj4team | Latest reply: raj4team Sep 3, 2014
    0 replies
  • Conversion of multiple column into single column Closed

    Hello, I have a date set in the following format 1 3 5 7 2 4 6 8 I want this in the format 1 2 3 4 5 6 7 8 Please help m...

    TiwariUjjwal | Latest reply: aamirsq Sep 2, 2014
    1 reply
  • 4 conditional formats Closed

    I am attempting to add 4 conditional formats; First in red the 'cancel' - already done Secondly all things that complete on today's date in blue - d...

    Morganatic | Latest reply: aamirsq Sep 2, 2014
    1 reply
  • copy data skipping blank cell Closed

    Hi, 1. How can i copy my my excel sheet1 (range B2:BJ800) data into sheet 2 skipping blanks cells. All want all data should be on sheet 2, colum...

    aamirsq | Latest reply: aamirsq Sep 2, 2014
    0 replies
  • Copying cells Closed

    My question is similar to those above. We have rental properties. When a guest reserves I enter the data in one sheet (let's call it Sheet 2) that I...

    jaubin | Latest reply: jaubin Sep 1, 2014
    0 replies
  • Duplicating Macro Closed

    Hi I currently have the below macro to duplicate rows for me but I want it to show the data in 2 columns instead of nderneath each other. EG OV...

    Ceri88 | Latest reply: TrowaD Sep 1, 2014
    7 replies