Office Software Forum - solved topics

Ask a question
Results 601 - 650 of about 2,650
  • Solved
  • Automatically moving data Solved/Closed

    Hello, I have a master data sheet that one column in the sheet that represents a sub set of the data. When I add information to the master sheet, I ...

    Matt3502 | Excel | Latest reply: vcoolio May 27, 2016
    22 replies
  • location master file in excel Solved/Closed

    I have location master file in excel. 1) I have another file in A2 column there is a address like 422, Ashok Vihar, New Delhi, 2) i want to brin...

    Param | Excel | Latest reply: ac3mark May 24, 2016
    1 reply
  • If Statements Solved/Closed

    Hello, I have a scenario working with a time sheet. So basically the way payments work is from 30 minutes to 5 hours is automatically 5 hours of w...

    Aztec | Excel | Latest reply: ac3mark May 23, 2016
    1 reply
  • memory card password recovery Solved/Closed

    Hello, i have nokia 5130 expressmusic mobile phone with 2 GB micro sd memory card .ihave forgot the password of memory card can any body tell me the...

    ammar | Word | Latest reply: emon May 19, 2016
    2 replies
  • Verifing-Vin Numbers Solved/Closed

    Good Afternoon, I have two Excel Worksheets, Mobile Equipment List, and USDOTALLBasics. Both contain the Vehicle Id Numbers. Is there a way to comp...

    AndreOrion | Excel | Latest reply: AndreOrion May 16, 2016
    4 replies
  • formula that searches in a row for a cell/column that contains Solved/Closed

    Hi. It would be greatly appreciated if someone could assist me with the following formula in excel: I would like a formula that searches in a ro...

    Zellie | Excel | Latest reply: Zellie May 12, 2016
    2 replies
  • Error in VBA Solved/Closed

    Hey, So I Have the following code: Sub GesamtlisteAenderung(ByVal Target As Range) Dim x As Integer If Intersect(Target, Columns("B:...

    Newmie2013 | Excel | Latest reply: Newmie2013 May 11, 2016
    1 reply
  • Replace function in Macro Solved/Closed

    Hello, I would like to request that in the range D11 to D510 if "-" or " -" or "- " this found then it would be replace with " ". Please do it ...

    smuneeb | Excel | Latest reply: TrowaD May 10, 2016
    6 replies
  • Securing a Excel Workbook Solved/Closed

    Hey! I Need to save a Workbook strictly as a Template where the peolple at work can't screw it up. I'd like to have it so that they can open my...

    Newmie2013 | Excel | Latest reply: Newmie2013 May 10, 2016
    2 replies
  • Copying function using VBA Solved/Closed

    Hello, I have a Problem that desperately Needs to be fixed: I am trying to create a Participant List, and in order to Keep it "clean", am using ...

    Newmie2013 | Excel | Latest reply: Newmie2013 May 10, 2016
    5 replies
  • Dell Inspiron 1545 system/admin. password Solved/Closed

    Hello, my friend bought a Dell Inspiron 1545 at an estate sale.It has the system/administrator password enabled. I'm hoping someone can try to generat...

    realaz78 | Word | Latest reply: TONY May 5, 2016
    7 replies
  • copy formulas from one sheet to another all at once Solved/Closed

    Is it possible to copy formulas from one sheet to another all at once? I have a worksheet that I would like to use as a template and I'm having to cop...

    Mflores81 | Excel | Latest reply: vcoolio May 4, 2016
    2 replies
  • Excel Doubt - IF Formula Solved/Closed

    Hi, Im stuck in an if question. I have 3 colums. In the first one I have a number, in the second column a have "yes" and in the third column I w...

    Joao Brito | Excel | Latest reply: Joao Brito Apr 29, 2016
    3 replies
  • add worksheets to excel workbook using count defined name Solved/Closed

    Hello, I need to add worksheets based on a count which I defined as ADDTABS located in cell B4 on a worksheet called QRY-CMW. The worksheets ne...

    raungst98 | Excel | Latest reply: raungst98 Apr 27, 2016
    2 replies
  • Publisher? Solved/Closed

    Hi, just joined looking for Publisher, which I thought I had found. The only problem is it ask for a key code and it is all in French. Advice please?

    macduffpiper | Office Software | Latest reply: TrowaD Apr 25, 2016
    3 replies
  • pdf e-mail attchmnts open to word by default Solved/Closed

    Hello, When I receive an e-mail with a pdf attachment it opens as a word encoded document (e.g. garbage). I need to change the default settings f...

    TT | Word | Latest reply: PC Apr 22, 2016
    14 replies
  • Changing font color in one cell when % in another cell changes Solved/Closed

    Hello, I have a balance in B1 of what's owed on my credit card. I have the % of use on that card in D1, IE 35%. I want the font color to change ...

    abqjukebox | Excel | Latest reply: abqjukebox Apr 22, 2016
    0 replies
  • Text format to date/month/year on excel Solved/Closed

    Hello, I have a huge list of data that has multiple dates/year along with different time format. I want to delete the time and obtain only the d...

    Cheryl | Excel | Latest reply: ExcelNewbie Apr 22, 2016
    20 replies
  • I want to retrieve value from multiple sheets of same workbook Solved/Closed

    Hello Everybody,.. I have a situation where I request your support, My active workbook has 4 working sheets (sheet1- Master, sheet2, sheet3, sheet4...

    Gokuneo | Excel | Latest reply: Mikkelo Apr 22, 2016
    9 replies
  • Copy range data in a column to new column. Solved/Closed

    Need help here please !!! Data available : A range of data in a column. Some of the cells are blank. My requirement : Is there any formula where...

    anthonyishere | Excel | Latest reply: anthonyishere Apr 21, 2016
    6 replies
  • Compare two columns Solved/Closed

    Hello, In the excel, I need to compare Only portion of text in two different columns and return the value in third columns. say example One column...

    kumar | Excel | Latest reply: kumar Apr 21, 2016
    2 replies
  • Counting number of times a value appears if.. Solved/Closed

    Hello, I conducted a survey in which some questions allowed more than one response. Using Excel - I'm trying to count the number of times a cert...

  • Transfer an entire row from one sheet to another Solved/Closed

    Good Evening, I seriously need major help. Please!! Please!! Please!! I have an inventory of over 600+ items (rows) each row has 12 columns with...

    JC | Excel | Latest reply: vcoolio Apr 20, 2016
    5 replies
  • Add to Excel Macros Solved/Closed

    Hello, I'm looking to edit a macros code and I'm having some issues. Right now our workbook includes a growing amount of days on a project (day 1, d...

    Victoria | Excel | Latest reply: vcoolio Apr 20, 2016
    6 replies
  • Protected worksheet Solved/Closed

    Hello, I would appreciate advice as to whether it is possible to unprotect an excel worksheet if the password is forgotten? If it is possible plea...

    whatsit | Excel | Latest reply: whatsit Apr 18, 2016
    2 replies
  • Copy row only if one cell's value is not 0 Solved/Closed

    I would like to copy from a sheet to another only the rows in wich a cell ex.A1 has a value different from zero or blank. Thanks a lot!

    victhor1977 | Excel | Latest reply: vcoolio Apr 18, 2016
    3 replies
  • A variation on the compare 2 columns in Excel Solved/Closed

    Guys - Please advise and give me a few hints (or if you are generous write a macro for me [only joking ... a bit - please feel free to write it for me...

    BrianGreen | Excel | Latest reply: BrianGreen Apr 13, 2016
    2 replies
  • How to change word in cell using another word in another cell Solved/Closed

    Hello, I have 2 qns 1) Everytime i enter "Sells" in a cell i want another cell to appear "to" and in the same cell if i key "Buys" i want the o...

    Cherietan | Excel | Latest reply: Cherietan Apr 13, 2016
    10 replies
  • Outlook 2010 configuration for Solved/Closed

    Hello, I am not able to configure outlook 2010 for OS- window 7 64 bit Could you please provide me the server, port details.. Thank y...

    tanza2012 | Outlook | Latest reply: Rod B. Apr 12, 2016
    11 replies
  • IF Function Time Solved/Closed

    Hello, I am trying to make a rota and I need help with a formula. A1 B1 C1 07:00:00 14:30:00 =b1-a1 The person st...

    Ashakil | Excel | Latest reply: Ashakil Apr 11, 2016
    2 replies
  • Check if there is a match to a cell in the rest of the workbook Solved/Closed

    Hello, I've got a workbook that has divided a list between 10 different worksheets (based upon their categorization), unfortunately, the list that...

    Ixon | Excel | Latest reply: Ixon Apr 11, 2016
    0 replies
  • Reminder Solved/Closed

    Friends Hi can anyone please help me? I need to set up a reminder in excel. I have a workbook containing a sheet that contains all our permits and in...

    lynng | Excel | Latest reply: vcoolio Apr 7, 2016
    7 replies
  • Stupefying differential result! Solved/Closed

    Hello, in the attached picture you can see that in cell E23 I inserted my budget and in cell E23 I inserted what I actually spent (the same amount) sh...

    j1969c | Excel | Latest reply: j1969c Apr 5, 2016
    4 replies
  • Dates written in different ways Solved/Closed

    Hello, I have a spreadsheet with dates written in different ways. August 2010 is written both August-10 and August 2010. How can I change this so ...

    Nora | Excel | Latest reply: vcoolio Mar 31, 2016
    3 replies
  • Count all cells containing a particular text Solved/Closed

    I am using Microsoft Office 2016, and I am trying to make an autimated numerical count of all cells which contains a certain phrase for a table. An e...

    chemisecure | Excel | Latest reply: RayH Mar 30, 2016
    3 replies
  • Removing "FALSE" from an IF statement with a VLOOKUP Solved/Closed

    Hello, I would like to remove the "FALSE" result I get when using my IF formula. The formula is a VLOOKUP that is looking at 2 different cells. ...

    RayRay | Excel | Latest reply: RayRay Mar 29, 2016
    2 replies
  • transfer data Solved/Closed

    Hello, Is it possible to transfer data for sheet 1 to another sheet i select form a drop down box that contains all the sheet's name in that wor...

    lynng | Excel | Latest reply: vcoolio Mar 27, 2016
    4 replies
  • Publisher Solved/Closed

    I downloaded the free version of Publisher but do not see it featured anywhere on my computer?

  • Hiding rows when validation list is changed Solved/Closed

    Hello, I have a excel sheet where have two sets of product line. I would need only details for one set of product line visible if i select it in ...

    Danny | Excel | Latest reply: tani Mar 24, 2016
    2 replies
  • Userform to export data to another sheet Solved/Closed

    Hello everybody, Please could anyone spare his/her scares time to help me, I'm new in this forum and I hope to be an expert in excel. Your contribu...

    redbaby | Excel | Latest reply: redbaby Mar 24, 2016
    4 replies
  • counting and stop counting days in a cell Solved/Closed

    Hello, I need to create a formula for a cell involving number of days between dates. First cell - counts the number of days before and after du...

    diestra123 | Excel | Latest reply: diestra123 Mar 23, 2016
    4 replies
  • vlookup formula help please Solved/Closed

    =IF(PaymentDetails!$B22="","",VLOOKUP(PaymentDetails!$B22,AppMember,4,FALSE))*E22 Please everybody, how do I write this formula so as not to return...

    redbaby | Excel | Latest reply: redbaby Mar 22, 2016
    6 replies
  • Need a formula to sum a column with #Value error Solved/Closed

    I need a formula that will sum column i8 to i65536 in cell m7 ignoring #value error. Any help? Thanks.

    redbaby | Excel | Latest reply: redbaby Mar 21, 2016
    2 replies
  • auto copy/paste data if criteria (same value in 2 cells) is met Solved/Closed

    Hello from Barcelona, just signed up ... my first question ... excited :) I have 2 tabs. Tab 1 shows in column B the employee number and in col...

    JensBCN | Excel | Latest reply: JensBCN Mar 20, 2016
    1 reply
  • Duplicating data from one line on sheet 1 to sheet 2 Solved/Closed

    Hello, I'm looking for help, I have data in one box on sheet1 one that when I update that data I would like for it to automatically change in a bo...

    Buford | Excel | Latest reply: vcoolio Mar 19, 2016
    6 replies
  • colour changing in rows determined by text in 2 different cells Solved/Closed

    Hello, i would like to change the colour of a number of cells in a row if column P contains any text, however the colour it changes to depends on the...

    kitchens | Excel | Latest reply: TrowaD Mar 17, 2016
    1 reply
  • transfer data between sheets in excel Solved/Closed

    Hello, This involves an attendance sheet. A tab for each month with columns for weekly attedance and a total for the month and a summary tab contai...

    rodney hughes | Excel | Latest reply: Anonymouse Mar 16, 2016
    19 replies
  • Compare values of two separate sheets and returning value Solved/Closed

    Hello, Configuration: Windows 7 / Chrome 43.0.2357.81 I'm currently working a spreadsheet trying to match values from Sheet 1 Column B with...

    Camron | Excel | Latest reply: ac3mark Mar 15, 2016
    3 replies
  • Recording Macro To Duplicate Page And Rename To Numeric Value Solved/Closed

    Good day I am trying to record a macro that duplicates a page and renaming it to another file name but need to follow in numeric order. I have a...

    Shaun@1 | Excel | Latest reply: Shaun@1 Mar 15, 2016
    2 replies
  • Need to find a data in a column and copy below cell data or add Solved/Closed

    Hello , Please help me to solve this, it will be very grateful column A column B column c 1......................... .........2 2.................

    hirdesh_saxena | Excel | Latest reply: hirdesh_saxena Mar 14, 2016
    2 replies