Excel Forum

Ask a question
Results 5501 - 5550 of about 9,840
  • macro to populate formula using Autofill Closed

    i have 2 worksheets, A & B. In worksheet A, i have the data in cell F2, F3, F4. In worksheet B, i would like to refer worksheetA!F2 in Column G,...

    mayek25 | Latest reply: TrowaD Jul 15, 2013
    3 replies
  • Plotting multiple data Closed

    Hello, How do I plot a table with multiple data like this: For May: Project 1 Project 2 Project 3 Item 1 5% ...

    diestra123 | Latest reply: diestra123 Jul 15, 2013
    0 replies
  • comparing the two excel sheet, what formula is required Closed

    I have two excel sheets one column haveing the same numbers both the sheets, Now in same number I have alloted different compaines, now I need to ...

    VJKJVK | Latest reply: VJKJVK Jul 15, 2013
    0 replies
  • Help with a Formula 'Isblank refer to another cell" Closed

    I need a formula that will give me number of days between two columns Which contain dates, if one or the other has no date populated it would then ref...

    lilylana1 | Latest reply: venkat1926 Jul 14, 2013
    1 reply
  • Averaging & Assigning Blank Cells a Specific Numeric Value Closed

    Good day everyone. I'm sorry if this seems remedial, but I'm having trouble with a spreadsheet. Here's the gist of my problem: Within a row, I have se...

    averagejoem | Latest reply: venkat1926 Jul 13, 2013
    3 replies
  • proportions?ratios? not sure Closed

    I have an excel spreadsheet with four different money columns. I am trying to develop a formula that might create a comparison similar to what I thin...

    notechwizard | Latest reply: notechwizard Jul 12, 2013
    0 replies
  • Copy data from Master Sheet to Client Sheets Closed

    Hello All Good Day I Need Some help from you that is i want to copy the data from Master Sheet to Client Sheets with Criteria Columns for your b...

    sgmpatnaik | Latest reply: sgmpatnaik Jul 12, 2013
    0 replies
  • How I convern number to spelling in excel Closed

    Dear friend, This is my problem. Please solve it.

    ajitkumarber... | Latest reply: Ambucias Jul 12, 2013
    1 reply
  • Pull values from conditionally formatted cells - Excel 2013 Closed

    hello, I have a large data set wherein I am trying to figure out where certain values fall and am applying a cell color using conditional formattin...

    rohan.gupta23 | Latest reply: venkat1926 Jul 12, 2013
    3 replies
  • How to add a seperator / between fields, create function Closed

    Hi, I am running a macro copying AA2:AA300 to B and copyiing AB2:AA300 to C this is done for 20 more columns going in B and C how can I add a line...

    keeptrying | Latest reply: keeptrying Jul 11, 2013
    0 replies
  • Comparing Columns Closed

    Hello, I have two list of customers on separate excel worksheets. The first list has name, address, etc. in separate columns and about 3000 custome...

    djoell | Latest reply: Muhasin AM Jul 11, 2013
    1 reply
  • Hide rows with zero value in Multiple sheets Solved/Closed

    Please help me in making a macro in the Excelsheet that: I can hide the entire rows if a cell value or (range of values) has a zero value in multiple...

    issa abu Ham... | Latest reply: Excellent answer Jul 10, 2013
    2 replies
  • Populate rows on sheet1 based on values in sheet2 Closed

    Hi, I need to populate rows in sheet1 -- S.No, Name , Address, Contact No. with the values present in sheet2 -- S.No, Name , Address, Contact No. ...

    nickki | Latest reply: venkat1926 Jul 10, 2013
    3 replies
  • pop up alert Closed

    Hello, I have created a worksheet with macro to enter current time by clicking on a cell. For example, double click on A1 to enter current time th...

    totzkie10 | Latest reply: venkat1926 Jul 10, 2013
    1 reply
  • Display Formula in Cell with values Closed

    i need to display the used formula in another cell as it is with substituting the values. example: if A1=100, A3=200, B1=206 formula is =SUM(A1, ...

    ahamadbasha | Latest reply: TrowaD Jul 9, 2013
    1 reply
  • macro for copying sheet 1 into sheet 2 and then deleting data in Closed

    i need macro for copying sheet 1 into sheet 2 and then deleting data in sheet 1 and sheet 3 plz help

    ss_bit03 | Latest reply: TrowaD Jul 9, 2013
    1 reply
  • Marco to add multiple images by filename Closed

    Hello, I have a spreadsheet with 10 vlookup's in, reading from a Pivot Table on a separate tab. What I need is a macro to pull 10 image files from...

    underhill284 | Latest reply: underhill284 Jul 9, 2013
    0 replies
  • Conditional formating Solved/Closed

    I have a spreadsheet with Excel 2013 that has text drop down lists. I want to use conditional formatting to highlight with a different cell color, dep...

    jgmb | Latest reply: jgmb Jul 9, 2013
    10 replies
  • I need to run multiple automatic macros in one sheet Closed

    I am developing a worksheet where there are multiple occasions down a list where users will have to select an option from a drop-down box (Y, N & N/A)...

    akts | Latest reply: zs1986 Jul 9, 2013
    4 replies
  • Using head in VBA Closed

    Hello, I would like to automating some operation with macro, and here is a problem with the head. At the beginning I've attached files that are d...

    jpppol | Latest reply: jpppol Jul 9, 2013
    0 replies
  • Calculate Time in and Time out with Money Closed

    Can you let me know please? I have internet shop and i want to create time calculation(Time in, Time out) and total in hours of usage and calculate i...

    VeasnaYim | Latest reply: VeasnaYim Jul 8, 2013
    0 replies
  • Need to move "Received" jobs to new worksheet. Closed

    Hello, I have a workbook named "Logistics Report" where I keep track of playground equipment. Once the equipment is received I need to move it to a...

    sfritz17327 | Latest reply: sfritz17327 Jul 8, 2013
    0 replies
  • Map/Copy values from one sheet to another where column 1 matches Closed

    I have two sheets in a spreadsheet. Each sheet has a first column with common values (however they are not sorted the same and they are not all there...

    bbddpp | Latest reply: bbddpp Jul 7, 2013
    0 replies
  • Convert a date field in excel to day of week Solved/Closed

    Hello, I know how to format a cell with a date in it so that it shows the day of the week. WHat I am trying to do is sort on the day of the week so...

    C | Latest reply: Indian Jul 7, 2013
    7 replies
  • VBA create Listbox and populate with Hyperlinks Closed

    Hello all, I am working on a project to create a data pull from the internet to obtain a news feed for a given stock. I currently ran into a proble...

    Chrisebell | Latest reply: Chrisebell Jul 6, 2013
    0 replies
  • i need help with excel formula Closed

    Hello, I have a database of people requesting their points to be transferred from one account to another, frequency of transfers is a combination ...

    emens16 | Latest reply: emens16 Jul 6, 2013
    0 replies
  • date format Closed

    in MS-Excel, When i am sorting the dates in a column of format dd/mm/yyyy, say example 10/06/2007 and 02/10/2007, the sorted column shows 02/10/2007 i...

    new version | Latest reply: sgmpatnaik Jul 6, 2013
    1 reply
  • Conditional formatting of cells with dropdownlist Closed

    In column C of my spreadsheet i have created a drop down of a set of 96 locations in US. When i select a certain location from the drop down , i want ...

    amrita.misra | Latest reply: venkat1926 Jul 6, 2013
    1 reply
  • Comparing columns and returning value Closed

    i've following: 1. Drop down values from 1 to 5 in column A. 2. Drop down values from A to E in column B. Ive following matrix (A44:C68): 1 ...

    SATSY | Latest reply: venkat1926 Jul 6, 2013
    7 replies
  • some help needed about IF function with dates Solved/Closed

    Hello, i m making a sheet with this function =IF(H1

    rizwan32 | Latest reply: sgmpatnaik Jul 5, 2013
    3 replies
  • Macro to transfer data from one sheet to another Closed

    Hello, I would like to know whether this is possible using macros in excel Sheet 1 Column A Column B Column C Column D Column E C...

    bebongtheshark | Latest reply: TrowaD Jul 4, 2013
    1 reply
  • Deleting a row Closed

    I have an Excel file with rows from 2 to 988. There are two columns B titled Customer and C titled Main Email. I need a macro that will search column ...

    martinezbm | Latest reply: TrowaD Jul 4, 2013
    1 reply
  • Transferring Selected rows to Another location on anothersheet Closed

    I Am trying to Move a selected range of cells to another sheet. As an example "sheet1" Columns C,D,E,F,G,has a data list entered and when i enter th...

    jswilson | Latest reply: TrowaD Jul 4, 2013
    4 replies
  • Odd situation in Excel Closed

    Hello, I'm designing a spreadsheet for my work in terms of I've got a set of numbers from 0-99, the evens are one week events and the odds are ano...

    jeffaruni | Latest reply: TrowaD Jul 4, 2013
    6 replies
  • Substracting time from date & time to determine the date & time Closed

    I have a 'simple' spreadsheet with five columns (warehouse #; part #; departure date & time; transit time and arrival date & time). I have packages...

    AzRdWarrior | Latest reply: TrowaD Jul 4, 2013
    3 replies
  • Help with macros in excel Closed

    Hello, I was wondering if anyone could help me in creating a macro file for excel....I am needing to save, print, and close an excel file at a cer...

    trublood fan | Latest reply: sgmpatnaik Jul 4, 2013
    1 reply
  • Need Macro for Generate report table based on some critera Closed

    Hi, I have a Table with 10 columns and 21 Rows. Last column has %allocation that is 'I' Cell of each Row divided by 8.75 and multiplied by 100. Exa...

    Lenin.gce | Latest reply: Lenin.gce Jul 4, 2013
    0 replies
  • Pls suggest for Excel Closed

    Dear all, Pls suggest for my following issue related to Microsoft Excel. I created a Report in Excel having many sheets. In all sheets, Subsc...

    ugn10 | Latest reply: sgmpatnaik Jul 4, 2013
    1 reply
  • creating pdf from selected cell range Solved/Closed

    Dear all, greetings. firstly , I would like to thank those who have helped me to get below code (to create pdf file for selected cell range) whic...

    cvsuryam | Latest reply: sgmpatnaik Jul 4, 2013
    1 reply
  • how to compare two coloumns in excel Solved/Closed


    vijay | Latest reply: jhanvi Jul 4, 2013
    11 replies
  • HELP!! Excel 3 year reminder Closed

    I have a formula: =TODAY()-$B2>3, this will remind me 3 days before a due date, but I need it to tell me to review after 3 YEARS of the dates I have i...

    Tricia Kozuki | Latest reply: TrowaD Jul 2, 2013
    2 replies
  • Please help- conditional formatting Closed

    Hello, I want help to solve below described question for excel 2007. CELL A1= 01-JAN-2013, A2= 02-JAN-2013, A3= 05-JAN-2013, A4= 07-JAN-2013, A5...

    chdm2013 | Latest reply: TrowaD Jul 2, 2013
    1 reply
  • Formatting Excel Closed

    Hello, i got a problem regarding excel formatting. Excel displays every figure higher then 1.0 as a date and anything lower than that as the ac...

    desgo | Latest reply: LynxDeuxJynx Jul 1, 2013
    1 reply
  • i lost data Closed

    Hello, i had a file with some data and one of my kids entered this file and changed evrthing and saved the data. and i need the old data. how can ...

    demis.design | Latest reply: LynxDeuxJynx Jul 1, 2013
    1 reply
  • Macro to insert a row after 6 rows and 45 rows Closed

    Hi all, I'm new here and hope you guys can give me some advice and help to end my problem! I have a large data set containing "control values" a...

    gamedanny | Latest reply: venkat1926 Jun 29, 2013
    5 replies
  • Macro Insert Headers after sorting Closed

    Hi All, I have a spreadsheet that would contain a hundreds of thousands of invoices. But to simplify, I am more concerned about the following: H...

    geekboy101 | Latest reply: venkat1926 Jun 28, 2013
    5 replies
  • Update data records Closed

    I have a specific range of cells in a column. For eg In sheet1 from D3 to D12 I keep on entering various alpha numberic code from 3 digit to 8 di...

    eexpert | Latest reply: ac3mark Jun 28, 2013
    1 reply
  • copy row paste at the top of each page Closed

    I need to copy a row, then paste it on the top row of multiple pages.

    paulcc | Latest reply: paulcc Jun 27, 2013
    2 replies
  • Validation Warning for repeating a number in a column Closed

    Hello, I am using a spreadsheet that compares properties, within different grid squares. The column for grid references has numbers prefixed with t...

    barewirewalker | Latest reply: TrowaD Jun 27, 2013
    7 replies
  • Excel : If value is in column A, then delete cell in column B Closed

    Hello, This is what I want to do : Column A : value1 value2 value3 value4 value5 Column B : value1 value22 value33 value44 valu...

    Johan222 | Latest reply: TrowaD Jun 27, 2013
    5 replies