Excel Forum - solved topics

Ask a question
Results 1601 - 1650 of about 1,710
  • Solved
  • 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 | Latest reply: Trowa Mar 9, 2010
    7 replies
  • 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 | 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 | Latest reply: rizvisa1 Mar 5, 2010
    12 replies
  • 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 | Latest reply: maggie Mar 4, 2010
    3 replies
  • 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 | Latest reply: AM14 Mar 2, 2010
    17 replies
  • 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 | 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 | 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 | Latest reply: Gouws Mar 1, 2010
    4 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 | Latest reply: hockey50 Feb 27, 2010
    13 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 | 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 | Latest reply: rizvisa1 Feb 25, 2010
    3 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 | 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 | Latest reply: zmarlz04 Feb 24, 2010
    5 replies
  • 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 | Latest reply: pleasehelp1101 Feb 22, 2010
    2 replies
  • 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 | Latest reply: rizvisa1 Feb 18, 2010
    1 reply
  • EXCEL HELP combining info from2 sheets Solved/Closed

    Hello, Hello, How can I match and combine records across two excel sheets. I have two excel sheets containing record information, about 6 columns f...

    Sassoon | Latest reply: coupen66 Feb 18, 2010
    2 replies
  • Excel If Function over a range of dates Solved/Closed

    Hello, Can anyone help please? I am trying to add a divisions column, which are taken from a date range in another column. i.e. I would like to add "...

    Olan | Latest reply: Useful Feb 16, 2010
    8 replies
  • Add cells, div by cells with value (Excel2007 Solved/Closed

    Hello,can any help!(excel 2007) A B C ...

    Gouws | Latest reply: rizvisa1 Feb 16, 2010
    1 reply
  • Excel Formula to show Zero Solved/Closed

    Hello, I'm using the formula =A2/(A2+A3) in A4, same in B to AF, i need the A4 line to show a zeros when A2-AF2 and A3-AF3 do not have values in. ...

    Gouws | Latest reply: Gouws Feb 15, 2010
    2 replies
  • compairing two columns A&B Solved/Closed

    Hello, column A column B 5000 4001 5001 4080 5002 4445 5003 4493 5004 4...

    suresh | Latest reply: rizvisa1 Feb 15, 2010
    1 reply
  • Excel formula converting time difference Solved/Closed

    Hello, i want to know the excel formula...below iam giving the details, In table A is my starting time e.g.10.49 and in table B is my reaching time...

    Mahesh | Latest reply: venkat1926 Feb 14, 2010
    1 reply
  • deleting alternae rows Solved/Closed

    Hello, I want to delete every alternate rows from my work sheet. I tried recording macro, but it only deletes a particular row as shown in macro bel...

    abthak | Latest reply: rizvisa1 Feb 14, 2010
    3 replies
  • Linking Spreadsheets Solved/Closed

    Hello, I'm trying to set up a cell that will draw information from another spreadsheet using excel 2007 The spreadsheet I'm pulling the info fro...

    Dohnutter | Latest reply: rizvisa1 Feb 13, 2010
    1 reply
  • Copy rows to total page Solved/Closed

    Hello, I have an Excel spreadsheet with 13 worksheets. The first 12 worksheets are January through December. The 13th worksheet is a total. Each...

    Tom | Latest reply: rizvisa1 Feb 12, 2010
    3 replies
  • Creating a directional macro Solved/Closed

    Hello, I am not familiar with writing macros at all. I created a form and I need a macro so that when I input data in a cell the cursor will automat...

    Teene12 | Latest reply: Teene12 Feb 12, 2010
    7 replies
  • Excel - delete rows when alike Solved/Closed

    Hello, I am in need of a formula to solve this problem. I want it to find similiar cells and delete those cells from the worksheet. Here is a sa...

    Amy | Latest reply: rizvisa1 Feb 11, 2010
    1 reply
  • How To Create Macro to Search, Copy, & Paste Solved/Closed

    Hello, Here's what I want to do. I have a worksheet with customer data by row and I also have a worksheet with an invoice I want to auto populate w...

    Paul | Latest reply: rizvisa1 Feb 10, 2010
    3 replies
  • comparison between two excel sheet Solved/Closed

    Hello, i have two excel sheet with same value which i need to compare every day .with in same excel sheet i can compare easyly using conditional form...

    dhiraj | Latest reply: tiffy Feb 10, 2010
    2 replies
  • Excell Solved/Closed

    Hello, I need a formula that will take the sum of a group of cells from a worksheet and apply them to a specific place on another worksheet. All i...

    Carrie | Latest reply: rizvisa1 Feb 9, 2010
    12 replies
  • help with interface/msgbox in vba Solved/Closed

    Hi, I'm in a VBA course and I'm having a lot of trouble with one of the problems: The settling velocity of a particle of liquid can be estimated us...

    jld902 | Latest reply: venkat1926 Feb 9, 2010
    3 replies
  • Excel: use if to find & change text in column Solved/Closed

    Hello, i want to search column "a" with numbers as text as follows: #305 #777 #78 #82 #884 i need a formula that will search column A an...

    dobeekioskea | Latest reply: venkat1926 Feb 9, 2010
    1 reply
  • Excel Macro Programming Solved/Closed

    Hello, It's been a while since I last wrote my own macro and I can't remember how to do this one up. I have a pull down list in excel, using data ...

    DinamoCalypso | Latest reply: venkat1926 Feb 8, 2010
    1 reply
  • macros excel 2004 problem Solved/Closed

    Hello, guys i please need help with this problem...i have macros that i use daily, i recently got a mac and i have mac office 2004, i try to copy and ...

    locomambo | Latest reply: rizvisa1 Feb 5, 2010
    3 replies
  • Macros to sort data with respect to the colum Solved/Closed

    Hello, I am facing a problem in sorting the data w.r.t to column header. I have 25 columns in which i need to sort the sata w.r.t to two of the col...

    Test | Latest reply: rizvisa1 Feb 5, 2010
    1 reply
  • Excel Macro to Scan document and combine rows Solved/Closed

    Hello, I'm trying to write a Macro that will combine text from several rows in a given column (column B in the example below) into one cell as long...

    dbono | Latest reply: rizvisa1 Feb 2, 2010
    6 replies
  • Values Lookup in excel Solved/Closed

    Hello, i want to match sheet2 with sheet1 WHERE sheet1 is the master sheet and has all columns. sheet2 has only two columns as in below demonstrat...

    seekermay | Latest reply: seekermay Feb 2, 2010
    2 replies
  • EXCEL 97 if then Solved/Closed

    Hello, I would like a Cell "1" to look at two Cells, Cell "2" and Cell "3" and depending on the answer enter a positive or negative vaue of Cell "4...

    Mike K | Latest reply: rizvisa1 Feb 2, 2010
    7 replies
  • Excel / after print +1 Solved/Closed

    Hello, My name is David (form Slovakia)! I would like to ask you for help with the folowing situation to solve: I need to prepear one document wh...

    Dark1500 | Latest reply: rizvisa1 Feb 2, 2010
    1 reply
  • EXCEL 2007 NO VALUE= NO COLOR Solved/Closed

    Hello, I've conditionally formated multiple cells to highlight green when the inputted date is within a 2 year period and red if it exceeds 2 years...

    out o' ideas | Latest reply: out o' ideas Feb 1, 2010
    2 replies
  • comparing cells and in multiple columns Solved/Closed

    Hello, I have two columns A and B A has items that have been priced B has items price (no dollar sign) Is it possible to have a macro go down co...

    Reza | Latest reply: rizvisa1 Feb 1, 2010
    1 reply
  • Excel Macro-Highlight if difference > or < 2 Solved/Closed

    Hello, I need help writing an Accounting excel macro I am working on. It appears that everything is working fine, except for one part I need some h...

    ksaw | Latest reply: venkat1926 Jan 30, 2010
    1 reply
  • Excel "IF" formula problem Solved/Closed

    Hello, I have a row of 4 cells each containing an "if formula" to get information from another worksheet. An example of the formula in these cells i...

    vongypsy | Latest reply: rizvisa1 Jan 29, 2010
    9 replies
  • Figuring percentages in Excel Solved/Closed

    Hello, we are doing a weight loss contest and trying to figure out a formula to do the math. We need a formula that will figure the cumulative pounds...

    mt | Latest reply: rizvisa1 Jan 29, 2010
    1 reply
  • Marco help! One macro for multiple row tasks Solved/Closed

    Hello, I have two separate workbooks that I need to compare. Task at hand is I have to find specific text in workbook 2 (col A) and once found - ...

    MadLady | Latest reply: rizvisa1 Jan 29, 2010
    1 reply
  • unique text formula question in excel Solved/Closed

    Hello, I have 2 columns of names in columns a & b and a list of dates in column c. Column A has a unique name in each cell. Column B had the same 5 o...

    verbatim | Latest reply: RIZVISA1 Jan 29, 2010
    1 reply
  • update dates in excel spreadsheet each year Solved/Closed

    Hello, i have 4 spreadsheets linked together which i use to keep track of my accounts. all 4 spreadsheets are in one folder. On each spreadshee...

    romeohotel | Latest reply: oclaf Jan 29, 2010
    4 replies
  • To add row after 24 rows and get the sum Solved/Closed

    Hello, I have hourly data of one year in rows without any break. I want to add row after 24 hrs and get the sum of all the coumns in that row. In oth...

    raja | Latest reply: RIZVISA1 Jan 29, 2010
    1 reply
  • delete all rows except first and last row Solved/Closed

    Hello, I have an excel file, I need to delete all rows in this file except for the first and second row. First Row = header row last row = contai...

    urgentMe | Latest reply: fairbud Jan 18, 2010
    2 replies
  • Excel Help Solved/Closed

    Dear All, I really need your support with my issue: I have around 70 tasks in Sheet1 some of them done with 100% (according to other numbers in th...

    Omoor | Latest reply: Omoor Jan 12, 2010
    2 replies
  • VBA Code that will find, copy and transpose Solved/Closed

    Hello, I'm looking all around for a VBA code that will: 1 - Search down one column for the word "ADDRESS" 2 - Once "ADDRESS" is found, I need t...

    siddharthariver | Latest reply: venkat1926 Jan 11, 2010
    1 reply