Office Software Forum - solved topics

Ask a question
Search
Close
Results 1301 - 1350 of about 2,640
  • Solved
  • 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | Latest reply: rizvisa1 Mar 13, 2013
    3 replies
  • increased size of an excel file Solved/Closed

    hi guys, I have come across an interesting issue. I redid some tables in an excel file and when done with it I see that the size of the file is at...

  • 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 | Excel | Latest reply: rizvisa1 Mar 9, 2013
    5 replies
  • high and lower case text in the "if" functions Solved/Closed

    Hello, I am working on a basketball spreadsheet. I am keep track of the home teams straight up(SU) wins. Home teams are capitalized(higher case), ...

    Joshte | Open Office | Latest reply: Joshte Mar 8, 2013
    2 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 | Excel | Latest reply: TrowaD Mar 7, 2013
    6 replies
  • Conditional formatting using dates in different cells Solved/Closed

    Hello, I need help with a problem that is driving me insane. I have column A, B, and C A is date started B is date finished C is days it to...

    rbarletta | Excel | Latest reply: rbarletta Mar 6, 2013
    2 replies
  • Problem for creating MS word on tablet Solved/Closed

    Hello, I find very difficult downloading MS word, Excel and VZO video chat.

    tinglee thaica | Word | Latest reply: jamesfly Mar 1, 2013
    1 reply
  • snding sms from excel sheet Solved/Closed

    Hello, i need to send text message from excel sheet to mobile number. is there any method to send sms. please help me to give method. thanks ...

    ramesh1974 | Excel | Latest reply: ramesh1974 Feb 28, 2013
    4 replies
  • Dropdown lists in excel 2007 Solved/Closed

    Hello, I want to create dropdown lists in excel, it should work as follow:In cell2,1 must be a drop down list with 4 names (e.g.Mill,Comp,Loads,Blend...

    Gouws | Excel | Latest reply: rizvisa1 Feb 27, 2013
    33 replies
  • What is the Most Appropropriate Way to Recover PST File Solved/Closed

    Hello i m using MS Outlook my PST file was oversized which got corrupted after subsequent retrieval. Tell me what to use?? Inbox PST repair tool...

    outlookuser | Outlook | Latest reply: ronwiselly Feb 26, 2013
    4 replies
  • Ms exhange Solved/Closed

    Hello, I'm using ms exchange 2003 and experiencing mail bouncing with this error message 550 5.7.1 when I Send messages with my outlook the mails ...

    Nattygray | Outlook | Latest reply: Nattygray Feb 25, 2013
    0 replies
  • converting date to year and month text Solved/Closed

    Hello, I have a cell date entered as 8-Nov. Excel reads this date as 11/8/2010. The cell entry actually means Nov, 2008. I need to change that ...

  • Using Vlookup to return insted of 00/01/1900 Solved/Closed

    Hello, I am using a Vlookup to return values within a sheet using cell A2 as my reference some of the data that I am returning via the lookup are ...

    Tom9o | Excel | Latest reply: tom9o Feb 24, 2013
    2 replies
  • Formula for Between to Dates Solved/Closed

    Hello, Hi, I am looking for a date formula that will tell me if a date in a cell is between to dates In column "A" I have a list of dates and in c...

    Tom9o | Excel | Latest reply: Tom9o Feb 23, 2013
    2 replies
  • Stop #N/A appearing after a vlookup Solved/Closed

    Hello, I need to stop #N/A appearing after doing vlookup. I Understand that this happens because it refers to no value. Anyway I can make it ap...

  • one cell will turn green when the two other cells match Solved/Closed

    Hello, I am keeping a register of staff in our department. What I want to happen is for the cell (where the name is) to turn green when the date ...

    diestra123 | Excel | Latest reply: diestra123 Feb 20, 2013
    13 replies
  • =month(d2) Solved/Closed

    Hello, Empty cell in Excel file has changed in the month, while 0 is 1 reply should have come to help please Configuration: Windows XP / Chrome...

    ramlalmeena | Excel | Latest reply: ramlalmeena Feb 20, 2013
    5 replies
  • Macro to email picking up email address in one cell using lookup Solved/Closed

    Hi can anyone help me I am using the VBA below to email a results sheet to various people,the code that I have will only allow me to email to one pers...

    Tom9o | Excel | Latest reply: Tom9o Feb 19, 2013
    6 replies
  • returning value from column b in column c, in a cell ajacent to Solved/Closed

    Hello, BHID MN Samp 47.86 Samp 50.24 Samp 41.63 Samp 49.34 Samp 48.19 Samp 53.11 Samp 50.98 Samp 49.07 Samp 48.05 Samp 52.96 Samp 41...

    lawrencen | Excel | Latest reply: lawrencen Feb 19, 2013
    3 replies
  • Recovery my work and restart microsoft excel Solved/Closed

    Hello, everyone i have a problem with my excel while I start this program then open the file in MS Excel. Excel pops a message saying "MS Office ...

    Rangie | Excel | Latest reply: Sridhar L Feb 18, 2013
    21 replies
  • compare data in seperate columns to find likely matches Solved/Closed

    Hello, I want to compare data in columns which essentially is the same but worded different. For Example Name of Person County...

    Spraoi | Excel | Latest reply: Spraoi Feb 18, 2013
    4 replies
  • No tool bars or address bar on my browser Solved/Closed

    Hello, I don't know what I did, but my address bar is only visable when I drag my mouse up to the top of my screen and my toolbars have disappea...

    mandi | Excel | Latest reply: Paddy Feb 17, 2013
    175 replies
  • Code for macro that conditionally inserts rows Solved/Closed

    Hello, I know this has been asked and answered often, in particular here: https://ccm.net/forum/affich-222200-insert-rows-on-change-of-value-in-excel-...

    bfleming | Excel | Latest reply: bfleming Feb 15, 2013
    4 replies
  • excel for mac opens all files on desktop Solved/Closed

    Hello, Whenever I open any Excel file, Excel opens every file on my desktop as well (excel or not). I have to wait until the whole bunch load up, t...

    emee | Excel | Latest reply: Dan Feb 14, 2013
    10 replies
  • Can't open Excel file Solved/Closed

    Hello, I'm running a Mac (10.5.8) and am having trouble opening a recently created Excel file. I was able to open the file since the first time I ...

    duncan | Excel | Latest reply: yolooo Feb 13, 2013
    6 replies
  • IF statement errors and using multiple IF statements. Solved/Closed

    Hello, I am self teaching excel spreadsheets, and I would really appreciate some help to anyone that would graciously be willing to offer it. I ...

    jsav | Excel | Latest reply: jsav Feb 12, 2013
    3 replies
  • merging more cells into one cell Solved/Closed

    Hello, how to merge 3 cells into 1 cell? we tried and tried but we didn't get it.. even the formula, we don't know.. we are just a first timer. w...

    marjean | Excel | Latest reply: markswan20 Feb 6, 2013
    10 replies
  • how can calculate days between twodates Solved/Closed

    Hello, I HVE TO CALCULATE THE DIFFRENCE IN DATE. e.g: there is a two coloums as per below, purchase requisition date purchase order date ...

    samruddhi naik | Excel | Latest reply: Kevin@Radstock Feb 6, 2013
    2 replies
  • Transferring data from one sheet to another Solved/Closed

    Hello, I have been using Excel for a number of years but fairly new to formula etc. I need a VBA code that can copy data from costing(raw data) to ...

    cuffy70 | Excel | Latest reply: Cuffy70 Feb 3, 2013
    15 replies
  • Time calculations on a 24-hr clock Solved/Closed

    Hello, I need a formula that I can apply to my spreadsheet that will calculate how much time it takes someone to complete a task. Everything is b...

    Harters | Excel | Latest reply: Zohaib R Feb 2, 2013
    1 reply
  • Auto notify or mail when Excel sheet updated. Solved/Closed

    Hello, We have a Excel which is saved to a network drive and used by multiple users. What I need is when somebody updates the excel sheet or puts ...

    Satya | Excel | Latest reply: cdb2013 Feb 1, 2013
    20 replies
  • I have a problem with Microsoft Office starter? Solved/Closed

    Hello, I would respctfully ask anyone to help me with this problem which is: someday I have open the Microsoft Office starter and then I have been ...

    a cooperator | Open Office | Latest reply: a cooperator Jan 31, 2013
    2 replies
  • Excel 2007 resetting cells to Date format Solved/Closed

    Hello, I have an Excel 2007 spreadsheet that is resetting all the data cells to Date format. Have anyone seen this before? I don't think I have a vir...

    ktech25 | Excel | Latest reply: Archit Badwe Jan 30, 2013
    11 replies
  • conditional Formatting Solved/Closed

    Hello, I'm using Excel 2010 and need to conditionally format a cell based on various values in different cells. Specifically, if cell A2 states B...

    Harters | Excel | Latest reply: Harters Jan 27, 2013
    4 replies
  • Simply cannot find an answer Solved/Closed

    Hello, I have a spread sheet - column B lists dates for the last time a report for each product was completed. Each report is due every 28 days. ...

    mona3 | Excel | Latest reply: mona3 Jan 25, 2013
    8 replies
  • VB issue with delete rows with specific values Solved/Closed

    Hello, I am using 2007 excel and have the VB doing 2 things: 1) looking at specific Column for EXACT values and deleting row 2) looking at speci...

    weenie | Excel | Latest reply: rizvisa1 Jan 23, 2013
    8 replies
  • Macro Help: Copy Data from a Range of Sheets to a Master Sheet Solved/Closed

    Hi, I'm looking for some help developing a macro to collect data from a range of sheets in a workbook, but not all sheets. The macro needs to: ...

    supermate | Excel | Latest reply: supermate Jan 23, 2013
    7 replies
  • Tagalog Solved/Closed

    Hello, Hi! Is there anyone here knows how to speak Tagalog? If so, please let me know..I just have a few questions regarding in Excel. I cant ex...

    flower_girl | Excel | Latest reply: flower_girl Jan 21, 2013
    2 replies
  • How to convert number into text in Excel Solved/Closed

    Hello, pls.send me formula to convert number into text in Excel e.g.100001 in words like' one lakh one only"

    boratechandu | Excel | Latest reply: Raj Jan 21, 2013
    9 replies
  • Adding a new entry into a list - Excel 2007 Solved/Closed

    Hi Hope that someone can help me with this problem..... I've created a list in Excel 2007. I've added 3 colours in the list (blue, red, green). I ...

    talana | Excel | Latest reply: confused Jan 18, 2013
    12 replies
  • VLOOKUP range question Solved/Closed

    Hello, =VLOOKUP(A4,OLD!$A1:$B1404,2,FALSE) I'm using this formula in my spreadsheet and it is working EXCEPT when the new spreadsheet has inse...

    mjaybee | Excel | Latest reply: mjaybee Jan 17, 2013
    1 reply
  • Outlook - "Unknown Error" Ox800CCC81 Solved/Closed

    Hello, re https://ccm.net/faq/5929-outlook-unknown-error-ox800ccc81 would you have a fix for this with Outlook Express? thanks Configuration:...

    spurslisa | Outlook | Latest reply: marshalhubs Jan 15, 2013
    1 reply
  • adding the same action to every second line Solved/Closed

    hi guys, i wonder if you could help me with the following: there is a worksheet where column A is full with numbers. I would like to add to ever...

    DG83 | Excel | Latest reply: Dg83 Jan 15, 2013
    8 replies
  • If, Then formula Solved/Closed

    Hello, I am creating a spreadsheet for the company airplane. Part of it is to calculate how many of the miles flown were "occupied" (had passengers...

    eaglewings1983 | Excel | Latest reply: eaglewings1983 Jan 14, 2013
    2 replies
  • convert date into month name Solved/Closed

    Hello, suppose date has mention 1/1/09 and no month name then how to get the month name

    danny | Excel | Latest reply: Manoj Jan 14, 2013
    20 replies