The discussions
Plz help- need sheetname for each row importd
Hi, 1st of all thanks for the earlier support, it really helped.. Now I am encountered problem in VBA codes, I want to import data rows from mu...
Using find within macro
SolvedHello, I have a list of first and last names of employees (Sheet1). Some of these employees have adjusted work schedules which are listed in a dif...
How can use opera mini browser in micromax q
Hello, How can use Opera Mini Browser in Micromax Q5fb Handset, who click in icon of Opera than Display Shoown Opera Mini Not Exists Configurat...
Excel: formula to choose if cell is correct
Hello, Anyone know what the formula is to return the value of the cell with no error. e.g. formula returns two results in cells A1 and A2 ...
Excel macro - to define number of rows
Hello, I am trying to copy the number of rows into different column in the same sheet ,i need to count the number of rows because when i recorded ...
Changing a cell's color based on other cells'
Hello, Please help! I have 5 columns on Excel (A1:E5). I have conditionally formated $A:$E the following conditions: 1. If the numerical value z...
Excel..condition based on drop down list
Hello, I've created a drop list (using the validation method). in excel 2003. What I wish to do... is create a condition where another cell ...
Excel vba help
SolvedHello, I am needing some help with this vba code. What I am trying to do is first verify if cell A4 is not empty, if it is not empty then I need it t...
Vba code to search and delete
Hello, I need to know the code to do the following: Search in column D for blank spaces and then delete the whole row. Thanks in advance ...
Copy rows from sheet 1 to sheet 2
SolvedI need to have a macro that will copy rows from sheet1 to sheet 2 . The catch is from sheet 1 col A for eg A3 may have the number 10 in it. I need to ...
Excel macro help to delete first cell
Hello, i required a macro coding to delete the first cell in the column. Eg: if i enter any value in cell C11 then automatically the Cell C1 va...
To prepare attendence report with excel sheet
Solved/ClosedHello, I will describe what I want to do . I have 60 residents working in our department. They attend morning report everyday. So I have prepared ...
Sort option gone on my excel spreadsheet
Hello, All of a sudden I no longer have a sort option on my excel spreadsheet. Configuration: Windows XP / Internet Explorer 8.0
Making autofiltered cells visible
Hello, I have filtered the column but the filtered data is not visible if i will do it manually then its working fine but if i want to automate i...
Excel- either or formula help!
Hi can someoine please help my dilemma is below; I am trying to get an invoice total which is either and addition of figures from 3 different cells...
Macro to expand data from pivot table til eof
I need help on expanding the data from my pivot table... My pivot table has only two columns, let's say column A & B with around 50 rows... Normally, ...
Question on excel database search
Hello, I'm familiar with the vlookup function in excel. However, it only allows you to compare one column in a table and return value from anothe...
Excel forumla/? help
Hi, I need some help figuring out a formula, or a way of calculating something. I have 2 excel workbooks. I need to figure out how to get a val...
Excel formula
Hello, can someone please help I need to get rid of the FALSE value in the formated cells. I know I am doing something wrong. Here is my formula: ...
If sum>= 60, color cells red
SolvedHello, I have excel 2007 and am trying to set conditional formatting for a series of 3 cells. If their total sum is greater than or equal to 60 I...
Match column b in both worksheets
Hello, I have 2 excel worksheets. I want to match column B in both worksheets. If there is a match, I want it to display "Yes" in a new column ...
Excel 2007 if/and formulas
Hello, I am struggling to put together an IF/AND statement and keeping coming up with errors. I am fairly Excel savvy, but this one is kicking my bu...
Macro for missing numbers
Hello, Please help me in finding out missing numbers location wise. Below numbers having different location numbers, request to help me with macr...
Need to add 2 amounts in one cell for excel
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
SolvedHello, 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
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
Hello, Kindly help in getting excel formula for following table: column1 Column2 A ABC A ABC A ...
Need help with multiplying formula in excel
SolvedHello, 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
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/ClosedHello, 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
SolvedHello, 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
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
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
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?
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
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
SolvedHello, 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 '@'?
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
SolvedHello, 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
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
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
SolvedHello, 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?
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
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
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
SolvedHello, 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
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
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
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
SolvedHello, How to merge cells in ex-cel-2003 by key board short cut key.
