Excel Forum

Ask a question
Results 5701 - 5750 of about 9,840
  • Copy data from one workbook to other----Help Closed

    Write macro to copy data from Source File to assignment-2 file. Make sure you take care of following conditions * Book with same name should...

    mandarkhedekar | Latest reply: rizvisa1 Apr 6, 2013
    1 reply
  • Pivot Table Closed

    Hello Friends, I have 3 concerns related to Microsoft Excel which are as following. Pls help me for all these 3 individually.: 1. Suggest me...

    ugn10 | Latest reply: rizvisa1 Apr 6, 2013
    2 replies
  • Copy the exact content from one cell using a formula Closed

    Hi, I need to copy a cell into several other cells with the exact same data ie: D3 auto copy to D7, D11, D15, D19 and so on and on and on i...

    mzkatt21 | Latest reply: rizvisa1 Apr 6, 2013
    1 reply
  • using a data validation AND an IF formula in the same cell Solved/Closed

    hi, I have a spreadsheet in excel 2010 where one of my columns uses a dropdown list using the 'data validation' function. The list details several ...

    bite_tony | Latest reply: bite_tony Apr 5, 2013
    1 reply
  • Writing Macros Closed

    Hello, I am trying to find code that will let me add roles into my data base on a name and then sub-total that information. Please help... Thanks

    vzghrw | Latest reply: sgmpatnaik Apr 5, 2013
    1 reply
  • Filtering with spaces between rows Closed

    Hi All, Is there a way I can filter my column if there are spaces between rows? the spaces were put there for neat presentation purposes. :( thank...

    diestra123 | Latest reply: TrowaD Apr 4, 2013
    2 replies
  • Conditional Formating: Duplicate value in range of cells Closed

    Hello: Using Excel 2010, I'm trying to set up conditional formatting to see if a particular value in column A2 is equal to a value listed anywhere ...

    davidplowman | Latest reply: sgmpatnaik Apr 4, 2013
    1 reply
  • Lock only a few cells on a worksheet Closed

    Hello, I have an excel file having many formula and I want to lock all the cells having formula. Whatsoever cell address, it could be D1, E9, J10,...

    ugn10 | Latest reply: sgmpatnaik Apr 3, 2013
    2 replies
  • How to get multiple rows of info into one row Closed

    Student schedules were sent to me on several lines (one line per class) so each student has from 5-7 rows of information. I want each student to have ...

    ddunkel | Latest reply: Zohaib R Apr 1, 2013
    1 reply
  • different currencies Solved/Closed

    Hello, could you please advise what could be the best way to show in the same table different currencies. Lets say there would be a button which w...

    DG83 | Latest reply: DG83 Mar 30, 2013
    8 replies
  • VBA Lookup Closed

    Hello, I currently have a macro built that takes a value from a specific cell and looks against a lookup table in another work sheet. If the valu...

    froggy6703 | Latest reply: froggy6703 Mar 29, 2013
    6 replies
  • Nested IF Formulas with Times not caclulating correctly Closed

    I have several start/end times and need to also calculate the difference in minutes of those times on occasion. START A END A ...

    MAUTUMNS | Latest reply: Kevin@Radstock Mar 29, 2013
    2 replies
  • Formatting dates Closed

    Help! I need to do a vlook-up between two workbooks with the date being the common between the two. The problem is that the date is formatted in a ...

    Gracie01 | Latest reply: Zohaib R Mar 29, 2013
    4 replies
  • Selecting columns in excel Closed

    Hello, I tried to select a range of cells in excel 2010, using Range("A:H").Select But this selects the whole worksheet. I have tried different w...

    damienjames0 | Latest reply: Zohaib R Mar 28, 2013
    2 replies
  • How to convert number to word Closed

    Hello, ow to fix it in excel always. I get it result only when apply it. but can not fixed. please how can I fixed (Permanently Save) in my computer...

    Harshada | Latest reply: rizvisa1 Mar 26, 2013
    4 replies
  • "Remove Duplicates" macro gives error on protected worksheet Closed

    Hello, Configuration: Windows 7 / Firefox 19.0 I have a macro that sorts and removes duplicates from a fixed selection in a single column. ...

    Pluggie | Latest reply: Zohaib R Mar 26, 2013
    1 reply
  • Macro: Copy row to another header or sheet from a drop down Closed

    Hello, I am creating a spreadsheet which contains a drop down list of categories. I am looking for a solution so when a category is selected it wi...

    VTUK | Latest reply: VTUK Mar 26, 2013
    2 replies
  • How To Compare data in Multiple Columns Closed

    Hello, I have the below data in four columns 14 25 36 214 14 785 114 2563 I have to find out if any two value from the c...

    umesh chaudhari | Latest reply: TrowaD Mar 26, 2013
    1 reply
  • IF function with dates Solved/Closed

    Hello, I'm trying to compare cells with dates. For example: column A column B column C Mar-25 Apr-3 ? In column C I need a...

    ukie113 | Latest reply: ukie113 Mar 25, 2013
    2 replies
  • Pop up message stating empty cells Solved/Closed

    Hello, I am relatively new to VB and I am trying to help a friend build an application form for work. Basically what I am trying to do is, there ...

    benji | Latest reply: shalom1506 Mar 25, 2013
    7 replies
  • getting and error msg "The file you are trying to open "xxx.xls" Closed

    Hi folks, getting and error msg "The file you are trying to open "xxxxx.xls" is in a differernt format than specified by the file extension. Verify...

    jjjslj | Latest reply: rizvisa1 Mar 24, 2013
    1 reply
  • Dates change when copying... Solved/Closed

    Hello, Thanks to this kind of forum, I've been able to deal with issues around the date systems 1900 vs 1904. It remains a problem though since ...

    NgangaKP | Latest reply: NgangaKP Mar 23, 2013
    2 replies
  • Need a macro which copy values from rows and paste into a table Closed

    Hello, Actually I have a payroll in Excel. Each employee's salary detail is in a row. eg S# Name Basic Allo1 ...

    khan436 | Latest reply: rizvisa1 Mar 23, 2013
    1 reply
  • Copy Row based on value of cell, and update row data back Closed

    Hello, I have 3 sheets, "WHOLESALE", WEB SALES" & "ORDERS". If "WHOLESALE" or "WEBSALES" have a value "SPECIAL" in Column "A", it must copy th...

    JEDEMEYER1 | Latest reply: rizvisa1 Mar 23, 2013
    1 reply
  • I would like to compare 2 columns. Solved/Closed

    Hello, I would like to compare 2 columns A to F, if the value is the same I would like to populate the value of column C with the value from Colum...

    dsrice | Latest reply: Zohaib R Mar 22, 2013
    13 replies
  • How to do an automation for copy paste, added new row (macro) Solved/Closed

    Hello, I have attached file http://www.sendspace.com/file/wjh0oe I want to automated a some step (tab table Z) Thus, for example, that in X 201...

    jpppol | Latest reply: jpppol Mar 22, 2013
    11 replies
  • Kindly Request for Excel Help in Cell Formating Closed

    Hello, Configuration: Dell laptop with vista If you have some time, can you please try to help me, I would greatly appreciate any help ...

    grampsgary | Latest reply: Zohaib R Mar 21, 2013
    3 replies
  • Formula help needed Solved/Closed

    Hello, I am in need of a formula. I own a business in which I receive payments from my clients in various ways. I also have multiple locations...

    cromwelld | Latest reply: cromwelld Mar 20, 2013
    9 replies
  • Updating multiple sheets from a master sheet Closed

    Hello, Please, how do I create a mapping between multiple sheets and a master sheet all in the same workbook? I have at least 400 sheets and ther...

    Beenicki | Latest reply: Zohaib R Mar 20, 2013
    1 reply
  • Entering value for column at once, displaying in all sheets Solved/Closed

    Hello, I have a workbook with multiple sheets(1,2,3) , each sheet has list of items randomly placed, the same items are repeated in other sheets ran...

    ziauddinm | Latest reply: Zohaib R Mar 20, 2013
    1 reply
  • import files into excell 2003 from path Closed

    Hello, I would like to import a long list of photos into a spread sheet using excell 2003 to make a product catalog. in column F I have the path t...

    paulhh | Latest reply: rizvisa1 Mar 19, 2013
    1 reply
  • Help combining worksheets in excel 2007 Solved/Closed

    We use excel 2007 to store information about our products and have a different worksheet for each range. Is there any way of combining all these wo...

    Pauliolio | Latest reply: rizvisa1 Mar 19, 2013
    12 replies
  • Conditional formatting Solved/Closed

    Hello, I need a help on Conditional formatting: I have a data in A2:E5 (Sheet 1), and in Sheet 2 i have reference data in Column A. i need to...

    matheshphy | Latest reply: Matheswaran Mar 19, 2013
    2 replies
  • use of formula Closed

    Hello, l try to add up figures with vat but l coudn't get de total thanks. Configuration: Windows 7 / Firefox 19.0

    AYISATU | Latest reply: Zohaib R Mar 18, 2013
    1 reply
  • Inventory Solved/Closed

    Hello, Can you pls help me with the following: I have Inventory Workbook, and Invoices. Every time I open new Invoice and entering Quantities of...

    Ashley | Latest reply: Ashley Mar 17, 2013
    6 replies
  • import photos from path Closed

    I want to import a long list of photos into a spread sheet using excell 2003 to make a product catalog. in column F I have the path to the photo as:...

    paulhh | Latest reply: paulhh Mar 17, 2013
    0 replies
  • VBA how to create new worksheet and move value Solved/Closed

    Hello there, I am zero in vba, can anyone please assist me what code to be used given following conditon Given,(I have data converted from csv t...

    yogi_himalayan | Latest reply: rizvisa1 Mar 17, 2013
    5 replies
  • have to update data from one sheet to other sheet automatically Closed

    Hello, I have four excel sheets , in which some field names are similar. When i update a common field in one sheet i want other sheets to update ...

    azmeera | Latest reply: rizvisa1 Mar 16, 2013
    3 replies
  • Format Range of Cells Based Off Another Range of Cells Closed

    Hello, I have a set of values in column $A. I want to format cells in columns $B:$Z to be red if any of their values are equal to any values in co...

    JC | Latest reply: rizvisa1 Mar 16, 2013
    3 replies
  • Excel, If / Then or is there a better way? Closed

    Hello, I have a spreadsheet that lists each kid in my class. I have entered the answer they gave for each and every question on a 40 quesiton test....

    WMCAROLI | Latest reply: rizvisa1 Mar 16, 2013
    2 replies
  • Password Macro help Closed

    Hello, I have a code that unlocks sheets I need to use that are password protected but I have other code I used to combine the worksheets into 1 w...

    tinamc | Latest reply: rizvisa1 Mar 16, 2013
    1 reply
  • VB how execute code for each file open & open multiple files Closed

    Hello, The top half is code for opening my file. I tried opening multiple which seems to open but not execute the code I want ran for each file. I'm...

    weenie | Latest reply: rizvisa1 Mar 15, 2013
    5 replies
  • Facing difficulties in implementing CHARTS Closed

    I have file1, file2, file3 and I want to have a chart with each's G column from 2 to final and each's I column from 2 to final. G in X axes and I i...

    helensyk | Latest reply: rizvisa1 Mar 15, 2013
    1 reply
  • Excel macro Closed

    Hello, I need a help in using the excel macro I have designed the Userform for searching the particular value from the excel.By typing the valu...

    gayu | Latest reply: rizvisa1 Mar 15, 2013
    2 replies
  • Compare two columns in different sheet and retrive corrspo value Closed

    Hello, How to compare two columns in one sheet with that of two columns in other sheet and retrive the corresponding Key value of the third column...

    gbssraju | Latest reply: Zohaib R Mar 14, 2013
    1 reply
  • Excel Macro; Adding Password Solved/Closed

    Hello, Hope you anyone can help me with this... I need to create a macro that unlocks a password-protected sheet with password "password", do so...

    zeromaim | Latest reply: Pujdo Mar 13, 2013
    13 replies
  • Summing up data from groups & pasting it another column Solved/Closed

    Hello there, I need to write a macro for the following example: A 2 A 3 A 3 B 4 B 1 B 4 C 7 D 3 D 8 Etc. Basicallly i ne...

    V1R4L | Latest reply: rizvisa1 Mar 13, 2013
    3 replies
  • Special sum of a column Solved/Closed

    Hello, In have some columns with plenty of data. And I need to make a column which will have ... D2=C2 D3=C2+C3 D4=C2+C3+C4 ....................

    helensyk | Latest reply: rizvisa1 Mar 13, 2013
    3 replies
  • number to word Closed

    Hello, i want to covert number in to word like 1000(one thousands) 100 (one hundred) Plz help me to convert number to word in this format Conf...

    santanu | Latest reply: rizvisa1 Mar 13, 2013
    1 reply
  • Comparing data in multiple excel worksheets Closed

    Hello, For work, I was given an excel document with a different worksheet for each month in 2012. Clients can come to our food pantry one time in ...

    anglcol | Latest reply: Zohaib R Mar 12, 2013
    1 reply