Office Software Forum - solved topics

Ask a question
Search
Close
Results 1251 - 1300 of about 2,640
  • Solved
  • 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | Latest reply: boon1d May 27, 2013
    2 replies
  • Look at column and match and add this text te Solved/Closed

    Hello, I am working with Excel 2003. I need the formula to look in Column 1 and look at all these names. and compares the name if it is Sally the ad...

  • 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 | Excel | 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 | Excel | Latest reply: TrowaD May 21, 2013
    1 reply
  • INSERT ROW DATA INTO EVERY SECOND ROW Solved/Closed

    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 | Excel | 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 | Excel | Latest reply: TrowaD May 16, 2013
    6 replies
  • Incoming and outgoing mail servers Solved/Closed

    Hello, I am having multiple email accounts. I like to configure all my email accounts in OUTLOOK EXPRESS. I am not able to do the same in OU...

    RAMAN | Office Software | Latest reply: nirmalkumar May 16, 2013
    32 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 | Excel | 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 | Excel | Latest reply: steveo0707 May 13, 2013
    2 replies
  • Date change with column paste Solved/Closed

    Hello, Whenever I try to paste the dates and times from one spreadsheet to another, the dates changes from 2008 to 2004. Why won't the dates just...

  • HELP ME WITH FORMULAS PLEASE? Solved/Closed

    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 | Excel | 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 | Excel | Latest reply: Kevin@Radstock May 3, 2013
    4 replies
  • Outlook 2007 using Windows 7 Home Premium OS ... Solved/Closed

    Hello, I've not been able to SEND e-mails, only receive them. Outlook 2007 continues to try to send an item from the 'outbox' to no avail; then iss...

    rpablito | Outlook | Latest reply: mariapeter May 1, 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 | Excel | 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 | Excel | Latest reply: sgmpatnaik Apr 30, 2013
    1 reply
  • Unable to Reply to Emails Solved/Closed

    Can someone advise me how to conquer this sudden difficulty? Emails arrive, I can read them, but when I click "Reply" nothing happens. Why? Than...

    Joyful1 | Outlook | Latest reply: Burnas Apr 23, 2013
    1 reply
  • How to conver Image to PDF File? Solved/Closed

    Hello, I want to send a File to my friend which in format of Images but Images are so large and my friend want it only the format of PDF File as h...

    zeterjons | PDF | Latest reply: arronlee Apr 21, 2013
    6 replies
  • 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | Latest reply: akaldojad Apr 12, 2013
    3 replies
  • How to calculate positions(1st,2nd,3rd...) in Excel Solved

    Hello, hi sir/madam...i am doing some work with the students result in excel...but I faced a problem..it is simple but I havn't got dat in my mind......

  • 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 | Excel | 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 | Excel | Latest reply: bite_tony Apr 5, 2013
    1 reply
  • Microsoft Project Solved/Closed

    Is anyone using MS project? is there a tutorial for this software somewhere on line?

    project6 | Office Software | Latest reply: project6 Mar 31, 2013
    2 replies
  • 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 | Excel | Latest reply: DG83 Mar 30, 2013
    8 replies
  • animated ppt templates Solved/Closed

    Hello, can you tel me the website of animated ppt templates???plzzz Configuration: Windows XP / Opera 9.80

    Royal Diamond | PowerPoint | Latest reply: Royal Diamond Mar 26, 2013
    4 replies
  • changes on a PDF document Solved/Closed

    Good morning Please can you advise how to make changes on a PDF document that was send to you via email need to change some text

    theresa1400 | PDF | Latest reply: rizvisa1 Mar 25, 2013
    2 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | Latest reply: rizvisa1 Mar 19, 2013
    12 replies