Office Software Forum - solved topics

Ask a question
Results 2201 - 2250 of about 2,650
  • Solved
  • Please help - run macro when switching sheets Solved/Closed

    Hello, If someone could tell me how to run a macro upon switching worksheets, that would be extremely helpful. If this is not possible, perhaps ru...

    D | Excel | Latest reply: D Jun 7, 2010
    2 replies
  • undoing a macro to retrieve info back Solved/Closed

    Hello, If I accidentally run a macro, can I (edit undo) to retrieve the information back to how it was? Configuration: Windows XP / Internet Ex...

    kat | Excel | Latest reply: kat Jun 7, 2010
    2 replies
  • macro to blank out filtered columns Solved/Closed

    Hello, I have a worksheet that is filtered by a number. I would like to blank out columns M, N, S and T. (Only the filtered information) Can yo...

    kat | Excel | Latest reply: kat Jun 7, 2010
    2 replies
  • excel conditional formatting Solved/Closed

    Hello, if date in cell A1 appears anywhere from B1:B30 then apply format. Configuration: Windows XP / Internet Explorer 7.0

    g | Excel | Latest reply: G Jun 7, 2010
    4 replies
  • Return a value from a data set Solved/Closed

    The problem is I have number 1 to 10 in A2:A11 and number 10,20,30....100 in B1,C1,D1..... K1 and there are corresponding values in the cells under th...

  • default password for china moblie X.E88 mob ? Solved/Closed

    Hello, i need default password for china moblie X.E88 mobile ohone.. pls some one help me..

    surya | Word | Latest reply: surya Jun 7, 2010
    2 replies
  • 3 dropdownlists Solved/Closed

    Hello, Please help I want to make 3 dropdown lists in Column B2,3,4 and all must work together. In B2 i must have a selection of e.g Building,Person...

  • Code to open a tabs from combox excel Solved/Closed

    Hello, I'm looking for a code, i can put in a combo box to show up different tabs located in my spreasheet. example: I have four tabs called tab1,...

    Mary | Excel | Latest reply: Mary Jun 6, 2010
    6 replies
  • Excel 2007 days and dates issue? Solved/Closed

    Hello, I was working to have the week numbers in excel and i step into a question when i entered in cell "B1" the date 05/1/2010 and i changed the...

    dfernandez | Excel | Latest reply: rizvisa1 Jun 5, 2010
    3 replies
  • Look for a value into different ranges Solved/Closed

    Hello, PLeas take a look on the following data A B C D E Range 1 Range 2 NAME 81000...

  • forget my phone password Solved/Closed

    Hello, sir i forget my phone password please help me

    kool | Word | Latest reply: Ambucias Jun 4, 2010
    2 replies
  • Excel Formula Solved/Closed

    Hello, I am looking for a formula or script that can help me with the following. I am doing a spreadsheet for 19 different offices (on seperate...

    djb | Excel | Latest reply: djb Jun 4, 2010
    4 replies
  • Matching columns Solved/Closed

    Hello, I have to an issue with matching columns. Column A Column B Column C Column D Column A: This has 300 lines with account #'s Column...

    KJFin | Excel | Latest reply: KJFin Jun 3, 2010
    2 replies
  • IF Statement Required please Solved/Closed

    Hello, Date 1 Date 2 Days varience Status 04/05/2010 29/04/2010 -5 On Time 04/05/2010 06/05/2010...

  • macro that takes multiple csv files and puts Solved/Closed

    Hello, I need a macro that takes multiple csv files and puts them all in 1 worksheet. The csv files all have header info that i do not want copied ...

    sacklin | Excel | Latest reply: jrog Jun 1, 2010
    3 replies
  • MS Office 2007 opens files as Read Only Solved/Closed

    Hello, I installed Office 2007. Each time I open a file in Excel, it opens it as Read Only and won't let me save with the same file name and thus...

  • Excel 2007 "If....Then select Row and move&qu Solved/Closed

    Hi all! I have what would appear to be a basic question, but can't seem to put my brain around the solution. I have a spreadsheet on Sheet 1. O...

    Matt | Excel | Latest reply: rizvisa1 Jun 1, 2010
    11 replies
  • Copying data in a dfrnt sheet w/ condition Solved/Closed

    Hello, Greetings everyone... I want to copy data from one sheet to different sheet but only if a condition is true. For example, 1st Shee...

    fairooz | Excel | Latest reply: fairooz May 29, 2010
    5 replies
  • Label name protected Solved/Closed

    Hello, I was wondering if someone can help me. I want to know in this file at this address:

  • 5130c Forgot my Mbl memory card password Solved/Closed

    Hello, Im Using 5130c.... I forgot my password.... i Cant able to enter in My Memory Card plz tel hw to solve this problem.... Configurati...

    sha | Word | Latest reply: ash_perez01 May 29, 2010
    1 reply
  • Excel: Find & Offset Solved/Closed

    Hi can someone help me to get a macro code to make following: I have a file in which some cells having data as 10000, > 10000 and some others 10000...

    madambath | Excel | Latest reply: rizvisa1 May 28, 2010
    3 replies
  • Code for copying whole data in auto filter Solved/Closed

    Hello, Configuration: Windows 2003 / Internet Explorer 6.0 i am using excel 2007. i recorded a macro to copy segregate the data from data t...

  • Autofilter tp leave out #N/A in macro Solved/Closed

    Hello, I have a project id in column C , which iam checking from another source data which is there in a differenr tab .So ihave a vlookup fprmula...

    Lavanya | Excel | Latest reply: Lavanya May 28, 2010
    6 replies
  • Formula reads only till 12th on month Solved/Closed

    Hello, If I run the following formulae it gives the result only from 1st to 12 of the month. Is there any thing wrong with the formula or with my Ex...

  • Writing a macro Solved/Closed

    Hello, I am trying to get data whcih has been inoutted into one workksheet to copy into another worksheets when it meets a command in one of the c...

    Anna | Excel | Latest reply: rizvisa1 May 26, 2010
    28 replies
  • Excel, IF fuction with cell text values? Solved/Closed

    Hello, I would like to include the text value of a cell in the statement I have for one of the IF options. So far my formula is -: =IF((B1...

    jen | Excel | Latest reply: jen May 26, 2010
    2 replies
  • Deleting cells based on cell value of samerow Solved/Closed

    Hello, When I delete cell D4 (it's contents turn to ""), I would like cells C4, E4, F4, G4 to be deleted as well. The row must still exist, so on...

    Trowa | Excel | Latest reply: trowa May 25, 2010
    8 replies
  • IF Solved/Closed

    Hello, If A1 = 80 then B1 = 100 or if A1 = 50 then B1 = 90 both these formules are in the same cell, Thanks Configuration: Windows XP / Interne...

    Stormdronk | Office Software | Latest reply: Stormdronk May 25, 2010
    2 replies
  • List 2 columns into one Solved/Closed

    Hello, I hoping that someone can help me fix this. I have two columns with possible duplicate vendor name, example VendorName ...

    efek | Excel | Latest reply: venkat1926 May 24, 2010
    1 reply
  • Highlighting dates conditional formating Solved/Closed

    Hello, How to highlight dates in "EXCEL" i mean Less than Today = RED Today = YELLOW Greater than Today = Green Please help me i've been...

  • I need a formula for excel Solved/Closed

    Hello, Here is what I need and cant find anywhere: IF A12="text1 (anywhere in text)",then b2="text2" please help provide a formula that ca...

    Will Riker | Excel | Latest reply: rizvisa1 May 23, 2010
    1 reply
  • excel formula file linked Solved/Closed Their is a description on the file about what i am trying to do. besicly check one value to a list,...

    Scott | Excel | Latest reply: rizvisa1 May 22, 2010
    3 replies
  • Macro to compare and delete rows Solved/Closed

    Hello, I'm a new b when it comes to macros. I'm looking for the best way to compare data in 2 sheets. If data in column A matches on both sheets...

    Clare | Excel | Latest reply: Clare May 21, 2010
    2 replies
  • Calendar Control 10. Solved/Closed Please view the attached link to see what i would like done. Thanks Configuration: Windo...

  • problem formatting date Solved/Closed

    Hello, I'm trying to use "date" to format cells in Excel 2003. I've selected number>date>mm/dd/yy. So, for example I enter today's date as 05201...

  • Contract dates due to expire within 3 months Solved/Closed

    Hello, In Excel 2003, I have a list of all contracts with expiry dates. I need to add a colum entitled Due to run out in next 3 months. How do I ...

  • Macro to send email from Vlookup cell value Solved/Closed

    Hello, I am trying to create a macro that will among other things send an email to each address in a cell. The only problem is that the cell with ...

    KingTut | Excel | Latest reply: rizvisa1 May 19, 2010
    5 replies
  • Adding of the int values based on condition Solved/Closed

    Hello, I am trying to sort out a problem in excel file. I have some duplicate strings in column C and there are some integer values in column D. I...

  • Addition of the int values based on condition Solved/Closed

    Hello, I am trying to sort out a problem in excel file. I have some duplicate strings in column C and there are some integer values in column ...

  • Add up the values of duplicate cells Solved/Closed

    Hello, I am trying to sort out a problem in excel file. I have some duplicate strings in column C and there are some integer values in ...

    Sumit | Excel | Latest reply: rizvisa1 May 19, 2010
    2 replies
  • Column match Solved/Closed

    Hello, I have two columns in excel 2007. Both columns show menu items from another computer system. So, as an example different roles in our com...

  • Getting values from other xls file Solved/Closed

    Hello, I have 2 xls files (book1.xls and book2.xls). In book1.xls the first column (A1) has certain names in first 10 rows (say x1, x2, x3, x4, .....

  • micro sd memory card password is forget Solved/Closed

    Hello, i use NOKIA 3110c mobile. MY micro SD memory card password is forget. how can it find give me any solution. my id is : ...

    madhu | Word | Latest reply: madhu May 18, 2010
    2 replies
  • micro sd 1Gb password forget Solved/Closed

    Hello, . now i am using nokia 6085 mobile .. i forget my possword in micro sd 1 GB memory card.. plz tell me the solution what are the steps to fo...

    nagoor | Word | Latest reply: ash_perez01 May 18, 2010
    1 reply
  • Excel - Macro copy Date for "n" month Solved/Closed

    Hello, Would you please help me to create a macro for generate Date schedule to Sheet2 It just like an installment schedule. Sheet1 Col ...

    mama_tracy | Excel | Latest reply: rizvisa1 May 18, 2010
    3 replies
  • Lookup last name in a range Solved/Closed

    Hello, = LOOKUP(1E+30,Sheet3!E118:E141) I jused this formula to look up the last date of a range, but now want to change it to names but it won...

    StormDronk | Office Software | Latest reply: rizvisa1 May 17, 2010
    10 replies
  • Counting values in Multiple ComboBox's Solved/Closed

    Hello, I'm looking for some assistance with excel VBA, it would be great to gain your assistance. I've created a UserForm with 4 x ComboBox's, ...

  • What funtion/s should do I need Solved/Closed

    I'm working on tool for a user to input a qty of items, then calulate the number of cartons required. The cartons come in 1, 5 & 20 unit packs. ...

  • Multipul equations resulting in 1 answer? Solved/Closed

    Hi all, Recently I asked the question below: That solved the pr...


    Hello, please can you help on how the following works in excel. In excel 2007: If cell a1 are 1,2 or 3 then the current date displays in b2, or if da...

    StormDronk | Office Software | Latest reply: StormDronk May 16, 2010
    2 replies