Excel Forum

Ask a question
Results 5901 - 5950 of about 9,840
  • Formating Date Solved/Closed

    Hello, I have date in a cell now i want to see the next cell red color if the next cell is not filled up by the next 10 days from 1st cells date. ...

    shishacu | Latest reply: shishacu Dec 19, 2012
    9 replies
  • Help with comparing/deleting columns Closed

    Hello, I will be eternally grateful if anyone can help me with the following scenario. I have 4 columns Vendor_Name Vender_Code In...

    Dryst999 | Latest reply: rizvisa1 Dec 17, 2012
    6 replies
  • Formulas Closed

    Hello, I ve forgotten some formulas used in excel. Please someone should with this formula used to set ranks eg, first, second, etc. Configur...

    Red hunter | Latest reply: rizvisa1 Dec 16, 2012
    1 reply
  • cpoying data from one sheet to another Closed

    Hello, i have a excel file. in sheet on i have some data like sr no........name...........father's name.........roll no........ 1..............raj...

    sbbj.sunil | Latest reply: rizvisa1 Dec 16, 2012
    4 replies
  • Match barcode between 2 sheets Solved/Closed

    Hello, I have two diffrent sheets. One sheets has tens thausand lines with barcode value,description and quantity of product. another one has 2...

    Ram | Latest reply: TrowaD Dec 13, 2012
    3 replies
  • Excel multiple function Closed

    Hello, I need to put multiple functions into a one cell result in Excel. The result of one function (result A), squared (result B) and that numb...

    jenjen122176 | Latest reply: rizvisa1 Dec 12, 2012
    1 reply
  • i want to extract specific data from microsoft excell cell Closed

    Hello, i want to extract the following details into another collumn (bold ) from data in collumn B1 into C1. The information i want begins with 3 di...

    kormanda | Latest reply: rizvisa1 Dec 12, 2012
    1 reply
  • How can I eliminate #VALUE in calculated cells Solved/Closed

    Hello, I am building an Excel calculation sheet for cookeries for christmas. In cell H$7 I have the input for how many times I would like to ...

    hwrychen | Latest reply: hwrychen Dec 9, 2012
    14 replies
  • Excel/Toshiba problem Closed

    Hello, having a problem in Excel. my arrow keys seem to work spontaneously and are continuously scrolling me across the screen - makes it difficul...

    helenrrose | Latest reply: rizvisa1 Dec 8, 2012
    1 reply
  • How to find missing numbers in a seperate column from 2 columns Closed

    Hello, I have data in 2 columns (given below) and want to compare both the columns and want to get the missing numbers in seperate column. e.g ...

    bhatt.1983 | Latest reply: rizvisa1 Dec 8, 2012
    1 reply
  • convert currency (Indian) into words Closed

    Hello, daer Sir, i need to convert currency (Indian) into words while working on my excell work sheet,as in Excell there is no farmula availab...

    javaidkaw | Latest reply: rizvisa1 Dec 8, 2012
    1 reply
  • How you can get an atomatic serial number in a particular column Closed

    Hello, Suppose A1 is serial, B1 persons name, C1 amount due, D1 amount paid, E1 invoice number, F1 is invoice date and so on, that is A2, B2, C2........

    newazz | Latest reply: rizvisa1 Dec 7, 2012
    2 replies
  • Excel Macro Sort and Data series Closed

    I'm looking for a macro that will accomplish 2 things: first I want to sort a range called "data" primary key is "com", secondary key is "cvt", next ...

    jggrnt | Latest reply: rizvisa1 Dec 7, 2012
    1 reply
  • Conditional Formatting Highlight Entire Row Based on Date Closed

    Hello, I'm trying to highlight an entire row in excel if the date in column B is later than today. Can you help? Please. Configuration: Window...

    ChristinaBra... | Latest reply: rizvisa1 Dec 6, 2012
    1 reply
  • Help with a VBA code Closed

    Hello, I'm trying to configure the DEL key to clear the contents and Unlocked the cell (if Locked). I create the module: Public Sub MyDelKey() ...

    amedotero | Latest reply: rizvisa1 Dec 6, 2012
    12 replies
  • Look for values from a different sheet and return it Closed

    Hello, So I am working with a file that has 2 sheets. Sheet 1 has columns A,B,C,D Sheet 2 has Column. A B C D For both sheets, column A= ...

    Need2Learn | Latest reply: rizvisa1 Dec 4, 2012
    3 replies
  • Macro Help Closed

    Hello, I wrote the below macro but my problem is the number of rows change each month so i would like to have an autofill the formula from column ...

    EM2010 | Latest reply: rizvisa1 Dec 3, 2012
    3 replies
  • copy range depending on a cell values Closed

    Hello, i am looking for a script that gives me the following : column A to D contains my data that I want to copy to another sheet, E/F contai...

    isengard678 | Latest reply: TrowaD Dec 3, 2012
    5 replies
  • Help with VBA Solved/Closed

    Hello, I'm trying to program a macro in Excell 2010. What I need it to do is look in a Range for the NotEmptyCells and change their property fro...

    amedotero | Latest reply: amedotero Dec 2, 2012
    2 replies
  • Copy data into next empty cell in new sheet Solved/Closed

    Hello, I am trying to make a 2 sheet workbook which has the input details in Sheet1 A1 and this is changed weekly but the info in this cell shoul...

    nikwak | Latest reply: rizvisa1 Dec 1, 2012
    15 replies
  • Copy rows a set number of times Closed

    Hello, I have a delivery manifest that shows the amount of products coming in, descriptions etc. that we use to produce barcode labels. Unfortunat...

    Tom | Latest reply: rizvisa1 Dec 1, 2012
    5 replies
  • Organizing data Closed

    Hello, This is not as clear as it could be but I will try. I have a spreadsheet that has two columns. The left column (A) is populated by 8-Digit ...

    calflamesfan... | Latest reply: rizvisa1 Dec 1, 2012
    1 reply
  • Excel VBA/Macro for Keyword based search on listed URLs. Closed

    Greetings respected team, Kindly advise if it is possible to create an Excel based VBA or Macro that helps search predefined keywords in predefined...

    ajaydwivediji | Latest reply: rizvisa1 Dec 1, 2012
    1 reply
  • macro to create sales report Closed

    Hello, i have a set of invoice] in excel formats in a folder. I need to generate a sales report for this. sales report should contain bill no, dat...

    sreejeshsant... | Latest reply: rizvisa1 Dec 1, 2012
    1 reply
  • Worksheet Columns added into one worksheet Closed

    Good Day! I need to take Column/Row: M18 from worksheets 05202011 thru 12302011 (example: sheet 14 thru sheet 46), add and enter in to blank/anothe...

    lkwoodc | Latest reply: rizvisa1 Dec 1, 2012
    1 reply
  • Auto filter problem Solved/Closed

    Hello, when i am filtering any item for adding value in that item, it will gets filter but the blank cell coming at last is much further behind th...

    miteshmech87 | Latest reply: rizvisa1 Dec 1, 2012
    1 reply
  • Recalculate formula when format changes Closed

    Hello, I have a VB module that sums cells with a specific color background. It works fine but I have to click on the cell with the formula to get...

    simpsoj40 | Latest reply: rizvisa1 Dec 1, 2012
    1 reply
  • Splitting list of names with formula - can you spot what's wrong Solved/Closed

    Hi everyone, I have a list of 1805 names which are gathered in a single column. These names range in length and "format" (e.g. John Smith, John C ...

    excelamateur | Latest reply: Zohaib R Nov 30, 2012
    4 replies
  • VBA query Closed

    Hello, I'm trying to program a macro in Excell 2007. I want to put up formular for multiplying various columns and dividing eg((A5*B5)+A5)/C5...

    bkaromo | Latest reply: Zohaib R Nov 30, 2012
    1 reply
  • IF FUNCTION in excel Solved/Closed

    Hello, my formula is =If(or(A5="016f7",A5="016b8",A5="017a3"),The monthly instalment is equivalent to...........,"") I want in place of ..........

    bkaromo | Latest reply: bkaromo Nov 30, 2012
    5 replies
  • Comparing two excel worksheets Solved/Closed

    Hello, I am trying to find an easy way to compare and extract data from two excel worksheets. This is the scenario.. I have an excel worksheet ...

    squirrel | Latest reply: lcouri Nov 28, 2012
    10 replies
  • Help with populating multiple IF functions Closed

    Hello, I'm working in an excel workbook with several sheets. I want information from the "Income" sheet to populate to the "Discounts" sheet whe...

    MelyElly | Latest reply: Zohaib R Nov 28, 2012
    3 replies
  • Cut/Copy in VBA Solved/Closed

    Hello, I am fairly new to Macros but I am trying to write vba code in Excel 2003 version that will enable me to cut/copy a table from one worksh...

    Chamberlyn | Latest reply: Chamberlyn Nov 26, 2012
    3 replies
  • Excel Adding a price to data entered Closed

    Hello, here's my problem, I have a scanner which I scan my product with and it enters the product into a cell and I want excel to be able to recoginis...

    wayno | Latest reply: aspperasp Nov 26, 2012
    4 replies
  • Create a DBR - Database Reporting tool for a list of exceptions! Closed

    Hello, I am new to VB programming. I need your help to make a DBR - Data base Reporting tool for the back end process at work which could be als...

    shanx.gr | Latest reply: Zohaib R Nov 26, 2012
    5 replies
  • convert Closed

    Hello, how to convert numeric to alphabet in excel ? Thanks Configuration: Windows XP / Opera 9.80

    manzoor123 | Latest reply: Zohaib R Nov 26, 2012
    1 reply
  • macros in my spreadsheet Closed

    Hello, I managed to create a macro to show the following: If (I30,I3*G3,H3*G3) and this repeats itself for cell N3,R3, V3,Z3 ETC. I need this...

    artyguns | Latest reply: TrowaD Nov 26, 2012
    1 reply
  • Automation Closed

    hello , i used to make a report on excel which exceed more than two hours every day i will mention the report in breif i have a big report whi...

    optimistic | Latest reply: TrowaD Nov 26, 2012
    1 reply
  • Macro to move rows in excel automatically Closed

    Hello, I need to create a macro for Excel2010 that moves one to two rows of information to a preceding row and adds each row as a set of new colum...

    excelhelp33 | Latest reply: excelhelp33 Nov 25, 2012
    9 replies
  • Covnvert numbers to single words Solved/Closed

    Hello, In excel 2010 i would like to convert numers to words i.e. 123.00 (one two three point zero zero) or 1006235.23 (one zero zero six two thre...

    naaur | Latest reply: venkat1926 Nov 23, 2012
    3 replies
  • Tranferring of Excel Closed

    Hello, I have two excelwork sheets For example A and B. Sheet1 of Workbook A consists of data and sheet1 of workbook B is empty. I want to transfe...

    srikanth | Latest reply: srikanth Nov 22, 2012
    0 replies
  • Leaving a Cell Blank if one value of the formula is blank Closed

    Hello, I was making a template to be distributed to multiple receivers. Since the template is blank and must automatically count the number of day...

    peckman | Latest reply: MelyElly Nov 21, 2012
    2 replies
  • using multiple if functions with data validation Closed

    Hello, Im trying to create a pull down menu with data validation, however for example if M4 = VT-901 then I want to be able to select a size 1080,...

    chriswiec | Latest reply: Zohaib R Nov 21, 2012
    5 replies
  • Compare and copy data from one column to another Solved/Closed

    Hello, I'm trying to compare column A in Sheet 1 with column A in Sheet 2, then copy corresponding values in column N from sheet 1 to column N in ...

    VBLearner | Latest reply: Zohaib R Nov 20, 2012
    4 replies
  • Excel Mini Challenge Closed

    Hi, I need to compare 2 versions of the same data which reside on 2 different worksheets (within the same workbook). On the first sheet (the...

    JeffAce | Latest reply: TrowaD Nov 19, 2012
    3 replies
  • Forluai Closed

    Hello, I am using Microsoft office as well excel, I am not expert in excel. Could you give a favour for its formulas and their applying tricks and...

    rizkhan989 | Latest reply: venkat1926 Nov 18, 2012
    1 reply


    lancymenezes | Latest reply: Zohaib R Nov 16, 2012
    1 reply
  • excel formulaes Solved/Closed

    Hello, If there are two conditions, how to use the IF formulae. Regards

    lancymenezes | Latest reply: lancymenezes Nov 16, 2012
    3 replies
  • Help on generating a number series using a macro Solved/Closed

    Hello, I would appreciate your help with a macro I am trying to create in Excel 2010 my Data is as below Column1 Column2 Column3 (Name) (start nu...

    sbhambra | Latest reply: venkat1926 Nov 15, 2012
    2 replies
  • Hide rows meeting multiple criteria and search for unique values Closed

    Hello, While hours reading posts and forums have increased my knowledge of VBA in which I can create parts of the following request I am still unab...

    Tonto77 | Latest reply: venkat1926 Nov 15, 2012
    1 reply