Office Software Forum

Ask a question
Search
Close
Results 2401 - 2450 of about 16,600
  • 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 | Excel | 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 | Excel | 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 | Excel | Latest reply: Abhi Oct 10, 2016
    0 replies
  • Combine two PDFs in shuffle (riffle) Closed

    Hello, I would like to know if there is anyway to combine two PDF documents but in a card shuffle mode? For example I have one PDF with three page...

    Kimblor | PDF | Latest reply: Kimblor Oct 9, 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | Latest reply: vcoolio Oct 6, 2016
    1 reply
  • How to insert symbols of the French language Solved/Closed

    How to insert symbols of the French language and keep them in a folder to use easily.Thks a lot. Please advise.

  • 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | Latest reply: Mazzaropi Sep 30, 2016
    1 reply
  • recover gmail account Closed

    Hello, What if I forget my ID.. . Configuration: iPhone / Safari 4.0

    amit | Word | Latest reply: ac3mark Sep 29, 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 | Excel | Latest reply: Elaine Sep 29, 2016
    0 replies
  • Get value from cell to other sheet based on condtion Closed

    Hello, i have sheet with lot of data . i want to get some value of my sheet to other sheet in excel . for ex: Cell A | Cell B ==============AB ...

    jas | Excel | Latest reply: ac3mark Sep 28, 2016
    1 reply
  • How to download PDF to Word converter full version freely Closed

    Sir, PDF to word converter is very smooth, I want to downloads its full version..... How It?

    kartick123 | PDF | Latest reply: kartick123 Sep 28, 2016
    0 replies
  • Excel function Closed

    Hello, I need to auto populate the text in column A into another sheet if the adjacent cell in column B is a certain number. Configuration: Wi...

    DrPrepper | Excel | Latest reply: DrPrepper Sep 28, 2016
    0 replies
  • Issue in Excel Closed

    Hello, i am unable to change the date format in excel... actually it show 42625 but while "F2: 9/12/2016 can you please help me to resolve the iss...

    Ramu | Excel | Latest reply: Mazzaropi Sep 27, 2016
    1 reply
  • If text, return a date Closed

    Hello, Having difficulty here. I have a monthly table (Jan - Dec) with varying text starting is varying months. I want to highlight this arr...

    mistie | Excel | Latest reply: mistie Sep 27, 2016
    0 replies
  • Excel Dates Closed

    Hello, so how would july 7 1999 be written Configuration: Windows 7 / Chrome 53.0.2785.116

    zonia | Excel | Latest reply: ac3mark Sep 27, 2016
    1 reply
  • Name of Workbook, & howm many Number of Row Copied write on Cell Closed

    Hi all, Can anyone please help me below i have added three more column H ,I and J In H Column i would like to give Workbook name which i want to co...

    ajkua | Excel | Latest reply: ajkua Sep 27, 2016
    0 replies
  • excel 2010 doubt Closed

    Hello, i have doubt in excel 2010 need to segregate the data after certain limits. Eg: fdkfkpfokdsl;kfdfkfdpifdflkd-k12383433326-05-2016 Descri...

    Ram | Excel | Latest reply: ac3mark Sep 26, 2016
    1 reply