Excel Forum

Ask a question
Search
Close
Results 1951 - 2000 of about 9,840
  • Calculation of positions in excel Solved/Closed

    Hello Hello, sir/madam...i am doing some work with the students result in excel...but I faced a problem..it is simple but I havn't got dat in my mind...

    Mohsin | Latest reply: Dausayi Oct 12, 2016
    12 replies
  • Data Validation refers to Sheet Name Closed

    Hello, I would like to request for solving my problem My workbook contains many sheets, some ends with the "-E" (Hyphen Symbol and Alphabet E) S...

    smuneeb | Latest reply: smuneeb Oct 12, 2016
    0 replies
  • insert filename.csv into the *.csv file Closed

    Hi Trowa I'm having 3000 files in *.csv format. I want to insert filename.csv into the *.csv file of 'A' column. Is it possible? I'm unable to fin...

    ajay | Latest reply: ajay Oct 12, 2016
    0 replies
  • Excel Macro's copy data from one sheet to another Solved/Closed

    Hey Everyone ok, so, I have a document with multiple sheets one of the sheets is a reporting sheet what i am trying to accomplish with not much l...

    Carolusclen | Latest reply: vcoolio Oct 12, 2016
    13 replies
  • Seeking Help with a Formula Closed

    Hello, First, thanks for taking the time to read this. I'm not great at this and not sure this will even work. Ok, here goes; In a certain cell I i...

    Bayer111 | Latest reply: Bayer111 Oct 11, 2016
    0 replies
  • Need Help with Formula Closed

    Hello, I'm not great at this and not sure this will even work. Ok, here goes; In a certain cell I input manually a productivity number daily. On c...

    Bayer111 | Latest reply: Bayer111 Oct 11, 2016
    0 replies
  • Copying an adjacent cell text from another sheet, if cell exist Closed

    Hello, I have 2 excel sheets with lists (+5000 rows) of unique parameter names (text) on each row starting from A2. Sheet 1 has only the param...

    Jeff68 | Latest reply: Jeff68 Oct 11, 2016
    0 replies
  • formula for copying figures onto another sheet when value is >0 Closed

    Hello, I would like to create a formula that will only show figures from another sheet that are greater than 0. This is for an invoice template. T...

    kellpie | Latest reply: kellpie Oct 11, 2016
    0 replies
  • Excel Macro Closed

    Hello, I am trying to create a macro that will insert 2 blank rows into an existing spreadsheet after each category. I want the second blank row t...

    mangula | Latest reply: mangula Oct 10, 2016
    0 replies
  • COMPLICATED EXCEL FORMULA Closed

    Hello Friends, Can any one help me to sove my problem. I have two excel sheets . i want to comapre column A and B with other sheet and if both cell...

    ggirish008 | Latest reply: x Oct 10, 2016
    1 reply
  • Macro Copy & Paste same Cells Down Closed

    Hi all, First off, I'm new to macros so just a warning. I am currently working on a simulation, and trying to create a macro that will record th...

    Mason | Latest reply: Mason Oct 10, 2016
    0 replies
  • Copy from one sheet to another based on value Closed

    Hello, I am a newby to excel macros but here goes. I have a sheet where raw data is being entered in rows called DATA (How original) :-) I have...

    jacquesvv1 | Latest reply: jacquesvv1 Oct 10, 2016
    0 replies
  • Compare two Excel Sheets which have Duplicate Values (Advanced) Closed

    Hello, I'm trying to compare two excel sheets which have duplicate values in the matching column. In both sheets the number of row count is dif...

    sameeracma | Latest reply: sameeracma Oct 10, 2016
    0 replies
  • Fetching of data from number of other sheets to a master sheet Closed

    Hello, respected consultant, I have created a Excel Sheet for student class attendance. in it i have made a provision for over all attendance of ...

    Abhi | Latest reply: Abhi Oct 10, 2016
    0 replies
  • Cut-Paste from 1 Workbook to another-based on cell - del columns Closed

    I have a master workbook and a template workbook. Master workbook has 6 col - Vendor / Rep / ST / Code / Amount / Name. Template has 5 col - Vendor ...

    vette4sale | Latest reply: vette4sale Oct 9, 2016
    0 replies
  • Moving Entire row from one sheet to another Closed

    Hey, I have a list of job orders listed in excel. One job takes one row. One of the columns reads heading as "Job status", the value under job status...

    sidmdhar | Latest reply: sidmdhar Oct 9, 2016
    0 replies
  • Urgent Copy Vertical data from One sheet to another horizontally Closed

    Hello, I am trying to copy cell data from one sheet to another, the data in source sheet is vertical and i have to copy horizontally in destination...

    k | Latest reply: aquarelle Oct 9, 2016
    1 reply
  • Pictures pasting over each other....Help Closed

    Credits to TrowaD in this Forum I was able to use his VBA Code for what I wanted but it just need a touch more to make it complete....The code below p...

    ssincerely | Latest reply: ssincerely Oct 9, 2016
    0 replies
  • Get a value from Col A based on the max value found in Col B Solved/Closed

    Hello, Get a value from Column A based on the max value found in Column B display in Column C. I need to get value Jill in Column C. Name A...

    Mani | Latest reply: Mani Oct 9, 2016
    2 replies
  • From iPhone to excel Closed

    I need a button in excel where I could import I photo I am taking into an assigned cell. I will need to do this multiple times in a spreadsheet. Is t...

    Ozzy | Latest reply: Ozzy Oct 8, 2016
    0 replies
  • Check Options in Excel Closed

    Hello, I would like to request that Questionnaire is design in which (ranges from A5 to E1000) Column B Contain Excellent Column C Contain Good...

    smuneeb | Latest reply: smuneeb Oct 8, 2016
    0 replies
  • Format cell's currency Closed

    Hello, I am working with a drop down list that includes 7 or 8 account numbers to choose from through data validation. Various bills are paid from...

    NewB | Latest reply: NewB Oct 7, 2016
    0 replies
  • Comparing dates in multiple columns and using one that matches Solved/Closed

    Hello, I have a table with multiple columns of date values and need to check whether a date in a certain column is less than that date and depende...

    Stovvy | Latest reply: Stovvy Oct 7, 2016
    2 replies
  • how to convert date into words(marathi) Closed

    Hello, i want to know how to convert date into words(english) in excel 2003 or 2007 for eg. 22.04.2010 - convert it into Twenty Two April 2010 o...

    Ramnath | Latest reply: Ramnath Oct 7, 2016
    0 replies
  • Macro to insert a number into cell A11 for 180+ excel files? Solved/Closed

    I used the macro below to merge a bunch of files but it cut off the last row of data. It looks for the first A cell with nothing in it to end it and t...

    Jax | Latest reply: Jax Oct 6, 2016
    0 replies
  • Auto populate into a different tab based on cell value Closed

    Hello, My job involves tracking several POs for several different vendors. I am looking to compile several sheets of data into one workbook with d...

    Nate | Latest reply: vcoolio Oct 6, 2016
    1 reply
  • Column Matching and Data Pulling Closed

    Hello, I am looking for first, for two columns to match, let's call them A and C, if they match, I want Column D to have the same vaule as Column ...

    Ann | Latest reply: Ann Oct 6, 2016
    0 replies
  • Create & name worksheets from a list and copy data Solved/Closed

    Hi Guys Really new to this and thanks to previous posts on here I have managed to create code to complete the first part of my jigsaw, just struggl...

    RachJol | Latest reply: TrowaD Oct 6, 2016
    6 replies
  • Copying data with respect to a condition Closed

    Hello all, I suppose the problem I have is not a complex one. Here is a brief intro to my work sheet A B C D ...

    harbanga2015 | Latest reply: harbanga2015 Oct 6, 2016
    0 replies
  • copying specific range of datas Closed

    Hello, I suppose the problem I have is not a complex one. Here is a brief intro to my work sheet A B C D E F ...

    harbanga2015 | Latest reply: harbanga2015 Oct 6, 2016
    0 replies
  • How to write a macro to lookup rows Closed

    Hi, i have 2 worksheets with hundreds of thousands of rows of cost centers. I would need to do a lookup of Cost Centers in worksheet 1 with workshe...

    Anna | Latest reply: Anna Oct 5, 2016
    0 replies
  • how to change to infilll colour of one cell according to another Closed

    Hello, I am hoping some one can help me, I have started looking to set up a database regarding dates for training, it is dynamic changing the date a...

    James | Latest reply: James Oct 4, 2016
    0 replies
  • Macro - Create new sheet and generate information from Summary Closed

    Hi all, Just wondering if someone can assist, I need to create a spreadsheet that has a running list of service calls (Summary) then once a line is...

    FancyM | Latest reply: FancyM Oct 4, 2016
    0 replies
  • VBA Macros Help Closed

    Hello, I have a need to create a macro that is beyond my knowledge. I recently started trying to learn how to write simple macros in order to simp...

    EReyes66 | Latest reply: ac3mark Oct 4, 2016
    1 reply
  • Multi Copying Excel 2013 Closed

    Evening All I looking to copy the same lines of excel * so many times depending on number in a column. So anything input in A2,B2,C2,D2 is cop...

    VinnieBizzle | Latest reply: VinnieBizzle Oct 4, 2016
    0 replies
  • Help needed to compare excel worksheets. Closed

    Hello, I have an Excel worksheet that contains a list of part numbers that I stock. I also have other worksheets that contain lists of parts that ...

    PHK1 | Latest reply: PHK1 Oct 4, 2016
    0 replies
  • Middle name extraction Closed

    Hi, I need to extract middle name from full name. for some case its working but in those names without middle name, it throws #VALUE! error. also ...

    Tulika | Latest reply: TrowaD Oct 4, 2016
    1 reply
  • Formatting whilst using letters and numbers Closed

    I would like to conditionally format a spreadsheet based on grade progression, where the grade contains both a letter and number. The grades are n...

    Blakey3790 | Latest reply: TrowaD Oct 4, 2016
    1 reply
  • Conditional format make a row a color based on another cell Closed

    Hi, I have a large spreadsheet with many rows and columns. I want to color a row green when we have been paid on that line. There is a column ...

    Ellestee | Latest reply: TrowaD Oct 4, 2016
    1 reply
  • How to insert columns until a cell condition is met Closed

    Hi everyone. I'm not very good in macro and hope that anyone could give me some pointers. I have a worksheet (ie. Project A) whereby it contains he...

    bubblebluez | Latest reply: TrowaD Oct 4, 2016
    1 reply
  • Paste data from specified cells to another when just typing comp Closed

    Hello, Hello, I am trying to use macros to copy data from several cells into different cells in another sheet. My data is consisting of Organizati...

    Maher | Latest reply: ac3mark Oct 3, 2016
    1 reply
  • Macro to get random samples based on condition Closed

    How to create a macro which picks random 200 rows from a excel file which has huge data. Each column containing both empty and valued data.

    spraud | Latest reply: TrowaD Oct 3, 2016
    1 reply
  • If cell contains a word from a word bank, then return value Closed

    Hello, I need to be able to read a cell and see if it has any of the following word: John Jane Jake Jill Jack ect. Then return True on an...

    JL | Latest reply: Mazzaropi Oct 3, 2016
    1 reply
  • Find the net elapsed time of a task Closed

    Hello, I need to calculate the effective time taken by a task. I have the start date&time and end date&time of the task. Both the times are mai...

    Rajan | Latest reply: Rajan Oct 3, 2016
    0 replies
  • Macro-not refering correctly Closed

    Hello, Iam very new to macro, i have written a code, that should work in sheet 6, but it always by defualt goes to sheet 1.Please find code below: ...

    ppp | Latest reply: ppp Oct 3, 2016
    0 replies
  • finding percentages Closed

    Hello, I'm not sure if i'm asking my question in the right place or not. I need to find percentage of attendance for a period of time. I have...

    myles | Latest reply: Mazzaropi Oct 2, 2016
    1 reply
  • Cell referrence Closed

    Hello, How can we referrence a particular cell value in date formate in another cell which has a multiple number? Thanks

    Kevin | Latest reply: Mazzaropi Sep 30, 2016
    1 reply
  • Lookup 2 cell headers one one sheet to find answer on another Closed

    Hello, I am trying to lookup the employee name and week # included on sheet A on sheet B in order to find the % of utilization during that week. ...

    Jen | Latest reply: Mazzaropi Sep 30, 2016
    1 reply
  • Need only date from text Closed

    Hello, how to get only date when a cell contains text. EX: MON 12/20/1968 12:30 . I want only the date 12/20/1968

    Anu | Latest reply: Mazzaropi Sep 30, 2016
    1 reply
  • Populating many sheets from one Closed

    Issue: I'm working on a Google Excel doc which is being populated by entries on a Google form. Each row on the sheet relates to one form entry. ...

    Elaine | Latest reply: Elaine Sep 29, 2016
    0 replies