Office Software Forum - solved topics

Ask a question
Results 2251 - 2300 of about 2,650
  • Solved
  • Excel - Copy rows "n" times with calculation Solved/Closed

    I need to have a macro that will copy rows from sheet1 to sheet 2 . The catch is from sheet 1 col C for e.g. C2 may have the number 5 in it. I need to...

    Tracy | Excel | Latest reply: rizvisa1 May 14, 2010
    3 replies
  • EXCEL Solved/Closed

    hi i always make our employee salary in excel. this file is very big. every month I have to put only OVER TIME,WORKING DAY and ABSENT...and i make all...

    milan | Excel | Latest reply: rizvisa1 May 13, 2010
    5 replies
  • Can a macro add a number? Solved/Closed

    I am working on a excel project where I will be able to click a button and the result would be a number added on another cell. For example, counting a...

    Giorgio.usa | Excel | Latest reply: rizvisa1 May 13, 2010
    7 replies
  • copy columns one below another Solved/Closed

    Configuration: Windows XP / Internet Explorer 7.0 hi i have data in the following form a b c d 1 6 11 16 2 7 12 17 3 8 13 18 4 9 14 19 5 10 1...

    sun_dands | Excel | Latest reply: rizvisa1 May 13, 2010
    7 replies
  • Combining 2 cells to 1 Solved/Closed

    Hi, I have data like below in two column of excel sheet: 1-Jan | 2004 23-Jul| 2004 12-Feb|2003 ................ ......... Out out require...

    Shashi | Excel | Latest reply: Shashi May 13, 2010
    2 replies
  • help excel: click & automatically copy paste Solved/Closed

    I need some help Let's say I have 5 different tabs named London, Paris,... Each tab contains different kind of information about the cities: popula...

    isabelle | Excel | Latest reply: rizvisa1 May 12, 2010
    1 reply
  • Search and Replace macro for microsoft excel Solved/Closed

    I have two workbooks with identical setup. item name address 1 address 2 address 3 x 12 34...

    Doyle1010 | Excel | Latest reply: rizvisa1 May 11, 2010
    3 replies
  • Click a Cell and insert a wingding Solved/Closed

    In excel I am wanting to be able to click a cell to insert a Selected wingding from a list. But to also beable to click the cell a second time to cha...

  • Add cells with other identical attributes Solved/Closed

    I'm looking to create a formula which can be copied into other cells that will add numbers in one column, where their attributes in another column are...

    armatt | Excel | Latest reply: armatt May 11, 2010
    2 replies
  • Line to reflect a Dash if no value Solved/Closed

    I am designing a check book registry, and I want the total column to reflect a - if there is no value from the formula. I had it this way in the past...

  • Help with Excel data selection Solved/Closed

    I would like to take a worksheet and create new worksheets for each specific value in a column. for example, one of my columns is "customer". I want...

    shevy | Excel | Latest reply: rizvisa1 May 11, 2010
    1 reply
  • Excel 2007 VBA Find Last Solved/Closed

    I have a mutipage workbook where I am coping information from three sheets and consolidating the information to another sheet so I can export into a c...

    Tjones4852 | Excel | Latest reply: rizvisa1 May 10, 2010
    1 reply
  • Macro to Find a info in more than one column Solved/Closed

    Hi, I need a help to match values in a column from other two columns. I have two columns with some values on them. I have another column [t...

    AJ | Excel | Latest reply: rizvisa1 May 10, 2010
    13 replies
  • Zeor to the end of 4 digit number Solved/Closed

    Hello, Can someone tell me a formula or macro that will add a 0 Zero to the end of a 4 digit number in each cell. I get a excell file with the 4 di...

    Crafish | Office Software | Latest reply: billkirby May 9, 2010
    2 replies
  • Excel frame a Do While Loop or macro Solved/Closed

    Hi All, Could anyone help me to frame a Do While Loop or a suitable macro? I need a method to copy formulas present in Cells F10 to Q10 in She...

    madambath | Excel | Latest reply: madambath May 9, 2010
    13 replies
  • date formate Solved/Closed

    Configuration: Windows XP / Internet Explorer 8.0 hi i have date formate in dd\mm\yyyy & dd-mm-yyyy. i need all the dates in same formate exp. ...

  • formula for dropdown list Solved/Closed

    Configuration: Windows XP / Safari 532.5 n excel i want to use a drop lown list and when enter specified text, then next cell should display my spe...

  • Problem in date format Solved/Closed

    Hi EVERY one I have very Big Problem i am making one report where two type of date format is appearing like MM-DD-YY 03-08-2010 and DD--...

  • I want the installation CD key of cod 5 Solved/Closed

    i have the cd and i have lost the cd-cover and also lost the installation code,please help me.

  • Insert rows with data when criteria is met Solved/Closed

    Hi, Thanks in advance for your help. I have two tables. If a field in table A is chosen, I want a macro which will insert rows of the data listed ...

    jan | Excel | Latest reply: venkat1926 May 8, 2010
    1 reply
  • Input a range of cells Solved/Closed

    If i want to highlight a row of cells in red to show a lead is dead say A1 to E1, buy inputting "lose" in E1 I now have the formula =$A$1="lose" whi...

    Andy | Excel | Latest reply: andy May 7, 2010
    9 replies
  • copy data next to a cell and paste it below Solved/Closed

    Hi, everyone I am a newbie in here, and I hope some one can help me solve this: I having a data such as the following cell | A ...

    kent5244 | Office Software | Latest reply: kent5244 May 7, 2010
    5 replies
  • Macro Assistance Solved/Closed

    I have a spreadsheet that has data ranging from C3:C263. Workbook is 'GSU CAS Transactional Upload', Sheet is called 'Alliance Upload' I need to...

    DCecil07 | Excel | Latest reply: DCecil07 May 7, 2010
    4 replies
  • convert a date figure into word in excel Solved/Closed

    I want to know the formula, how can I convert a date figure into word in excel 2003

    Jaydeep | Word | Latest reply: rizvisa1 May 7, 2010
    1 reply

    I am trying to write a macro that will insert rows as follows: Col 1 Col2 Col3 1 S 456 2 A 222 3 M ...

    KU | Excel | Latest reply: rizvisa1 May 6, 2010
    1 reply
  • link question Solved/Closed

    Using Excel 2003 - I have two tabs one has detail info for unit cost; the second has summery info for each unit. What I'd like to do is if you are on ...

  • Macro for array vlookup to worksheet Solved/Closed

    Looking for help with a quick macro please. I have four tabs in the workbook: Datadump - contains daily raw data to clean Central - Accou...

    Michael | Excel | Latest reply: rizvisa1 May 6, 2010
    14 replies
  • Need help with excel message pop up Solved/Closed

    I need Excel VB help to show a message pop up box to display whenever the value is below 10 or greater then 50 that's also not a multiple of 5 Con...

    dave | Excel | Latest reply: Trowa May 6, 2010
    6 replies
  • Updating Data in two+ worksheets Solved/Closed

    I have a question, I just created a spreadsheet with 8 tables which contain a deferent data and with Autosum column on each table and I created als...

    Omar | Excel | Latest reply: rizvisa1 May 6, 2010
    1 reply
  • Conditional Formatting with 3 cell Solved/Closed

    Hi all I want to do conditional formatting a cell but based on the criteria set by 2 other sells in the row so if A1 = 0 and B1 > 0 i want C1...

  • Link Data Solved/Closed

    Dear Excel Expert, I need help. I need to manage my data with diffrent User different sheet & the data need to update every week in master sheet...

    YeohSeow | Office Software | Latest reply: YeohSeow May 5, 2010
    14 replies
  • Range Change Colour Solved/Closed

    Please help. If I have a range of Data in cells say A1 to E1 and I wish to change all to red when I enter the word "lose" in A1 only what do I need...

  • Extract date from a series of numbers Solved/Closed

    Hi, I need to extract date from a series of numbers like 250420102356478 where 25(date)04(month)2010(year)2056478(sequence number) and answer sh...

    seekermay | Office Software | Latest reply: rizvisa1 May 5, 2010
    4 replies
  • pls help me with excel formula! Solved/Closed

    Dear excel experts, I have a dataset of A1:A15. I want to make a formula stating that if 10 cells of the range A1:A15 are greater than or equal 2 ...

    xcel | Excel | Latest reply: xcel May 5, 2010
    2 replies
  • finding the last row dynamically Solved/Closed

    Hi, I am using VBA in Excel 2007. I have a worksheet which has multiple columns. Each column has different number of rows. I want to find the la...

  • Date formatting problem Solved/Closed

    I have a date in a cell that is 23/10/2008, and shows up as this in the editing bar, but in the cell address it shows a figure, ie 39744. Why is this ...

  • vlookup formula Solved/Closed

    Hi, Could you please anyone help me in this? (column headings : Roll No. , correction date , Type , code , rank , Marks , exam date , time ,...

  • Highlight a cell greater than the one above Solved/Closed

    Hello, I am trying to use conditional formatting to highlight cells in a column (formatted as a table) that are greater than the number in the cell...

  • XCEL formula needed to return multiplication Solved/Closed

    I need a formula that does the following: if b10 is => than 10.03 AND c10 is => than 6.69, then multiply b10 times 328 It seems simple, but I ...

  • Incentive Calculation with few Condition Solved/Closed

    Hi, I need help... each month I need to calculate the incentive. manual calculation is wasting my time. i know excel can do it, but I am not ...

    YeohSeow | Office Software | Latest reply: YeohSeow May 3, 2010
    10 replies
  • Product key Solved/Closed

    Hello, I've trying to enter the product key so many times as behind my laptop. my lap is very new. i can't work with any software without this produc...

    Dilrukshi | Office Software | Latest reply: tracy4trading May 2, 2010
    3 replies
  • Sorting and deleting redundant value Solved/Closed

    Hi, I have been trying to sort our patient data in our daily work-up in the lab as below: "sample external no" "barcode" "assay" 4 321456 amf ...

  • Conditional formatting Solved/Closed

    can any one help me i have following situation and i drag the formula down , i do not want to show the result in c2 because there are no data in it(b...

  • excel formula! Solved/Closed

    I would like to make an excel formula that if at least 7 out of 10 cell (i.e A1 to A10) are greater than 5, then return as " accepted", otherwise "...

    xcel | Excel | Latest reply: xcel Apr 29, 2010
    2 replies
  • Selecting the required cells info from the co Solved/Closed

    Hi, I have a data like below in one column in excel: SL#00000 Product: ABC Region Name: Name1 City :1 Country:1 User con: Id type SL#88888...

    Shashi | Excel | Latest reply: Shashi Apr 29, 2010
    2 replies
  • Conversion of values already present in cells Solved/Closed

    Hi: I need to convert values already present in a range of cells to another currency. The current range changing causing headache. Any suggestions...

    mike | Excel | Latest reply: rizvisa1 Apr 28, 2010
    1 reply
  • Copy Paste - Excel Solved/Closed

    Hi I have a spreadsheet with a list of job titles in column A. there are a list of dates in columns G & I. there is information in all the ro...

    ITTrainee | Excel | Latest reply: rizvisa1 Apr 28, 2010
    1 reply
  • Selecting a printer in an Excel 2007 Userform Solved/Closed

    I am using the following code: Private Sub CommandButton1_Click() Application.Dialogs(xlDialogPrint).Show UserForm1.PrintForm End Sub I can...

    hbrewer | Excel | Latest reply: rizvisa1 Apr 28, 2010
    3 replies
  • Excel 2007 - Change cell color using If Solved/Closed

    I have a cell with a % in it. I would like that cell color to change to red if the percentage is below 60%, and change to yellow if it is between 60% ...

    ja6924 | Excel | Latest reply: rizvisa1 Apr 28, 2010
    1 reply
  • Lookup data on different worksheets Solved/Closed

    I have 2 spreadsheets with the same town names in column A and different dates in column N. I have a third spreadsheet with the town name and have ...

    DCP | Excel | Latest reply: DCP Apr 28, 2010
    2 replies