Office Software Forum - solved topics

Ask a question
Results 2401 - 2450 of about 2,650
  • Solved
  • Date formatting Solved/Closed

    Hello, I am currently downloading a report from an external source (csv file format) into excel and one of the fields (column P) should be represen...

  • Excel Solved/Closed

    Hello, I have an excel file with Start dates, end dates, total day, and networkdays columns. I would like to average these number for the average to...

    Mike | Excel | Latest reply: mike Mar 12, 2010
    5 replies
  • For each cell... VB HELP Solved/Closed

    Hello, Column A contains either "Ja" (yes), "Nee" (no) or nothing. I would like to know on which date the cell value is changed to "Ja". Therefor...

  • F 5 problem Solved/Closed

    Hello, Up untill yesterday, when I used F 5, the cell that I was going to always ended up in the upper left corner of the screen. Now it goes to so...

    selflearner | Office Software | Latest reply: rizvisa1 Mar 12, 2010
    4 replies
  • MS Words into (comma-separated) text file Solved/Closed

    Hello, What I try to do is that convert multiple MS forms into tab-delimited text files. If there is a quick and dirty way to do so, please let me ...

    Amit | Word | Latest reply: rizvisa1 Mar 12, 2010
    1 reply
  • Need help with a formula please!!!!! Solved/Closed

    Hello, I and creating a spreed sheet for my job to make weekly counts easier. I have been trying for hours now on a formula to calculate either a...

    Wickedsi | Office Software | Latest reply: Wickedsi Mar 11, 2010
    6 replies
  • Problem with "Lastline" in VBA Excel 200 Solved/Closed

    Hello, Let me start off by saying that I'm a VBA noob, and have never worked in it before. Basically, I inherited a spreadsheet which has a macro t...

    Scream77 | Excel | Latest reply: rizvisa1 Mar 11, 2010
    1 reply
  • Changing h:mm AM/PM to hhmmss Solved/Closed

    Hello, I need help changing imported times from i.e. 2:38 PM to 143800 (hhmmss). Please Help!! Thanks, icooper

  • moving the contents one cell up in a column Solved/Closed

    Hello, In my excel sheet the column C has contents in alternate cells starting from C1 till end. It looks like C 1 ...

  • formula to copy data Solved/Closed

    Hello, I have a range table that is 18 columns. I want to be able to look up the number in the first column and return all the info in the other 17 ...

    swittlin | Office Software | Latest reply: venkat1926 Mar 10, 2010
    1 reply
  • If statments w/ <= dates Solved/Closed

    Hello, Hello Want a brain buster? Its been busting mine all day…… I'm trying to create a statement for column J "frequancy of visit" to ret...

  • Macro to delete created object Solved/Closed

    Hello, With the following VB code I have created a wordart object: Sub ShowMessage() ActiveSheet.Shapes.AddTextEffect(msoTextEffect1, "Even...

    Trowa | Excel | Latest reply: Trowa Mar 9, 2010
    7 replies
  • looping for a specific time Solved/Closed

    Hello, I'm using Excel 2007 I have the following code: Sub Macro1() With Selection.Interior .Color = 255 End With Appli...

    selflearner | Office Software | Latest reply: selflearner Mar 9, 2010
    2 replies
  • What about mail account deleted? Solved/Closed

    Hello, i had sent a email to a friend and after sending the message came that the mail has been sent but he says that he has deleted his account . so...

  • copy/paste values on the specific column Solved/Closed

    Hello, I want to, copy/paste values on the specific column based on cell A2. i.e. if cell A2= 1 then copy/paste values for the January column (range...

  • Delete certain cells of active row Solved/Closed

    Hello, I would like a code for the following: Check which row is active/selected and then delete the data which is in the 5th and 7th column of ...

    Trowa | Excel | Latest reply: tatosgr Mar 5, 2010
    6 replies
  • insert rows based on count of row in another Solved/Closed

    Hello, I have a excel where I create few dummy accounts and the next sheet (sheet2) has details of these accounts. I need the sheet 2 to have certai...

    sumi | Excel | Latest reply: rizvisa1 Mar 5, 2010
    12 replies
  • last value in a row with diff. 25% on rel val Solved/Closed

    This is tough to even state, but I'll try with an example Example: find the first value that changed 50% in relation to the last time when there wa...

    mattkatt | Office Software | Latest reply: rizvisa1 Mar 5, 2010
    3 replies
  • colour Solved/Closed

    Hello, Hi and thanks for previous help. Last one for a while (I hope) I am using the below formulae you gave me and it is fine. However these res...

  • Excel Macro - Dynamic Column Selection Solved/Closed

    Hello, I am just beginning to learn Excel macros. I was working on a sheet wherein I have to select a column dynamically, based on just the column ...

    kunalp | Excel | Latest reply: maggie Mar 4, 2010
    3 replies
  • Text box linked to cell value Solved/Closed

    Hello, I have a text box placed in a chart that links to another sheet/cell for its content. The value is a percentage. I can format the source text ...

  • Dates Solved/Closed

    Hello, Crazy question.... I have a row full of different dates. I would like to create a formula to display in a separate cell, the earliest date fr...

  • Separate required records from a file, MAK Solved/Closed

    Hello, I am using following macro to separate required records from a file contain several worksheets and each worksheet contain thousands of rec...

  • Excel conditional formatting row color Solved/Closed

    Hello, I am trying to get Excel to automatically change the color of a row depending on the entry in column H. I've got some VBA code written up, but...

    Katsu | Excel | Latest reply: AM14 Mar 2, 2010
    17 replies
  • MATCH formula with external lookup_array data Solved/Closed

    Hello, I am trying to write a formula using the MATCH function =MATCH("x",r1:r10,0) to find the first instance of x in a column. Howev...

  • Copy Data One Sheet to Another Solved/Closed

    Hello, dear friend i have two work sheet.first sheet has a data.using subtotal function I'm daily taking summary of that data.that summarized data da...

    kaluputha | Excel | Latest reply: kaluputha Mar 2, 2010
    2 replies
  • Macro to Compare two sheet with both sheets h Solved/Closed

    Hello, I have a 2 excel sheet which has all the column having same. This has D$C Comment, OMS comments, Planned Resoluiton date & Sub account in bo...

    kk | Excel | Latest reply: venkat1926 Mar 2, 2010
    1 reply
  • Lookup,count and pie chart Excel2007 Solved/Closed

    Hello, Can anyone give advice? I got a form on sheet1 thats got a savebutton to save the input data of the form to the database on sheet2.On sheet2 ...

    Gouws | Excel | Latest reply: Gouws Mar 1, 2010
    4 replies
  • scores Solved/Closed

    Hello, Hi I will sonn get a sheet of student exam outputs listing there choice of answer from a to p for each question. I have a space st the top of...

  • how to match value with table Solved/Closed

    Hello, I have a problem to match the value from sheet 2 with another sheet name table. I want to compare if the value near with the value in the tab...

    waniey | Office Software | Latest reply: venkat1926 Mar 1, 2010
    3 replies
  • Countif based on two criteria Solved/Closed

    Hello, I'm tinkering with a spreadsheet I use for my business and would like to create a count of the number of products dispatched on a date. I ha...

    ShootingFish | Office Software | Latest reply: ShootingFish Feb 28, 2010
    4 replies
  • Changing color of a cell in a table... Solved/Closed

    Hello, I'm afraid that this post rather fits into the "free help" section of things here, I am a person with a basic knowledge of coding and i...

    ShootingFish | Office Software | Latest reply: ShootingFish Feb 28, 2010
    10 replies
  • How to fill selected cells with given data? Solved/Closed

    Hello, I often need to fill cells with a date of production. What kind of a macro would be usefull in this situation so that I could just select the...

    Jussi | Excel | Latest reply: hockey50 Feb 27, 2010
    13 replies
  • Selectively Transfer Data toPre defined Range Solved/Closed

    Hello, I am new to Excel VB. I'd like to compare a set of data from worksheet1 by meeting a set of multiple conditions/criterias and then transfer ...

    Yausi | Office Software | Latest reply: venkat1926 Feb 26, 2010
    3 replies
  • Find a string in Excel and remove all cells Solved/Closed

    Hello, I need to find a string (for example: abc) in a large worksheet then remove all cells containing this string. I have tried different functions...

    davidarth | Excel | Latest reply: Ex-Q?? Feb 25, 2010
    3 replies
  • Cut-paste row to sheet2 if columnvalue is met Solved/Closed

    Hello, I have got 2 sheets. Sheet1 contains a list of assignments, in which column B contains the status of those assignments. Sheet2 contains comp...

    Trowa | Excel | Latest reply: rizvisa1 Feb 25, 2010
    3 replies
  • Converting a number in words into a number Solved/Closed

    Hello, i want to convert wrods into a number.Let me say more clearly... if i take " one thousand five hundred six " it should be converted into ...

    siddhu | Word | Latest reply: rizvisa1 Feb 25, 2010
    9 replies
  • column comparison Solved/Closed

    Hello, i have two columns to confirm the name , I want 2 identitfy; do the first column name is same person in the weccond column for example...

    salambava | Office Software | Latest reply: venkat1926 Feb 24, 2010
    2 replies
  • Excel help Solved/Closed

    Hello, I am having trouble with an excel calculation, i'd be grateful for any help: I have menu items listed along the top, with a space for th...

    donkeyoaty | Excel | Latest reply: donkeyoaty Feb 24, 2010
    11 replies
  • getting perfomance of each vendor using excel Solved/Closed

    Hello, What I want is to get an evaluation of every supplier. Let say I have 20 list of supplier and list of product I'd ordered, including quantity...

    johnrussel | Excel | Latest reply: zmarlz04 Feb 24, 2010
    5 replies
  • Find a text in a sentence inside a cell Solved/Closed

    Hello, I have a column which has addresses of different Companies, eg. SHRUTIVEER,23/2/1/1 BHAGBAN CHATTERJEE LANE,HOWRAH 711101 2nd Floor, Eas...

    Sunil Magesh | Office Software | Latest reply: rizvisa1 Feb 24, 2010
    5 replies
  • adminstrater password problems Solved/Closed

    Hello, my 10 year old daughter changed her password on laptop on the admin user she cant remember her password .

    skribble6 | Word | Latest reply: xpcman Feb 23, 2010
    1 reply
  • copy a "Comment Text" in to "Cell T Solved/Closed

    Hello, my Self Deepak Kumar, I can't find the fomula how do Copy a "Comment Text" in to "Cell Text" in another sheet. Regards Deepak Kuma...

    Deepak | Office Software | Latest reply: aquarelle Feb 23, 2010
    2 replies
  • Date Format TODAY Solved/Closed

    Hello, I have an invoice with a date format "TODAY". If I create an invoice today, it assigns today's date. If I open the invoice tomorrow, it as...

  • Excel Forumla help (IF formula) Solved/Closed

    Hello, I need some help, I just can't figure the IF formula out. On my Excel 2007 spreadsheet, I am trying to figure out if I put the letter grad...

    pleasehelp1101 | Excel | Latest reply: pleasehelp1101 Feb 22, 2010
    2 replies
  • formatting with more than 3 colors Solved/Closed

    Hello, I need your help guys, i wanted to apply the formatting with more than 3 colors in my worksheet. The worksheet im working on has a lot o...

  • Conditional Formulat with #ous condiitions Solved/Closed

    Hello, I have to write a formula to account for 6 conditions from 6 different columns. Originally, I thought it could be done by a simple nested I...

  • Law School Acceptance Chances Solved/Closed

    Hello, I want to compare possible GPA and LSAT scores to Minimum Acceptance GPA and LSAT scores. I've tried using IF and AND functions, but I can't s...

  • counting Solved/Closed

    Hello, I am trying to count the number of cell's from I4:I304 that have "no access" in it, but in those cells not only do some of them have "no acces...

  • excel macro loop to insert pics into more cel Solved/Closed

    Hello, Could someone please help me in writing a loop in this macro in excel : I have an excel sheet where it contains the name of the pictures in c...

    vbayat | Excel | Latest reply: rizvisa1 Feb 18, 2010
    1 reply