Excel Forum
-
need to add 2 amounts in one cell for excel [Closed]
Hello, Im trying to add 2 amounts in one cell and have another amount subtracted from that total. for example Column A l Colum...
-
Find Value Between 2 column Range Excel Macro [Solved/Closed]
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...
-
Need Help with an Excel Formula [Closed]
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...
-
formula for searching names from two columns [Closed]
Hello, Kindly help in getting excel formula for following table: column1 Column2 A ABC A ABC A ...
-
Need help with multiplying formula in excel [Solved/Closed]
Hello, Inser formula in cell F4 that multiplies the amount on E4 by the amount in D4. Configuration: Windows Vista / Internet Explorer 8.0
-
Need help with Excel [Closed]
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...
-
recover my deleted excel file [Solved/Closed]
Hello, i need or recover my deleted excel file. by mistake i use shift delete.plz help me out. Configuration: Windows XP / Internet Exp...
-
Excel Macro - Multiple Columns Into One [Solved/Closed]
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...
-
Delete Only The Rows with Numeric Value MACRO [Closed]
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 ...
-
excel key [Closed]
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
-
Macro Row coulour [Closed]
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...
-
How to merge cells? [Closed]
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...
-
Change Excel Line Color [Closed]
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...
-
Select a subset of cells within a row [Solved/Closed]
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...
-
Can excel search for only cells with '@'? [Closed]
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...
-
Copy to cell below the last entry in Sheet 2 [Solved/Closed]
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...
-
Excel Compare 2 columns in 2 different sheets [Closed]
Hello, I'm having some trouble trying to figure something out. I have an Excell workbook with 2 worksheets. Each worksheet contains 2 columns ...
-
Excel Formula Question [Closed]
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...
-
Highlighting rows by date [Solved/Closed]
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...
-
Inputbox in excel - how to? [Closed]
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...
-
Compare lists in Excel [Closed]
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...
-
Need Help Comparing Data in Two Spreadsheets [Closed]
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 ...
-
Copy non-contiguous cells to another sheet [Solved/Closed]
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...
-
Excel lookup latest in list [Closed]
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...
-
date to number format using macro [Closed]
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,
-
Excel Help needed: comparing cell contents [Closed]
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 ...
-
office -2003 short cut keys in excel [Solved/Closed]
Hello, How to merge cells in ex-cel-2003 by key board short cut key.
-
Selecting Excel Button Using Arrows [Closed]
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...
-
Copy nos from filter menu of excel sheet [Closed]
Hello, How can I copy numbers / names / etc from filter menu of excel sheet
-
Two work sheets cell comparison.. [Closed]
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...
-
Excel Formula/Function Help [Closed]
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...
-
Autofill macro or anythin tht could help..... [Closed]
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...
-
Compare 3 columns [Closed]
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 ...
-
Updating one worksheet using data from anothe [Closed]
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...
-
excel spreadsheet [Closed]
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...
-
Create a list of Referenced Worksheets [Closed]
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...
-
Calculations using two seperate spreadsheets [Solved/Closed]
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...
-
Adding the results of cells w/count formulas [Closed]
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...
-
Excel droplist [Closed]
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...
-
Comparing data on 2 spredsheets [Closed]
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 ...
-
Excel Macro deleting unwanted info [Closed]
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...
-
how to compare two columns. [Closed]
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...
-
Wild card functions for IF function in Excel [Closed]
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...
-
Macro insert into another sheet [Closed]
Hello, Please I need some codes for this excel prob. Can anyone help me??? sheet 1 doc num accnt num 2000149110 1123 2000149110 1124 ...
-
Comparing two excelfile worksheets [Closed]
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 ...
-
Excel 2007 - Generate and Excel from Another [Closed]
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...
-
Run Same VBA Macro Code On Multiple Sheets [Closed]
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...
-
Excel Help [Closed]
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...
-
Excel formulas [Closed]
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...
-
Changing Dates into a Month on VBA [Closed]
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...
Subscribe To Our Newsletter!
