Excel Forum - solved topics

Ask a question
Results 1051 - 1100 of about 1,710
  • Solved
  • Macro Help Copy Specific Text from One cell into another Solved/Closed

    Here is the scenario: I have a large excel spreadsheet and I have a column in which I only need the last ten characters of each line copied or move...

    steve22522 | Latest reply: rizvisa1 Jun 16, 2013
    5 replies
  • EXCEL - Create a bulleted list in a single cell from a list Solved/Closed

    Hello, I'd greatly appreciate some help with this: I'm trying to get a list of data in cell "D5" only from cells "A1:A10" that do have informat...

    morocog | Latest reply: TrowaD Jun 13, 2013
    3 replies
  • Adding 1 to an existing number if criteria is matched? Solved/Closed

    In column A I have a set of initials and in column C I want a number that corresponds to the number of times the initials have appeared... Column ...

    rshelton22 | Latest reply: ac3mark Jun 8, 2013
    5 replies
  • Find the sum of data that has multiple conditions in Excel Solved/Closed

    Hello, I have a large data table, and I want to find the sum for certain data that fits a few criteria. Here is a simplified example: __a_____b__...

    acohen12 | Latest reply: Kevin@Radstock Jun 7, 2013
    1 reply
  • Error when creating mailmessage Solved/Closed

    Hello, Using Excel and Outlook 2007 I want to create an emailmessage with a Macro. But I am running into an error I can not find any "comprehensi...

    Pluggie | Latest reply: rizvisa1 Jun 1, 2013
    1 reply
  • From Excel, Open a word document and goto a page question Solved/Closed

    Hello, I have an Excel document which I have inserted some VBA code to open a word document; Set WordApp = CreateObject("word.Application") Wo...

    scooble | Latest reply: rizvisa1 Jun 1, 2013
    9 replies
  • MAX value in one coulmn based upon another column Solved/Closed

    Batch Price Column C 00015 2.75 00015 2.9995 00016 1.89 00017 0.56116 00018 0.1421 00018 0.11808 00018 0.1605 00018 0.12575 00018 0...

    Piggy70 | Latest reply: Piggy70 May 30, 2013
    2 replies
  • Highlighti Row/ colour fill through VB Solved/Closed

    Hello, I am after a code which enables me to highlight/ colour code a row on basis of expiry date and update every time I open that exel file. f...

    DevRatan | Latest reply: TrowaD May 28, 2013
    3 replies
  • Comparing Data in Excel Solved/Closed

    Hello, I need to compare data in one column to that in multiple other columns to find missing data. Column "A" is static data, and can be entered ...

    sointly | Latest reply: TrowaD May 27, 2013
    1 reply
  • Re: Make a macro run when data entered in a cell -multiple event Solved/Closed

    Hello, I have three macros in the module and I want each macro to runs when the user changes the values in the cell (Cell F2) to "first", "second", ...

    tosinsog | Latest reply: TrowaD May 27, 2013
    1 reply
  • conditional format Solved/Closed

    Dear reader, I was wondering if there is a possibility to specify the number of charakters in a conditional format in Excel. Example. NL08569638 ...

    boon1d | Latest reply: boon1d May 27, 2013
    2 replies
  • convertion Number into word Solved/Closed

    Sir, How can convert Number into word in excel sheet. suppose there is 253900 in cell B2 in excel sheet. How can I convert this number as Two lakh ...

    Mathaiah | Latest reply: TrowaD May 21, 2013
    1 reply
  • 40 % add formula in excel cell Solved/Closed

    i want to increse 40% amount in my excel sheet and I have total quantity 90 can anyone like to tell me that how will I entre the 40% in excel cell tha...

    bvcds | Latest reply: TrowaD May 21, 2013
    1 reply

    Hi I have an excel sheet with blank rows every odd line (i.e rows 2,4,6,8...700 are empty). I have to paste a row of data (the same all the way th...

    MadLooni | Latest reply: TrowaD May 16, 2013
    1 reply
  • macro Solved/Closed

    Sub Macro1() ' ' Macro1 Macro ' Macro recorded 13/05/2013 by dhale ' ' Keyboard Shortcut: Ctrl+a ' Application.Goto Reference:="onecell" ...

    Phillip Kabala | Latest reply: TrowaD May 16, 2013
    6 replies
  • Greater than/Less than between 2 Dates Solved/Closed

    i am trying to to populate a spreadsheet that if the date is less than 01/01/2013 then populate the cell with $500.00, if the cell is equal to or grea...

    Shaynajr | Latest reply: TrowaD May 13, 2013
    3 replies
  • Macro to highlight cells. Solved/Closed

    I am very new to VBA and have spent countless hours looking for help on the web. I have a worksheet with 100,000 rows(locations) and 34 columns(Cha...

    steveo0707 | Latest reply: steveo0707 May 13, 2013
    2 replies

    Hi all, I need a set of 3 to 4 formulas which would show a monthly grow of accrued interest on each of the new amounts eg: formula 1:Month 1- 1...

    svdwest | Latest reply: svdwest May 8, 2013
    5 replies
  • creating an If function using dates Solved/Closed

    Hello I am trying to formulate an if function, should the date in the cell be less than six months old from today's date the font is red, should the ...

    dawnski333 | Latest reply: Kevin@Radstock May 3, 2013
    4 replies
  • Unable to copy selected cells after apply autofilter function Solved/Closed

    Dear All, I am using excel 2007. In my dataset, I have following: Column A - Set of locations and Column B: Number of times location appears. When...

    venus1060 | Latest reply: stonehendriks Apr 30, 2013
    4 replies
  • Num Convert to text in Excel 2007 Solved/Closed

    R/Sir, As per your instruction i have done how to num convert into words.But i have face a problem when i have writeen above 99999, than num co...

    Rupendra Singh | Latest reply: sgmpatnaik Apr 30, 2013
    1 reply
  • VBA Code 2 import many cells not in range from many workbooks Solved/Closed

    Hello, I have used some of your codes for importing data ranges from several workbooks. I am using Excel 2010. I have around 2,000 workbooks ...

    samirelsabagh | Latest reply: samirelsabagh Apr 21, 2013
    4 replies
  • Formula Help Solved/Closed

    Hello, I think this is a simple question just not for me :) I have a simple business spreadsheet showing total project cost in Column (C.) C, T...

    sjefferys | Latest reply: Zohaib R Apr 18, 2013
    3 replies
  • Formula not working Solved/Closed

    Hello, Q16 to Q20 cells contains values from 0 to 10 (it came from LOOKUP Function). I need to get a result in D24 from the cells Q16 to Q20 as ,"...

    jinoob | Latest reply: Zohaib R Apr 18, 2013
    13 replies
  • import from multiple workbook to single SHEET Solved/Closed

    Hi, Thank for all your wonderfull help all these days, to cut short, I am looking for a VBAcode, which can import data from multiple Workbook file...

    Nitin | Latest reply: samirelsabagh Apr 17, 2013
    5 replies
  • Comparing two columns of names in Excel Solved/Closed

    Hello, I have one excel sheet. column A has a list of names formated as follows: Last name, First name Column B has a much longer list o nam...

    STEMPEKA | Latest reply: JeffS79 Apr 16, 2013
    8 replies
  • Spreadsheet data Solved/Closed

    Hi everybody. I am trying to develop a large data input spreadsheet which will have circa 20 operators data input on a daily basis. (approx 150 ent...

    ankharm | Latest reply: TrowaD Apr 16, 2013
    9 replies
  • Attendance sheet Solved/Closed

    Hi, i want to make attendance sheet in Microsoft Excel 2007 with alphabetical words like P for Present, A for Absent, L for Late, H for Holiday wit...

    sanjay001 | Latest reply: rizvisa1 Apr 14, 2013
    1 reply
  • excel vba to open other screen Solved/Closed

    Hello, We are working on dual screens. I am writing a macro program in VBA. I need to open an existing excel file/workbook in a new excel application...

    Tibor | Latest reply: holycow Apr 13, 2013
    5 replies
  • How do I get excel file ( no formula) from another one ( with fo Solved/Closed

    Hello, I have a big excel file with lots of formula and link. now can I export these data only( no link or formula) to another excel file? Thank yo...

    ziyun | Latest reply: Zohaib R Apr 12, 2013
    18 replies
  • How to check two fields in excel and act by that? Solved/Closed

    Hello, Can anybody help? I would need very simple macro to check two cells. A1 will be name A2 A3 will be second namew A4 Does A2=A4 ...

    akaldojad | Latest reply: akaldojad Apr 12, 2013
    3 replies
  • Conditional formatting Solved/Closed

    I am trying to maintain three lines of accounting on one spreadsheet. Basically, I have an order amount (C3) . I want to take that total from one of...

    CrazieB317 | Latest reply: TrowaD Apr 8, 2013
    3 replies
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • Need help with Percentage Please Solved/Closed

    Hello, I am new to excel and I am not very good at it so any help would be greatly appreciated. I know anyone out there is helping for no reason o...

    TarExcel | Latest reply: rizvisa1 Mar 9, 2013
    5 replies
  • Populate data in Excel according with n Solved/Closed

    Hello all, My intention is populate an Excel sheet with a variable number of rows according with a number inserted on a fixed column. co...

    ruidelgadoalves | Latest reply: TrowaD Mar 7, 2013
    6 replies