Excel Forum

Ask a question
Search
Close
Results 4201 - 4250 of about 9,830
  • Format based on another cell with a letter. Closed

    Hello, I would like to know if there is a way to apply a format formula to a cell but to use a letter as criteria instead of a number? Example:...

    armnof | Latest reply: ac3mark Jan 22, 2015
    1 reply
  • Copy the whole column on to the another column master sheet Closed

    Please help. I want to make an excel sheet in which i can copy one whole column onto the another column in all my sheets of master sheet. For exampl...

    khanshabaazkhan | Latest reply: khanshabaazkhan Jan 22, 2015
    0 replies
  • Regarding Pivot Solved/Closed

    Hi I am doing Pivot for multplie data . In the Value field ( bottom right ) , I need SUM as default instead of count . I have to drag multiple ...

    Karthikeyan1207 | Latest reply: Karthikeyan1207 Jan 22, 2015
    2 replies
  • Colouring the rows if some conditions are meeting Closed

    I am trying to create a macro of some sort to do some checks to make sure everything is populated correctly. Here is an example of the spreadsheet... ...

    pamla2015 | Latest reply: pamla2015 Jan 22, 2015
    0 replies
  • Paste at end of data Closed

    Hello, I'm trying to write something that will copy and paste cells AC10:AQ15 from a sheet called "Format" to the end of column AC on the sheet ca...

    LV | Latest reply: LV Jan 22, 2015
    4 replies
  • Need macro code Closed

    Hi, I have a data in sheet1 with ID, name ,area, amount,January amt,February amt.....(below month column particular dates are mentioned) Anybod...

    Johnzz | Latest reply: Johnzz Jan 22, 2015
    0 replies
  • Counting Words, Names as Number Values Closed

    Hi, Ive been searching for a way to count a list of names as a number. I currently have to place a 1 in a column next to the list of names. And have ...

    nexgenpro | Latest reply: RayH Jan 21, 2015
    3 replies
  • Find the first available (empty) cell on a worksheet. Solved/Closed

    As a newbee to VBA, my boss has given me an impossible task ... Basically I need to be able to enter one cell worth of data from one sheet of a wor...

    BrianGreen | Latest reply: BrianGreen Jan 21, 2015
    19 replies
  • function for finding unique data in one spreadsheet to a second Closed

    Hello, I have a spreadsheet of 500 rows. Each row contains on unique "item Number". I am looking for function that will locate the unique number i...

    Kopinion | Latest reply: Kopinion Jan 21, 2015
    0 replies
  • Trying to see if I can even create a Macro! Please help! Closed

    I want to know if its even possible to create a Macro whenever I copy/paste information that is provided to me weekly, which in this case is in th...

    almacgtz | Latest reply: RayH Jan 21, 2015
    3 replies
  • Lookup problem. Solved/Closed

    I have a column of 20 dates in col. B spaced by 2 or 3 weeks, and a number beside each one in col. C. In cell C24 I need a formula that returns the v...

    pothole | Latest reply: Babu546 Jan 21, 2015
    5 replies
  • copy row from sheet 1 to sheet 2 Closed

    Hello, Please help as this is doing my head in.... I Have two worksheets, for arguments sake "sheet 1" and "Sheet 2" within my workbook, I wish...

    Aaron | Latest reply: Aaron Jan 21, 2015
    0 replies
  • Copy Paste Data in Same column for multiple time Solved/Closed

    Hello, i need following manipulation.... Data Before Column "A" 123456 123456 123456 123456 123456 ( After )Column "A" (After copy p...

    sudeep.leadtech | Latest reply: sree Jan 21, 2015
    5 replies
  • macro Closed

    hi friend, i have txt files in folders i want to cumulate all txt files in single file and import data to excel please provide macro for this

    kovoori | Latest reply: kovoori Jan 21, 2015
    0 replies
  • How to change text color dep.on the value of another cell. Closed

    Hello, I have 2 questions: 1. I'd like to change one's name color to red if that is in debt. 2. want to count a. all names (number of all people); b...

    noxat | Latest reply: ArashMan Jan 20, 2015
    1 reply
  • multiple IF functions with dates Closed

    Hello, I am rather new to creating Excel formula I want to create the following rule working with dates: IF date in A1date in A2, then date ...

    CJ | Latest reply: ArashMan Jan 20, 2015
    1 reply
  • compare a cell whit itself (conditional formating) Closed

    Hello, i want to know is that possible to compare a value of a cell with itself. for example i enter "10" in cell B2 tomorrow i want to change it...

    ArashMan | Latest reply: ArashMan Jan 20, 2015
    1 reply
  • due date reminder ahead of one month and mail that to customers? Closed

    dear sir/madam Here there are 6 columns with 'n' number of rows. Column 'E' represents DUE DATE of particular 'Sol ID' and this date is common...

    Babu546 | Latest reply: xpcman Jan 20, 2015
    1 reply
  • Replacing Duplicates Solved/Closed

    My Excel spreadsheet is set out as follows: A B C D E F 1 2 14 0 14 14 2 1 13 0 13 13 3 4 4 1 4 4 4 3 3 1 3 17 ...

    whatsit | Latest reply: TrowaD Jan 20, 2015
    38 replies
  • compare and copy in column Closed

    I want to copy data in column 'B' when column 'A' is not blank. 'A' column has some blank rows. please give me solution!

    sigmasolve | Latest reply: vcoolio Jan 20, 2015
    3 replies
  • Excel - Macro to highlight Rows with Duplicate values in a cell Solved/Closed

    Geetings, Kindly help us in creating a macro that highlight rows based on duplicate values in a cell [this cell may contain Alphabets, Numbers or ...

    ajaydwivediji | Latest reply: TrowaD Jan 19, 2015
    11 replies
  • KEY BOARD SHORTCUTS TO NAVIGATE ALONG AN EXCEL SHEET Closed

    Hi all, I would like to know if there is a keyboard shortcut to navigate from, for example sheet 1 to sheet 2 on the same excel file without using th...

    Kiviangu | Latest reply: BunoCS Jan 19, 2015
    1 reply
  • Macro for copying data from multiple woorkboks in to single wrkb Closed

    Hi All, I need to copy data from 20 workbooks and save in the single workbook, by using condition like, " Date " so if run the macro all the workbo...

    narun226 | Latest reply: narun226 Jan 19, 2015
    0 replies
  • IF function with DATE in Excel Solved/Closed

    Hi, hope someone can assit. I need to create a sheet where I must take the current date and add a fulle week or two weeks to the date by selecting an ...

    ace-82 | Latest reply: ace-82 Jan 19, 2015
    2 replies
  • How can I create worksheet as date from 1 Jan 15 to 31 Dec 15 Closed

    Hello, I would like to create 365 worksheets with sheet name as date. Could anyone help me. Many thanks in advance. :))

    rungjungz | Latest reply: vcoolio Jan 19, 2015
    1 reply
  • Highlight duplicate rows based on selected columns - excel macro Closed

    Hello All, Require a macro which could highlight the duplicate rows in excel. Duplicate is identified based on the selected columns. Table: C...

    paul_roshan | Latest reply: paul_roshan Jan 18, 2015
    0 replies
  • function in excel that auto identify the words from the other s Closed

    I would like to know if there is any function in excel that auto identify the words from the other sheets and apply the formula on that specific cell ...

    wajeea | Latest reply: wajeea Jan 17, 2015
    0 replies
  • Unprotect sheet greyed out Closed

    Hello, i cannot unprotected my Excel sheet please help me with this problem. i appreciate your answers and thank you. Configuration: Wind...

    ArashMan | Latest reply: ArashMan Jan 17, 2015
    0 replies
  • unprotect sheet greyed out Closed

    Hello, i cannot unprotected my Excel sheet :( Configuration: Windows 7 / Firefox 38.0

    ArashMan | Latest reply: ArashMan Jan 17, 2015
    0 replies
  • copying data from multiple worksheets to a summary worksheet Closed

    I have data in 2 cell ranges (A1:D1) and (Q103:S103) from each of about 150 worksheets to copy to a summary worksheet in the same workbook. In the sum...

    lmcmanus | Latest reply: lmcmanus Jan 16, 2015
    0 replies
  • Excel Macro - Insert Rows between existing cells and copy them Closed

    I'm trying to create a macro that inserts 49 blank rows then fills them with the first row, but I need this to be on a loop because I have 800 entries...

    TaudH | Latest reply: TaudH Jan 16, 2015
    0 replies
  • repeating a list of data x number of times Closed

    Hello, I'm working on an agent daily activity sheet and need to put together a sheet that will grab a list of ID#s then repeat for the number of w...

    JohnnyMike | Latest reply: JohnnyMike Jan 16, 2015
    0 replies
  • Please: worksheet comparison Closed

    Hello, Please. I have two worksheets, each with the same 10 or so columns. In the newer one, a few rows have been added, a few deleted. In the man...

    dlminehart | Latest reply: dlminehart Jan 16, 2015
    0 replies
  • vba macro entry transfer automaticallly another sheet Closed

    Hello sir, four or more entry transfer automaticallly another sheet like name,address,code,qty,in vba base so please help me Configuration: Wi...

    db | Latest reply: db Jan 16, 2015
    0 replies
  • Macro for copying data from different sheets Solved/Closed

    Hello, I am trying to copy data from different sheets to master sheet under the following criteria 1. Master sheet should be generated when ev...

    Kishore | Latest reply: NK Jan 16, 2015
    23 replies
  • IF / AND function and Date range Closed

    I am trying to create a spreadsheet that tracks when jobs commence and complete. I have been working with the IF and AND functions but can't quite see...

    Magoo2015 | Latest reply: Magoo2015 Jan 15, 2015
    3 replies
  • Excel 2007 : Conditional Formatting issue concerning colors Closed

    Dears, I've successfully put a conditional format in my document, but I would like to have the whole row in color in stead of only 1 cell. Does ...

    Geoff84 | Latest reply: RayH Jan 15, 2015
    1 reply
  • useing (='sheet'!cell) if the sheet name is depending on cell Closed

    Hello, how to use (='sheetname'!targetcell) if the sheetname is in cell A2(sheet1) and the target is C3 ='sheet1'!C3 is working, but the sheet ...

    amj | Latest reply: RayH Jan 15, 2015
    1 reply
  • Worksheet comparison Closed

    I have two worksheets, each with the same 10 or so columns. In the newer one, a few rows have been added, a few deleted. In the many (1000 or so, henc...

    dlminehart | Latest reply: dlminehart Jan 15, 2015
    0 replies
  • Batch printing results Closed

    We were provided with an Excel spreadsheet that will display data for a case number, which we are then instructed to print. This came with a list of 6...

    Tanyamc | Latest reply: Tanyamc Jan 15, 2015
    0 replies
  • Trying to sum a column that contains various text Solved/Closed

    I'm a novice when it comes to excel and I'm hoping someone can help me with a formula. I'm trying to give a value to various text in columns and then ...

    chris82675 | Latest reply: chris82675 Jan 15, 2015
    3 replies
  • Trying to add a value if a test result is positive or negative Closed

    Hello, I have been asked to build a spreadsheet to calculate patients follow up depending on their blood test result. I will only know if the ...

    Choo | Latest reply: vcoolio Jan 15, 2015
    1 reply
  • Excel 2007 : Change collor if date today is < given date -30days Closed

    Dears, Does anyone know how I can highlight a date in red or green when a given date passes the last 30 days cf date today? ex 1 Today : 15/01/...

    Geoff84 | Latest reply: Geoff84 Jan 15, 2015
    0 replies
  • Excel Query Urgent Please. Solved/Closed

    Hello, I have the below data in sheet 1, where as in column A its the activity and column b its the name of person who has done it. and the names ...

    wasey | Latest reply: wasey Jan 15, 2015
    11 replies
  • Is there a FORMULA for this issue? THANK YOU IN ADVANCE Closed

    Hello, Please help, the issue goes like this, I want to find a NAME within a RANGE of CELLS and the result would be the LATEST DATE they have i...

    Sha | Latest reply: RayH Jan 14, 2015
    1 reply
  • Text cell text cell Closed

    Hello, I need help with the following in Excel, I would like to have text then enter cell form another page then enter more text then another ce...

    HA | Latest reply: HA Jan 14, 2015
    0 replies
  • Excel list item automatically generates a new list Closed

    Hi! Hoping someone can help ;D In Cell A1 there is a list called "clothing" (a drop down box). In the list you can choose "T-shirt" or "Sweats...

    zivasi | Latest reply: RayH Jan 14, 2015
    1 reply
  • Autopopulate a templated spreadsheet with another spreadsheet Closed

    Hello, We use Salesforce.com as our CRM and database, with regular use of reports. Naturally, we use those reports for sales and business developm...

    fanieto2 | Latest reply: fanieto2 Jan 14, 2015
    0 replies
  • Conditional Formatting comparing dates Closed

    I have two columns, that each have dates in them. I want to take Column A, subtract 100 days, then compare it to Column B. If Column B is less than C...

    SLD | Latest reply: RayH Jan 14, 2015
    1 reply
  • moving complete lines Closed

    i have a workbook with a number of sheets, i would like to have the data on a complete line from one worksheet move to another when i insert data in t...

    gregmac4231 | Latest reply: gregmac4231 Jan 14, 2015
    0 replies