Office Software Forum - solved topics

Ask a question
Results 751 - 800 of about 2,660
  • Solved
  • excel is automatically changing dates to a numeric code Solved/Closed

    Hello, I'm using Excel and when I put a date in a column it changes to a numeric code. For example: 4/5/15 now reads 42099. I've tried highlightin...

    mamagiglio | Excel | Latest reply: mamagiglio Nov 10, 2015
    2 replies
  • Protecting your formulas in multiple worksheets Solved/Closed

    Hello everyone, thank you in advance for any help I receive with is question. I have multiple worksheets in a workbook that have formulas in them b...

    dkayeh1 | Excel | Latest reply: rizvisa1 Nov 9, 2015
    5 replies
  • Fix The Code Solved/Closed

    Hello, Its being requested please fix the code given below the problem in this code is that any one of the given condition execute and once ...

    smuneeb | Excel | Latest reply: rizvisa1 Nov 9, 2015
    3 replies
  • Date format changes when editing it Solved/Closed

    Hi, I'm using Excel 2007. I've changed the date format to dd/mm/yyyy with no problems. However, as soon as I begin to edit a date, it changes to...

    Rich | Excel | Latest reply: rizvisa1 Nov 9, 2015
    5 replies
  • Copying entries from multiple sheets to new sheet, then summing Solved/Closed

    I run a weekly pub trivia and I use a spreadsheet to keep track of cumulative scores. There are 6 sheets in the file... Week 1 Week 2 Week 3 W...

    polyrhythm | Excel | Latest reply: nahidule Nov 9, 2015
    2 replies
  • Merge two macros of 2 diffrent workbooks Solved/Closed

    Hello, I have 2 macros in 2 different workbook Currently i have to run 1 st macro(!st work book),then open 2nd macro workbook then have to run...

    rash | Excel | Latest reply: rash Nov 7, 2015
    6 replies
  • Remove or Clear Data Solved/Closed

    Hello, I am grateful if this query be solved. If user Enter any value in C2 and also user enter "Best" or "Worst" in Cell D2, how it may clear th...

    smuneeb | Excel | Latest reply: smuneeb Nov 6, 2015
    10 replies
  • Multiple If in Data Validation Solved/Closed

    Hello, Its being requested please help in the below multiple IF function used in Data Validation =IF(ISNUMBER(E2),AND(E2>0,E2

    smuneeb | Excel | Latest reply: smuneeb Nov 6, 2015
    3 replies
  • Conditional copy of cells with corresponding values Solved/Closed

    I have a list of variables in column A. I also have their values in column B. I then have column C, which has variables from the list in column A but ...

    DR999 | Excel | Latest reply: DR999 Nov 5, 2015
    2 replies
  • Count formula (need help) Solved/Closed

    Hello, everyone I want to thank you in advance because I know that excel can be frustrating. I hope this is an easy one I have the following data list...

    dkayeh1 | Excel | Latest reply: RayH Nov 4, 2015
    1 reply
  • Using IF function with dates Solved/Closed

    Hello, I want to thank everyone for their time in advance. My problem is that I have a two cells/rows (78 & 87) in a column on this worksheet ...

    dkayeh1 | Excel | Latest reply: RayH Nov 4, 2015
    18 replies
  • Macros editing Solved/Closed

    Hi Guys, I have created a macro that splits a master worksheet into separate tabs based on specific criteria then saves each tab as a separate wor...

    jimmi_10 | Excel | Latest reply: rizvisa1 Nov 3, 2015
    1 reply
  • refer only one column from named range Solved/Closed

    Hello everyone and thanks in advance! I have a report in excel 2010. In that i created a named range as "nmerng" which refers two columns s...

    Maya | Excel | Latest reply: maya Nov 2, 2015
    2 replies
  • Lookup Relevant Value from table Solved/Closed

    Hello Team, I have a doubt, Consider the table : Event A B C 1 3020 3420 1324 2 3005 3405 5462 3 2990...

    Gokuneo | Excel | Latest reply: Gokuneo Oct 31, 2015
    4 replies
  • Copying dates in Excel Solved/Closed

    Hello, I created a workbook in Excel and frequently need to copy the same date down a single column. I've always been able to simply grab the + in...

    Jessica | Excel | Latest reply: berry Oct 29, 2015
    3 replies
  • How can I restore corrupt .edb? Solved/Closed

    Hello, I have an exchange server with a .edb that is in a dirty shutdown state. I have 2 storage groups. The second storage group will not mount d...

    JacobusdeKoning | Outlook | Latest reply: JacobusdeKoning Oct 27, 2015
    3 replies
  • have changed shortcut Solved/Closed

    now i can not open microsoft excel 2013

    annee1 | Excel | Latest reply: annee1 Oct 26, 2015
    0 replies
  • If statement Solved/Closed

    Hi, Could you please tell me what I'm doing wrong in this statement? I can't find the issue :( =IF(AND(C2="Passed",D2="Passed",E2="Passed"), "Pass...

    Nuno | Excel | Latest reply: BrianGreen Oct 24, 2015
    5 replies
  • Copy data from 1 workbook to another based on sheet tabs Solved/Closed

    Good day to all, I'm looking for a macro that can copy data from source workbook and paste it to master workbook based on specified sheet tabs. ...

    bimmy80 | Excel | Latest reply: bimmy80 Oct 23, 2015
    8 replies
  • Link data from one cell to another Solved/Closed

    Hello, ok now what I am trying to do is make a simple formula that will let me take some data out of work book a and have it appear in work book B. ...

    bu7129 | Excel | Latest reply: k Oct 22, 2015
    3 replies
  • Excel:Print one enlarged page to multiple pages Solved/Closed

    Hello, Is it possible to print a enlarged page to multiple pages in excel? Configuration: Windows / Chrome 45.0.2454.101

    Maya | Excel | Latest reply: maya Oct 22, 2015
    4 replies
  • Entering current time in specific cells Solved/Closed

    Hi, I am using a workbook where I record the time that I give each of my students an exam. I am using a tablet and I would like to be able to touch (o...

    friskymarsh | Excel | Latest reply: rizvisa1 Oct 20, 2015
    3 replies
  • Comparing Two Columns With other two columns in excel 2003 Solved/Closed

    Dear Sir, I want to compare two columns with other two columns in excel 2003. Columns are as below A B C D a 10 a 10 b 20 b 30 c 30 d 40 ...

    Sana | Excel | Latest reply: TrowaD Oct 19, 2015
    5 replies
  • Excel - shortcut key for print view Solved/Closed

    Hello, I am srinu what is d short cut key in ex-cel 2003 for print viewConfiguration: Windows XP / Safari 532.5

    chitti | Excel | Latest reply: shree Oct 19, 2015
    6 replies
  • create worksheets with names from a list Solved/Closed

    Hello, I would be most grateful if you would kindly help me out. I have a long list of projects and need to create an individual worksheet for ea...

    Child@heart | Excel | Latest reply: ac3mark Oct 16, 2015
    4 replies
  • file attachment Solved/Closed

    Hello, is it possible to attach an excel file in this forum, for a better understanding of a particular posed question? Configuration: Windows ...

    j1969c | Excel | Latest reply: Mazzaropi Oct 14, 2015
    1 reply
  • check info on two different cells... Solved/Closed

    Hello, Ladies, Gentlemen, I am working with the formula below, and it WORKS GREAT =IF(Z17="PAID","",IF(F17"CTF","",IF(TODAY()>B17+15,"PAY NOW","HOLD...

    j1969c | Excel | Latest reply: Mazzaropi Oct 14, 2015
    3 replies
  • Allow rules wizard to work without Exchange Server? Solved/Closed

    Hello, I no longer work for the company that had the Exchange server and I have my personal pop3 email coming into Outlook. When I try to use th...

    victor_eilander | Outlook | Latest reply: StefanFridriksson Oct 13, 2015
    2 replies
  • auto transfer data as i marked Solved/Closed

    Hello, I have a spreedsheet where there are names, enrolment No., various subjects(1st Year, 2nd year & 3rd year) of at least 10000 students related...

    Deb | Excel | Latest reply: rizvisa1 Oct 11, 2015
    1 reply
  • IF formula error: False Solved/Closed

    Hello, I'm trying to get one of three answers to show up in my excel document. Currently I have: ==IF(((J43/I43)*100)>=81,"APPROVED")&IF(OR((J43...

  • Counting action under condition of theyr value, and month when.. Solved/Closed

    Hello Guys, I came here for help again :) I need to solve one issue. I've created database, which contain column with Dates(column E),and column w...

    Branok | Excel | Latest reply: Mazzaropi Oct 9, 2015
    4 replies
  • @if formula Solved/Closed

    Hello, how do i formulate the following:- if cell B12 contains the word Meals, then I want to use the formula F12/2 else take 100% in F12 Conf...

    junebug65 | Excel | Latest reply: BrianGreen Oct 8, 2015
    5 replies
  • conditional Formating a column Solved/Closed

    Hello, I wish to conditionally format a column depending on another columns date value in excel 2010 Column A has a target date and Column B ha...

    Ian | Excel | Latest reply: Ian Oct 8, 2015
    2 replies
  • Copy cells based on conditions Solved/Closed

    Hello, I want to make several versions of a questionnaire specific for each out of 11 types of a product. Therefore I made a button for each of th...

    pefler | Excel | Latest reply: pefler Oct 8, 2015
    2 replies
  • Copying data from workbook to workbook using button Solved/Closed

    Hello guys nad ladies, I have a problem, i hope you can help me. I have an excel worksheet (2 columns, 7 rows) It's kind of daily statistics (email...

    Oxy | Excel | Latest reply: ac3mark Oct 7, 2015
    4 replies
  • Change color to different cells based on another cells text. Solved/Closed

    Hi, need some help, cannot figure this one out. I had attempted to use conditional formatting; however, it is not completely accomplishing what I hav...

    Riggs2015 | Excel | Latest reply: Riggs2015 Oct 7, 2015
    4 replies
  • Copy row and insert n times Solved/Closed

    Hello, I have an example below, I'd like to take the first row, copy it "n" number of times, then take the next row copy it the same "n" number of ti...

  • Compare two worksheets and Remove duplicated data from one Solved/Closed

    Hello everyone, I am struggling to find a solution and would value input from fellow users. The Problem: I have two separate worksheets "Customer...

    fillup56 | Excel | Latest reply: fillup56 Oct 6, 2015
    3 replies
  • Search for matches from columns on separate sheets. Solved/Closed

    Hello, I've got a problem that is stumping me, and I hope you all can help. I have two sheets in my workbook and I would like to have a formula, ...

    Tim | Excel | Latest reply: Tim Oct 6, 2015
    2 replies
  • How To Copy Data Between Several Sheets on VBA Solved/Closed

    Hi, I'm still a newbie on VBA, so I could use a little help on getting some code working. I have several client used for factoring. As such, each i...

    fcbarros | Excel | Latest reply: TrowaD Oct 1, 2015
    7 replies
  • values from one workbook to another Solved/Closed

    Hello, I need help - I have two worksheets one with costs and formulas I want to pull the answer from the formula block from the one worksheet to t...

    charms72 | Excel | Latest reply: charms72 Sep 30, 2015
    2 replies
  • i am unable to send out Hotmail from MS Outlook Solved/Closed

    Hello, I have configured two email address in outlook 2007. one gmail another one is hotmail. I can send email by my first one gmail account but I...

    shabbir abbas | Outlook | Latest reply: ac3mark Sep 29, 2015
    1 reply
  • Giving false with certain answers Solved/Closed

    Hello, I am having an issue with my formula. Certain values will give me the correct answer (A, B, C, D, F) but other values will give me a FALSE...

  • Range of cells depending on a condition. Solved/Closed

    Hello, I am trying to change part of a cell reference for a range of cells depending on a condition. For example, the formulas in column A & E: A...

    Milvy | Excel | Latest reply: Milvy Sep 29, 2015
    2 replies
  • Outlook Express emails disappeared - can I get them back? Solved/Closed

    A user opens his Outlook Express 6 (all windows updates up to date) this morning and finds that his inbox is empty. 200-odd messages that were there ...

    DavidCum777 | Office Software | Latest reply: EdwardHunterS Sep 28, 2015
    2 replies
  • match cells in excel with all characters same except one Solved/Closed

    Hi I was wondering if it was possible in excel to write a formula to perform the following task. I have two columns of data, col A and Col B . For eac...

    Murtuza | Excel | Latest reply: ac3mark Sep 27, 2015
    13 replies
  • Auto populate rows from master sheet to other sheets Excel 2013 Solved/Closed

    Hello, I'm working on a sheet to autopopulate from data that I've downloaded in Excel format. Currently, I have to recreate the wheel (spreadshee...

    RyanLug | Excel | Latest reply: vcoolio Sep 25, 2015
    3 replies
  • script which can check if a debit has a corresponding credit Solved/Closed

    Hello, I am new to VBA, and I am searching for a script which can check if a debit has a corresponding credit (same value bue with -/+), and highl...

    dennisvhansen | Excel | Latest reply: dennisvhansen Sep 24, 2015
    11 replies
  • IF functions with dates Solved/Closed

    Hi, I have recently become part of a restaurant management team. Previously they have used excel very basically, just manually inputting every piece ...

    kev8687 | Excel | Latest reply: kev8687 Sep 24, 2015
    1 reply
  • Excel - Compare data in two worksheets Solved/Closed

    Hello, I need help with the best way to combine information in two worksheets and identify rows where data in colum B and column C has changed on...

    Cat | Excel | Latest reply: Manish Sep 24, 2015
    9 replies