Hello, Im trying to add 2 amounts in one cell and have another amount subtracted from that total. for example Column A l Colum...
Hello, I have a 2 Columns of Data (A) and (B) that provides me with a specific range, and a third column C that provides a corresponding value f...
Good afternoon Folks. I need some help with a excel formula. I need the formula for finding the difference between two values and if the differen...
Hello, Kindly help in getting excel formula for following table: column1 Column2 A ABC A ABC A ...
Hello, Inser formula in cell F4 that multiplies the amount on E4 by the amount in D4. Configuration: Windows Vista / Internet Explorer 8.0
Hello all, I need help in formulating a spreadsheet. I have 10 columns, with data. I need to compare column 1 to column 10. But if column 10 is...
Hello, i need or recover my deleted excel file. by mistake i use shift delete.plz help me out. Configuration: Windows XP / Internet Exp...
Hello, I need a macro that combines multiple columns into one, but I'm terrible at creating macros! Essentially what I have is data that is sorted...
Hello, I am struggling with trying to figure out a macro to look through a selection of cells that have either numeric or text values, and I need ...
Hello mates, I purchased a new laptop there is office 2007 and it expired ,from where can i get a free key to reactivate it. Cheers
Hello, I want to color the whole row ,the foremat would be like this 1.75% (h) 1.75% (g,p) 3.25% (a,h) 3.25% (a) 4.38% (a) 4.38% (a) in t...
Hello, Please give me the macro or any other way to have cells merged on Microsoft Excel application, i really need it, please help me, its urgent...
Hello, I hope this is not confusing. I have a spreadsheet that in column C has list of workorder numbers. Some of the workorder numbers are repeated i...
Hello, I am trying to select a number of cells within a row - I want to use this in a macro. Whatever cell is currently active, I want to select c...
Hello, I have a large spreadsheet of contact info and am looking to extract only cells with the '@' symbol in them, as these will all be email add...
Hello, I need to do the following 1.I have assigned a Macro button called Submit in Sheet 1 - done 2.Copy Cells E5,E7,E9 from Sheet 1 to Cells B...
Hello, I'm having some trouble trying to figure something out. I have an Excell workbook with 2 worksheets. Each worksheet contains 2 columns ...
Hello, I am new to excel. I wan want to create a database list in Sheet1 and use the formula on Sheet2 onwards. What I want to creat in logic i...
Hello, I have a spreadsheet in which the date in a cell has a large amount of impact on what needs to happen with that current individual. What...
Hi guys I would like to create a simple list of the things I buy. I would like to have several inputboxes in which I can put the name of the pr...
Hello, I have 3 lists. A1:A500 contains names. B1:B500 contains dept codes associated with names in A1:A500 C1:C500 contains names of people wh...
Hello, I have two excel spreadsheets, both of which contain customer account information. I need to compare the two to find all accounts that are ...
Hello, I have the code below that only works for copying cells B2,B3,C3,E2,E4 from active sheet to the same identical cells on sheet2. Cells, B2,B...
Hello, Oh what a challenge this is turning into! In a nutshell i would like to lookup the description of a product in a cell, based on the product...
Hello, in a macro I have captured the date into a variable. I need to convert that date to a number format to used for further processing. thanks,
Hi all, Is there a way to compare the contents of a cell with a different cell using TRUE/FALSE results? For instance, cell A1 contains: Jr3 ...
Hello, How to merge cells in ex-cel-2003 by key board short cut key.
Hello, I have been using vba programming to make excel workbooks usable by those with visual disabilities. I need to make a button that can be se...
Hello, How can I copy numbers / names / etc from filter menu of excel sheet
Hello, Im trying to do a vba excel, how can i compare a Range of cell in worksheet A to worksheet B, whein if the condition is true it will upda...
Hi I need to create a formula in excel that will copy only values over 0 in column AH into new worksheet along with the corresponding text in colum...
Hello, I have a XLSX file of my products list, there are 3959 parts total. They go like this Column A 07 11 9 900 250 07 11 9 900 673 0...
Hello, Please help me. I stuck with excel formula. Need help....if two consecutive "y", the comment is "action". A B C Comment y y y - y ...
Hello, Document name: csg_na_event_table_D-2010-09-03.xls Tab/worksheet to be updated: csg_na_eventinfo Tab/worksheet that has data that needs t...
Hello, I would like a cell to contain the sum of one row, but if the second row has figures entered i would like it to show that; e.g. Q8 has 2...
I have a massive Excel Workbook with 200 tabs in it. One of the tabs references many of the other tabs in the workbook. I have been hunting and havi...
Hello, I am wanting to gather a number value already calculated in one excel spreadsheet and bring that number to another spreadsheet so I can use...
Hello, I'm trying to add the results of multple cells that contain count formulas to get a grand total of several lists of items. The lists are sepe...
Hello, In one sheet list of names will be there. While entering data in the second sheet data i would like to choose from drop list from sheet o...
Hello, I'm using Excel 2007. I have 2 spreadsheets. 1 of them has a list of about 9500 post codes(spreadsheet 1 for future reference), and the 2nd ...
Hello, I am trying to use macro to sort through a lot of data, choose a certain chunk, and copy and paste the chunk to a new file. I am able to cop...
Hello, i have excel sheet with more columns with applied more formulas. now i want to compare two columns values are equel or not, that rusult sho...
Hello, im writing in regards of how to formulate the IF function in excel to seperate out certain characters in a particular cell. For example if a...
Hello, Please I need some codes for this excel prob. Can anyone help me??? sheet 1 doc num accnt num 2000149110 1123 2000149110 1124 ...
Hi, One more scenario I have . If I have three columns in worksheet1 of file1(book1) and 1 column in worksheet2 of file2(book2), I should get only ...
Hi, I have been stuck with this problem for a bit. The problem is - I am sending this excel file to my customers to fill in the bare minimum inf...
Hello, I am trying to run the following code on multile sheets in a workbook. so far this code is working fine for one worksheet. Can someone help...
Hello, Configuration: Windows XP / Internet Explorer 6.0 I am using a spreadsheet where column A will have as part of the cell text string L3 o...
Hello, I would like to ask for help on how to go about writing a formula in Excel. I have a bank statement that is approx. 2500 to 3000 line i...
Hello, I have a column which lists the dates of certain activities in dd/mm/yy format. In the next column I would like the macro code in vba to re...