Office Software Forum - solved topics

Ask a question
Results 1251 - 1300 of about 2,660
  • Solved
  • combining two separate macros into one Solved/Closed

    Hello, I currently am using these two separate macros independently but would like to combine them into one with the archive one being first. I'm...

    kat | Excel | Latest reply: Devarajan Jul 23, 2013
    8 replies
  • Date formatting in dd/mm/yyyy Solved/Closed

    Hello, I have got dates typed in the format following 01.08.98 and I want to change it to 01/08/1998 format. I tried applying the format we have i...

  • Macro to Search/Replace Text from another Column Solved/Closed

    Hello, I didn't realize I was being rude on my previous post, that wasn't my intention. I tend to have a "too the point" personality sometimes, and...

    mylove0mylife | Excel | Latest reply: mylove0mylife Jul 18, 2013
    2 replies
  • Won't save passwords / usernames Solved/Closed

    Hello, Computer won't save passwords / usernames, even when I ask it to and I have went into tools and everything was set as suppose to.

    chevyup7 | Word | Latest reply: arendtrepair Jul 18, 2013
    39 replies
  • urgent ansin excel Solved/Closed

    a table caring 4 rows, first row is Name, second is address, 3rd row is date, and forth row is house name. how i arrange this in excel in date wise...

    archana. | Excel | Latest reply: venkat1926 Jul 18, 2013
    1 reply
  • Popup reminder based on date and additional celll values Solved/Closed

    Hi, I am new to this site and have seen a lot of great information and helpful tips here. I have been trying to figure this out for a very long tim...

    MikeTis | Excel | Latest reply: MikeTis Jul 15, 2013
    10 replies
  • Word Markup Area Solved/Closed

    Hello, How do I turn off markup area in Word? Thanks!

    GrnSpdr | Word | Latest reply: car234 Jul 10, 2013
    5 replies
  • Hide rows with zero value in Multiple sheets Solved/Closed

    Please help me in making a macro in the Excelsheet that: I can hide the entire rows if a cell value or (range of values) has a zero value in multiple...

    issa abu Ham... | Excel | Latest reply: Excellent answer Jul 10, 2013
    2 replies
  • Conditional formating Solved/Closed

    I have a spreadsheet with Excel 2013 that has text drop down lists. I want to use conditional formatting to highlight with a different cell color, dep...

    jgmb | Excel | Latest reply: jgmb Jul 9, 2013
    10 replies
  • Convert a date field in excel to day of week Solved/Closed

    Hello, I know how to format a cell with a date in it so that it shows the day of the week. WHat I am trying to do is sort on the day of the week so...

    C | Excel | Latest reply: Indian Jul 7, 2013
    7 replies
  • some help needed about IF function with dates Solved/Closed

    Hello, i m making a sheet with this function =IF(H1

    rizwan32 | Excel | Latest reply: sgmpatnaik Jul 5, 2013
    3 replies
  • creating pdf from selected cell range Solved/Closed

    Dear all, greetings. firstly , I would like to thank those who have helped me to get below code (to create pdf file for selected cell range) whic...

    cvsuryam | Excel | Latest reply: sgmpatnaik Jul 4, 2013
    1 reply
  • how to compare two coloumns in excel Solved/Closed


    vijay | Excel | Latest reply: jhanvi Jul 4, 2013
    11 replies
  • microsoft office Solved/Closed

    good day ! i would like to ask if how can i activate my microsoft office even though i dont have any activation code.. thank you God bless

    dios vicente | Office Software | Latest reply: dios vicente Jun 27, 2013
    2 replies
  • Trying to write a code to insert a blank row above a cell value Solved/Closed

    I am trying to write a code that will auto insert a blank row above a certain cell value ie: existing: Column G 5 10 20 22 999 2 22 55...

    Kwanni | Excel | Latest reply: Ambucias Jun 26, 2013
    3 replies
  • request for a formula marks of my students Solved/Closed

    Hello, sir, I am a teacher. I entered marks of my students in a column in excel-2007 work sheet. I have to prepare grades from the marks. Marks from ...

  • I cant open my exel .slxs files Solved/Closed

    Hello, am not able to open my exel files(office 2007) which are in .slxs formet. when am trying to open that file windows is showing this message: ...

    srf91 | Excel | Latest reply: srf91 Jun 22, 2013
    6 replies
  • Enter Time by clicking on a cell Solved/Closed

    Hello, I need help setting a code in Excel. I am new to VBA but have used Excel for awhile. I would like to set Columns D & E up for time. I want...

    jkdurkin | Excel | Latest reply: totzkie10 Jun 21, 2013
    7 replies
  • Conditionally insert a duplicate row Solved/Closed

    I have a table with hundreds of rows but here's a basic example: __a___b_____c____ 1 Color Dates Completed (headings) 2 red Date1 No 3 red Dat...

    acohen12 | Excel | Latest reply: TrowaD Jun 17, 2013
    7 replies
  • 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 | Excel | 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 | Excel | Latest reply: TrowaD Jun 13, 2013
    3 replies
  • why i cant open my pdf files even though i'm having adobe reader Solved/Closed

    hai. i'm having new version of adobe reader, when I try to open my pdf files by double clinking on it it opens in word. when I try to select'open-wit...

    reshmagh | PDF | Latest reply: reshma Jun 11, 2013
    12 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 | 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...

    Anonymous User | 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

    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...


    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
  • 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