Office Software Forum - solved topics

Ask a question
Results 851 - 900 of about 2,640
  • Solved
  • IF formula for a range almost works, except with blank cells Solved/Closed

    Apologies if the title is too vague. I will if necessary rewrite it to comply with forum rules. I have posted this same question here: https://www....

    eddiecruz | Excel | Latest reply: eddiecruz Jun 19, 2015
    3 replies
  • Offline address book help for exchange 2007. Solved/Closed

    Installed new copy of Exchange 2007. Keep getting following message: Offline address book definition is missing. Need help with this issue. Thanks.

    herbertfranc | Office Software | Latest reply: williamgriif Jun 15, 2015
    2 replies
  • Cannot browse - ftp ok, email ok, ping ok Solved/Closed

    Hello, I have been following the thread from people with similar problems but mine is not fixed. This all happened yesterday when AVG falsely ident...

    justabouthan... | Excel | Latest reply: 2NinerRomeo Jun 14, 2015
    24 replies
  • Date format Solved/Closed

    Hello, i have a column in format like 14-02-14 and i want to change it like14-02-2014

    Murshid | Excel | Latest reply: Mazzaropi Jun 14, 2015
    1 reply
  • if condition formula required Solved/Closed

    Hello, Thank for the earlier reply. Please help in correcting the formula given below. condition is if a column is AB2>=1 it should reduce no. ...

    Raghuram | Excel | Latest reply: Raghuram Jun 14, 2015
    2 replies
  • Excel Consolidation Tab Solved/Closed

    Hi all, I am wondering if it is possible to exclude one spreadsheet from being pulled into the master tab. I could name it Data. Can you advice? ...

    nnavarro | Excel | Latest reply: nnavarro Jun 11, 2015
    4 replies
  • If cell A1 has text then cell B2 has today's Date Solved/Closed

    Hello, I'm trying to find a formula that writes, If Cell A1 has text or any value, then B2 should show today's date and time. Can someone help m...

    Sasha | Excel | Latest reply: ac3mark Jun 10, 2015
    1 reply
  • Excel - Repeat rows a specified number of times Solved/Closed

    Hello, I'm aware of the post here But I wo...

    Riteon | Excel | Latest reply: Riteon Jun 9, 2015
    1 reply
  • how to repeat rows by x number of times Solved/Closed

    Hi Does anybody know how I can repeat rows in a spreadsheet (or into another spreadsheet) by n number of times specified in the cell in that row ...

    stressedout | Excel | Latest reply: Riteon Jun 9, 2015
    7 replies
  • How to Repair Large Outlook 2007 PST on Windows 7 Solved/Closed

    Hello, User running Windows 7, with Outlook 2007, 20 GB PST. User has two email account, 1 may be an IMAP, 1 may be POP, or both can be POP (I'l...

    coxsilvester | Outlook | Latest reply: paulmay247 Jun 7, 2015
    2 replies

    Hello, Good day!! For the Excel rounding function normally is 4 down 5 up is it possible that rounding the digit as below request? 115.21...

    Winndixie | Excel | Latest reply: Winndixie Jun 5, 2015
    2 replies
  • VBA to refresh all pivot tables Solved/Closed

    Hello, One of my worksheets has about 40 pivot tables. I know that there is a pivot table option to "refresh tables when opening file". But my raw ...

    Fwong | Excel | Latest reply: Fwong Jun 5, 2015
    1 reply
  • Macro to add/remove rows based on highest # in group of cells Solved/Closed

    I am looking for a macro that will look at a predefined group of cells (say A1-A5) and create as many rows based off the highest one on another sheet....

    Joermccartney | Excel | Latest reply: TrowaD Jun 4, 2015
    1 reply
  • Copy specific cells to separate worksheets upon 2 conditions Solved/Closed

    Hello everyone, vcoolio has kindly written me a script to copy and paste specific cells from Sheet1 to Sheet2 if ONE condition is met (ie "Yes" is...

    Fwong | Excel | Latest reply: vcoolio Jun 1, 2015
    3 replies
  • adobe reader error message at opening .pdf file Solved/Closed

    hello, I open my big .pdf file and Adobe Reader says: "The File is Corrupted or damaged hence cannot be opened". How to overcome such error mess...

    brinkermats | PDF | Latest reply: caseysutton May 29, 2015
    2 replies
  • PDF file not open Solved/Closed

    i am getting the following error message when I open the pdffile "Adobe Reader could not open 'xxxx.pdf' because it is either not a supported file ...

    ceciliorauseo | PDF | Latest reply: conorrose May 29, 2015
    2 replies
  • Outlook archive file not opening Solved/Closed

    I have Outlook 2007 which has a 4Gb archive pst file stored on a file server, there are other archive pst's that I can open but this one wont,...

    gittosecondo | Outlook | Latest reply: jaycehead May 29, 2015
    2 replies
  • problem with macro Solved/Closed

    Hello, I have problem with macro. if I delet on of the samples data, the 4 parameters value (a,b,c ,d)will change while is 4 parameters based on the...

    Sonya | Excel | Latest reply: Sonya May 28, 2015
    0 replies
  • Copy certain cells when an option is selected Solved/Closed

    Hello, Can anyone help me with a script to: Copy: cell A, Worksheet One to cell B, Worksheet Two; cell G, Worksheet One to cell D, Worksheet Tw...

    Fwong | Excel | Latest reply: vcoolio May 27, 2015
    14 replies
  • Arrow key now working. Solved/Closed

    Hi, When i use the arrow keys using excel, the columns & Rows are being highlighted. How to unlock this? Can you help me to solve this?

    belle07 | Excel | Latest reply: belle07 May 26, 2015
    2 replies
  • How I Can Open Damaged Pdf Files? Solved/Closed

    I have an issue with trying to open old PDF files in Adobe Reader 9 Standard. The files were created in 2000 and they need to be retrieved to be put ...

    ChanoDelahoz | PDF | Latest reply: HaSw8 May 25, 2015
    2 replies
  • date format Solved/Closed

    Hello, I want to write date into following format like (25/05/2015) into 25 days 05 months 2015 year. Is it possible??? Thanks Configuration...

    khushi | Excel | Latest reply: Mazzaropi May 23, 2015
    2 replies
  • Help to insert a date using a macro in excel Solved/Closed

    Hello, I have a spread sheet with four tabs. I have written a macro to copy the tabs and rename them but I need to be able change the date which u...

    Nina | Excel | Latest reply: Matt May 22, 2015
    3 replies
  • outlook 2007 corrupted .pst Solved/Closed

    My Outlook 2007 cant open .pst file. IT appears file was corrupted. I ran scanpst, but it couldnt solve the issue. Does anyone know third party sof...

    ethanlyons | Outlook | Latest reply: MalcolmHop May 20, 2015
    2 replies
  • How to Hide and Unhide tabs according to cell criteria. Solved/Closed

    Hello, I have an Invoice that has a Rent To Own Sheet and also an Order Form attached to it. On my the Order Form tab I have a data validation...

    Simpleminded... | Excel | Latest reply: vcoolio May 20, 2015
    1 reply
  • Excel VBA Format a Range Borders to Crossed diagonal lines Solved/Closed

    Hello, please help me to format a range of cells like if in a range a1:c10 if any cell eg: c1 contains a value c then format diagonal lines wit...

    mathewmunna | Excel | Latest reply: MaxStart May 17, 2015
    4 replies
  • Outlook 2007 data file repeatedly corrupt Solved/Closed

    Looking for possible causes for corruption. Window 7 32 bit all updates, Office 2007 SP2 and all updates, POP3 mail account, 5.68 GB pst file, ...

    danielcouto | Outlook | Latest reply: cyrilcrozier May 12, 2015
    1 reply
  • Conditional Formatting: 3 range of numbers Solved/Closed

    Hello, would like to seek advice from some of the experts here. I want to do conditional formatting from column O6-O21. If percentage is a...

    LCC | Excel | Latest reply: LCC May 10, 2015
    2 replies
  • Reformatting a Date in Excel Solved/Closed

    Hello, I could really use your help with Excel. How can I change a date formatted like this...03/12/ just reflect the month and year...0...

    Bert | Excel | Latest reply: Bert May 8, 2015
    4 replies
  • get a percentage in microsoft excel Solved/Closed

    Hello, I am trying to get 10% of a number in another cell. rather than doing it in my head, I was hoping someone would know the formula. If you do,...

    theocupent | Excel | Latest reply: kb May 7, 2015
    3 replies
  • How to use name range..Please help to solve this issue.. Solved/Closed

    Hello, i have a excel work book which has few name ranges eg namerange1, namerange2, namerange3.. how i can display the resultant like if column e...

    mathewmunna | Excel | Latest reply: Mathewmunna May 7, 2015
    4 replies
  • Exam layout help Solved/Closed

    Hello, I want to display a classroom layout on sheet 2 using a list of names from sheet 1 I'm sure it's possible, I just don't know where to sta...

    Dibble | Excel | Latest reply: addseo1115 May 1, 2015
    8 replies
  • Conditional formatting cell if every cell contains "YES" Solved/Closed

    Hello, I want to A2 (surname) and B2 (forename) to turn green if every cell in range C1:F1 equals "yes". At the moment it is highlighting A2 & B2 i...

    LizzyDashwood | Excel | Latest reply: LizzyDashwood May 1, 2015
    2 replies
  • Compare 2 Sheets -> Summary differences Solved/Closed

    For an ongoing school project values of test subjects are changing over time. I would like to create a quick overview of these changes. Examples ...

    SidK | Excel | Latest reply: SidK Apr 30, 2015
    4 replies
  • Conditional Formatting for a particular column Solved/Closed

    Hello, I need to perform conditional formatting on a particular column, which should display the numbers entered into it, in 3 decimal format. ...

    Harish | Excel | Latest reply: Harish51290 Apr 30, 2015
    11 replies
  • copy & Paste based on specific condition Solved/Closed

    Please provide me the macro coding for the below scenario. I have four columns in my sheet 1 say Date,Name,Reference and Rate. When I am entering the...

  • How to search for a value in a range if found run a procedure. Solved/Closed

    Hello, I am trying to get my spread sheet to run a Macro I have that is working nicely (that copies the row and pastes it to another sheet in the ...

    Tiny | Excel | Latest reply: Tiny Apr 29, 2015
    4 replies
  • finding a date (N30) in a date range B5:B30 and returning A3text Solved/Closed

    Hello, Thank you in advance for helping me... I really appreciate it. I believe I need an =IF formula.... I have a column with different dates ...

    Kelley | Excel | Latest reply: MaxStart Apr 29, 2015
    3 replies
  • Auto. copy a row of data onto another sheet using conditions Solved/Closed

    Hello, I am new to VBA and I have two spreadsheets both in the same workbook. One sheet is full off information the other is a printable form t...

    DON'T KNOW | Excel | Latest reply: Don't Know Apr 28, 2015
    8 replies
  • Macro to Search for a word and put a code on the cell next to it Solved/Closed

    Hello, I'd like to scan a column for a certain word ("TOTAL LINE") and put a code (e.g "a") on the cell next to it each time it finds it.In case tha...

    A.E | Excel | Latest reply: A.E Apr 28, 2015
    2 replies
  • Can't open scanned document when broken up into 2 PDF's Solved/Closed

    When I scan a large color document on the color printer, the PDFs that are sent to me via Email can not be opened. The error message indicates it is n...

    shujaaishak | PDF | Latest reply: thierryhauet Apr 27, 2015
    1 reply
  • repair outlook express dbx file Solved/Closed

    has a sent items.dbx file which is about 400 over MB.. when open it, there is only a few emails with the file size quite small. any recommended free s...

    altairbishara | Outlook | Latest reply: ruudromein Apr 26, 2015
    2 replies
  • Macro for blanks Solved/Closed

    Hello, Would appreciate help! I have a spreadsheet which I run daily. The number of rows can change each time I run it (ie one day I have 5 rows; t...

    Connie | Excel | Latest reply: vcoolio Apr 21, 2015
    3 replies
  • sum if Solved/Closed

    Hello, Pls help me find the formula for below situation I am trying to sum up 4 when a cell in the Column A contains End with XX7. Otherwise it...

    senthil | Excel | Latest reply: senthil Apr 21, 2015
    0 replies
  • Date of birth in words Solved

    Hello, How can I enter date of birth in words in Excel?

    pinckroje | Excel | Latest reply: TrowaD Apr 20, 2015
    1 reply
  • recover corrupted outlook express folders Solved/Closed

    I accidentaly deleted some folders in my Inbox Folder. My problem is now, how do I get back the .dbx files without losing any important information? P...

    LambCastillo | Outlook | Latest reply: balighawad Apr 14, 2015
    1 reply
  • transfer data from one sheet to another automatically Solved/Closed

    Hello, I would like to populate data on a spreadsheet based on data obtained from another. Is this possible? If so, how can I do this? Example: S...

    myrna1310 | Excel | Latest reply: vcoolio Apr 14, 2015
    19 replies
  • What cell is my data coming from? Solved/Closed

    Oh dear - back again ... :^( After you guys help again with VBA. I'm never going to volunteer to try script-writing again! (at least not without...

    BrianGreen | Excel | Latest reply: BrianGreen Apr 8, 2015
    4 replies
  • Transferring information from previous spreadsheet Solved/Closed

    Hi everyone, I'm a junior doctor from Australia, and I'm trying to use excel to make my ward management a more efficient process! Everyday we get ...

    JoDWil | Excel | Latest reply: skreechy Apr 7, 2015
    17 replies
  • How do I resolve file corruption errors in powerpoint 2010? Solved/Closed

    Dear All, One of my colleagues is getting an error frequently(attached) in powerpoint 2010 and as a result he keeps losing many slides that he prep...

    manuelnoguera | PowerPoint | Latest reply: montesquinto Apr 6, 2015
    3 replies