Office Software Forum - solved topics

Ask a question
Results 1701 - 1750 of about 2,640
  • Solved
  • Transfering data to a new sheet Solved/Closed

    I'm running excel 2007 on windows 7, if that's important. I'm trying to find a way to transfer data from a master sheet (or basically sheet 1) to...

    Stickihasit | Excel | Latest reply: Stickihasit May 4, 2011
    3 replies
  • Format data in excel for Db transaction Solved/Closed

    Hello, I have a simple question, I have a range of cells with numbers in each cell. I want to add a single quote or apostrophe in the start and end...

    ms.pre | Excel | Latest reply: holly May 4, 2011
    3 replies
  • formula for every 200hrs cycle Solved/Closed

    Hello, now i'm trying to do a schedule maintenance for one part.the hours for the parts will increase everyday.e.g today 240 hrs,tomorrow 256 hrs....

  • Getting prompt-name list while entering data Solved/Closed

    Hello, I have a new question now. I will have traveller /passenger names who travel frequently (or having travelled atleast once by buying tickets...

  • my tally is not opened Solved/Closed

    Hello, click the tally icon it shows problem with shortcut, the item tally9.exe that this shortcut refers to has been changed or moved, so this sh...

  • find a word in excel Solved/Closed

    Hello, I have set up a spreadsheet to keep track of my daily workouts. The spread sheet is set up as follows: Column A: Date Column B: Descrip...

    Tim | Word | Latest reply: TrowaD May 2, 2011
    7 replies
  • Excel Macro to copy text and append Solved/Closed

    Hello, I recorded a macro in Excel where I copied the text from one cell and appended that text to the values in several other cells. The problem...

    sgriffis | Excel | Latest reply: RWomanizer May 2, 2011
    4 replies
  • cell reference to locate /store data in excel Solved/Closed

    Hello, Hello , I am working for a newly started airline agency. I am enclosing my working file (for privacy sake , I have changed names and oth...

    Suryam | Excel | Latest reply: suryam May 2, 2011
    8 replies
  • Emailing selected cell range using outlook Solved/Closed

    Hello, Hi, I have one task. I need to email some of my invoices that I prepare on a daily basis. I have a .xls file with some work sheets. I have ...

    suryam | Outlook | Latest reply: RWomanizer May 2, 2011
    7 replies
  • Comparing two ranges of numbers Solved/Closed

    Hello Everyone, Let me first say I'm very much an amateur with VBA code, but I have been using examples I have seen online to cobble together ...

    ChrisCoR | Office Software | Latest reply: RWomanizer May 2, 2011
    5 replies
  • Excel macro help Solved/Closed

    Hi there, I am getting an error when I try and run the following macro. I am trying to find the value in one worksheet (final) in another worksheet ...

    Fi | Excel | Latest reply: venkat1926 Apr 29, 2011
    1 reply
  • auto incrementing alphanumeric cell by 1 Solved/Closed

    Hello, I have an alpha numeric cell in excel sheet. for example IND/APR/6734/INV I am using it to give number to the invoce that I generate everyda...

  • Lost windows password fix gone bad. Solved/Closed

    Hello, My buddy changed his password on his computer. He forgot said password and tried all day to log in. He asked me for help and I found a progra...

    jfinn | Word | Latest reply: Ambucias Apr 28, 2011
    6 replies
  • Old Toshiba 3480CT admin password Solved/Closed

    Hey guys, I have an old Toshiba Portégé 3480CT and need to get past the admin password. I have no idea who would know it, it's been in our office ...

    Joe | Word | Latest reply: bionik Apr 28, 2011
    1 reply
  • Add/remove month button for chart. Solved/Closed

    Hello, My chart receives data from columns. Each column is a month. Now I want to create two buttons: First button to add a month and another...

  • Delete AllowEditeRanges by VBA Solved/Closed

    Dear All, Can some-body help me to correct the following code: Private Sub CommandButton1_Click() Dim WS As Worksheet Dim aer As AllowEditRang...

    issa | Excel | Latest reply: Issa Apr 26, 2011
    3 replies
  • Delete AllowEditeRange by VBA command Solved/Closed

    Dear All, Can anyone help me to correct the following code: Private Sub CommandButton1_Click() Dim WS As Worksheet Dim aer As AllowEditRange...

    Celina | Excel | Latest reply: Celina Apr 26, 2011
    2 replies
  • Excel Conditional Formatting Rows to Columns Solved/Closed

    Hello, I have a data set that looks like: A B 1 20 2 21 3 21 4 03 1 19 2 34 3 23 4 25 1 23 2...

    em | Excel | Latest reply: em Apr 25, 2011
    2 replies
  • HELP about macro copy and paste Solved/Closed

    Hello, Just want to seek help to anyone about my problem about copying and paste multple raw and column thru new sheet also with designated raw an...

    marvs | Excel | Latest reply: venkat1926 Apr 20, 2011
    3 replies
  • Copy to first open cell in rowB/sheet 2 Solved/Closed

    Hello, Thanks for trying to help! I have a sheet as shown below. We do sales every day and would like the values/ estimates and sales that have...

    Stormdronk | Excel | Latest reply: Stormdronk Apr 20, 2011
    6 replies
  • VBA - how to replicate the value n times Solved/Closed

    Hello, I have to write in VBA a macro that allows to replicate value n times (input). Let's say, I have a list one two three and I have to re...

    gradelle | Excel | Latest reply: gradelle Apr 18, 2011
    5 replies
  • Help required in MS Excel Solved/Closed

    Hello, I have a list of text strings in rows separated by blank rows. For example: Row 1: Name of the publication Row 2: Authors Row 3: Organiz...

    eskagsms | Excel | Latest reply: eskagsms Apr 16, 2011
    7 replies
  • check value in a cell vs Mid value in another Solved/Closed

    Hello, I have months in column A in number format. Single digit for the first nine months and double digit for the last 3 months. In column B, I...

    student of VBA | Office Software | Latest reply: TrowaD Apr 15, 2011
    1 reply
  • how to compare columns of 2 different Excel Solved/Closed

    I want to compare column named employeeid in two different EXcel sheets and have to retrive the rows with same employeeid ex: sheet1 emp name ...

    prathibha | Excel | Latest reply: RWomanizer Apr 15, 2011
    3 replies
  • Excel If Then, create a new column Solved/Closed

    Hello, I'm trying to write a VBA code, because I have too many factors to create a nested function. I can do it fine if there were less than 7 variab...

    AprilZ | Excel | Latest reply: RWomanizer Apr 14, 2011
    7 replies
  • VBA to Protect sheets & keep some options on Solved/Closed

    Dears, I will be very grateful if some one can help me. I have excel file include 50 sheets, so I made one sheet that include all the basis info fo...

    issa | Excel | Latest reply: Issa Apr 13, 2011
    2 replies
  • Indirect function on Excel Solved/Closed

    Hello, I need to know how I can add the following to an exsiting cell reference in a whole column. ='Sheet1'!A2 to show =INDIRECT("'Sheet1'!...

    PM | Excel | Latest reply: tipsindeed Apr 13, 2011
    10 replies
  • reset gt-s3653 phone security password Solved/Closed

    Hello, sir I am jass pls help me forgot my gt-s3653 phone security password. My IMEI No:- 35804003285049/1. Reply as soon as possible codes ! Thanks

    jass | Word | Latest reply: Ambucias Apr 12, 2011
    1 reply
  • CheckBox Selection Solved/Closed

    Hello, I've got two checkboxes,CheckBox1 and CheckBox2.I would like to make only one of the checkboxes to be selected at any one time.If one become ...

  • searching names in drop down list in excel 07 Solved/Closed

    Hello, I have placed a drop down listbox in my excel 2007 work sheet and selected the range of names which are in the same sheet. In the list I hav...

    suryam | Excel | Latest reply: RWomanizer Apr 11, 2011
    5 replies
  • How do i change or reset the password to my w Solved/Closed

    Hello, I recently bought a laptop from a second hand store. However the previous owner had a password set on the only administrator account and i ...

    Danni Liam | Word | Latest reply: pcsces Apr 11, 2011
    1 reply
  • server settings Solved/Closed

    Hello, My which was in is not working from 08.04.11. what is happening? I need that ID very essentially. What to do? Sam...

  • formula for text Solved/Closed

    Hello, I am trying to make a formula for text. This is what i want; In one coloumn i have a category and i want the next coloumn to be the in...

  • fill a series stop with value of another cell Solved/Closed

    Hello, I wish to fill to the right, rows whose number of entries depends on a cell to the left, and whose length is therefore variable. e.g. ...

    bushman | Office Software | Latest reply: RWomanizer Apr 4, 2011
    3 replies
  • Excel formula problem Solved/Closed

    Hello, Please Help =IF(V12=1,2*(R12*50%)) I have a problem with this formula: What I need, is if v12 = 1, 2, 3, or 4 count R12 times 50%...

    Stormdronk | Excel | Latest reply: Stormdronk Apr 4, 2011
    3 replies
  • forgot password Solved/Closed

    Hello, i forgot my admin password of my windows xp. how do i log on now? Plz help Configuration: Windows XP / Internet Explorer 6.0

    ramesh | Word | Latest reply: bionik Apr 3, 2011
    1 reply
  • looking for duplicate numbers from one column Solved/Closed

    Hello, i have 4300 old applicant numbers which i need to check against 3300 new applicant numbers and highlight duplicates. these are in two colu...

  • Excel: If A1 = a 4 the comy content of b1,2,3 Solved/Closed

    Hello, Please help! If A1 = a 4 the comy content of b1,2,3,4,5 to c1,2,3,4,5 The 4 in a1 are generated by a formula. Thanks Confi...

    Stormdronk | Excel | Latest reply: rizvisa1 Apr 3, 2011
    3 replies
  • Formulas to search for certain words in cells Solved/Closed

    Hello, I have monthly bank statements that are downloaded into excel, over 2500 line items. In Column A, I have the description of the transac...

    Juniore Guerra | Word | Latest reply: venkat1926 Apr 2, 2011
    4 replies
  • system password remove Solved/Closed

    Hello, how i can remove system password Configuration: Windows XP / Internet Explorer 7.0

    Nafyad | Word | Latest reply: bionik Apr 2, 2011
    1 reply
  • Excel - Help! Solved/Closed

    Hello, I require a formula which will recognise months in a column and select taht value from a different cell on the same row. The data is the...

    The_g | Excel | Latest reply: TrowaD Apr 1, 2011
    1 reply
  • Format using Macro Solved/Closed

    Hi I have some data in sheet1. Eg: Column A Column B Column C Column D 1 2 3 4 ...

    Rahul | Excel | Latest reply: harry Mar 29, 2011
    16 replies
  • Filter rows in one sheet Solved/Closed

    Hello, I have large amounts of data in one work sheet(say it as Sheet1) and another worksheet(sheet2) has few records(100) which are also present ...

    gd | Excel | Latest reply: RWomanizer Mar 29, 2011
    5 replies
  • converting rows data into columns on conditon Solved/Closed

    Hello, I have data which looks like below ColA-----------ColB-------ColC--------ColD------------ColE---------ColF-------ColG----ColH-------- AA-...

    gd | Excel | Latest reply: RWomanizer Mar 29, 2011
    3 replies
  • delete cells/rows but keep row info intact Solved/Closed

    hello, I am trying to import data from an excel spread sheet to access. I want to clean up my excel report before I import the date. In my report...

    lenice | Excel | Latest reply: TrowaD Mar 25, 2011
    2 replies
  • Looking for value in a column A Solved/Closed

    Hello, I have to prepare an invoice and calculate the amount of shipping. This is the lay out: I have to compare the subtotal value, E16, in ...

  • Dates in Excel Solved/Closed

    Hello, I have a list of people's birthdays in a list in Excel. I want to retain only the day and month of the birthday and get rid of the year. For ...

    eskagsms | Excel | Latest reply: RWomanizer Mar 24, 2011
    1 reply
  • Excel Comparing 2 columns removing duplicates Solved/Closed

    Hi, I would like to cmpare 2 columns in an Excel spreadsheet & remove duplicates from Column B if any matching fields are found e.g. A B 1 ...

    Ben | Excel | Latest reply: rizvisa1 Mar 23, 2011
    3 replies
  • Excel 2007 VLOOKUP and MATCH problem Solved/Closed

    Hello Long time lurker, first time poster. I'm having an issue with a Vlookup and match function. I have a set of data that is organised and sorted...

    Nikeyg | Excel | Latest reply: Nikeyg Mar 23, 2011
    1 reply
  • Transfer barcode info to inventory quantity Solved/Closed

    Hello, Is there a way to create a macros that would keep track of inventory quanitity by scanning a barcode? I have many boxes that have barcodes...

    osborns9 | Office Software | Latest reply: osborsm Mar 22, 2011
    2 replies