Excel Forum - solved topics

Ask a question
Results 1501 - 1550 of about 1,710
  • 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 | 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 | 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 | 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 | Latest reply: G Jun 7, 2010
    4 replies
  • 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 | 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 | Latest reply: rizvisa1 Jun 5, 2010
    3 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 | 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 | Latest reply: KJFin Jun 3, 2010
    2 replies
  • 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 | Latest reply: jrog Jun 1, 2010
    3 replies
  • 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 | 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 | Latest reply: fairooz May 29, 2010
    5 replies
  • 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 | Latest reply: rizvisa1 May 28, 2010
    3 replies
  • 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 | Latest reply: Lavanya May 28, 2010
    6 replies
  • 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 | 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 | 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 | Latest reply: trowa May 25, 2010
    8 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 | Latest reply: venkat1926 May 24, 2010
    1 reply
  • 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 | Latest reply: rizvisa1 May 23, 2010
    1 reply
  • excel formula file linked Solved/Closed

    http://wikisend.com/download/466894/Check1.xlsx Their is a description on the file about what i am trying to do. besicly check one value to a list,...

    Scott | 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 | Latest reply: Clare May 21, 2010
    2 replies
  • 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 | Latest reply: rizvisa1 May 19, 2010
    5 replies
  • 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 | Latest reply: rizvisa1 May 19, 2010
    2 replies
  • 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 | Latest reply: rizvisa1 May 18, 2010
    3 replies
  • 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 | 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 | 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 | 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 | 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 | 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 | 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 | Latest reply: rizvisa1 May 11, 2010
    3 replies
  • 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 | Latest reply: armatt May 11, 2010
    2 replies
  • 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 | 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 | 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 | Latest reply: rizvisa1 May 10, 2010
    13 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 | Latest reply: madambath May 9, 2010
    13 replies
  • 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 | 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 | Latest reply: andy May 7, 2010
    9 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 | Latest reply: DCecil07 May 7, 2010
    4 replies

    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 | Latest reply: rizvisa1 May 6, 2010
    1 reply
  • 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 | 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 | 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 | Latest reply: rizvisa1 May 6, 2010
    1 reply
  • 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 | Latest reply: xcel May 5, 2010
    2 replies
  • 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 | 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 | 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 | 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 | 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 | 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 | 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 | Latest reply: DCP Apr 28, 2010
    2 replies