The discussions



Hello, My name is amit and i am having problem with creating a excel sheet which has three columns stating date , service and amount. and now i wan...

1 reply Last reply on 26 Jan 2012 by

Sunil dhyani


Hello, I have a problem, how to delete entire column from the sheet that contain particular word with other word as a header. Example i want to de...

1 reply Last reply on 24 Jan 2012 by

Vba code in excel


Dears who can help me to write VBA code to solve the following case: I have Excel sheet to calculate overtime, includes several rows for each month...

2 replies Last reply on 24 Jan 2012 by

Find data by entering data in another cell


Hello, I have an Excel 2007 Workbook that I use for tracking the status of over 50 projects. This Workbook contains 6 worksheets plus a "MainMenu"...

6 replies Last reply on 22 Jan 2012 by

Macro or vb in excel 2007


Hi. I have next to no experience with macros & VB. But I have a problem that I need resolved. I have 11 sheets in excel. 10 sheets need to pull in...

2 replies Last reply on 22 Jan 2012 by

To get cell contents into excel file property


Hello, Can you please kindly help me to solve the below interesting issue? (I will make my best to make myself understood, which is sometimes very ...

1 reply Last reply on 21 Jan 2012 by

Excel macro to insert row based on data


Hello, I have a large spreadsheet w/ over 9,000 rows of data. I would like to know if a macro can be built to add a row(s) based on the month. In t...

4 replies Last reply on 19 Jan 2012 by

Copy info from several cells into one cell


Hello, Could you please help me solve my issue bellow? I have several sheets in Excel, i.e. Sheet 1, Sheet 2 and Sheet 3. I wanted that A1 cell from...

4 replies Last reply on 14 Jan 2012 by

Office 2010 isn't opening any files


Hello, I've downloaded office 2010 - and it's not opening any files form box unless I select 'open with' for each file. I want an automatic downlo...

2 replies Last reply on 12 Jan 2012 by

Excel data reading from another excel shheet


Dear People, I have a small Requirement in Excel. Can you please help me out? Problem Description: Content of Raw Material Prices are maintai...

15 replies Last reply on 6 Jan 2012 by

How to compare several columns...?


Hello, could anyone help me with this. I would like to compare two columns: A B C D Peter 4 John 3 John 3 Peter 5 G...

4 replies Last reply on 2 Jan 2012 by

How to extract info from csv files to excel


Hello, I have 74,340 .csv files I need to extract information from Col. A-C & Rows 1-143 into an excel workbook, Sheet1. Every .csv file has diffe...

5 replies Last reply on 1 Jan 2012 by

Search inside an array and return a row?


Hello, I have a spreadsheet of data, and I'd like to create a macro where I can input a name (from within the unique names listed in column A for exam...

5 replies Last reply on 29 Dec 2011 by

Search for any value within a range and copy


Hello, I am a beginner with Macros and would like to find code that will allow me to do the following: 1. Look for ANY values present in colu...

9 replies Last reply on 29 Dec 2011 by

Paste to all sheets except some with criteria


Hi, How can I make a macro paste copied data into some sheets of a worksheet but not other sheets. For example, I have 10 sheets in my worksheet ...

2 replies Last reply on 28 Dec 2011 by

Formating a column using macro


Sir A forum member helped me in writing a macro to copy certain data from sheet one to sheet two. I modified basic macro to suit as per my require...

2 replies Last reply on 27 Dec 2011 by

Forgot password


Hello, sir i have nokia2690 mobile the security code was changed onetime but the new password is forgot so please help me. Configuration: / Ope...

1 reply Last reply on 27 Dec 2011 by

Office 2010 excel


Hello, i am trying to show in cell J2 if the sum of cell I2 is more than 10 to show 10 and if the sum is les than 5 to show 0 have found how to show ...

2 replies Last reply on 22 Dec 2011 by

Copying data from worksheet 1 to worksheet 2


Hello, I am using MS Office Excel 2007 and need to know how to copy a row of data from one worksheet to another worksheet using a criteria from colum...

2 replies Last reply on 22 Dec 2011 by

Excel - delete info from a cell found in anot


Hello, Hello, I need a solution for the following situation: See attached screenshot from my Excel spreadsheet. I would like to know if the...

5 replies Last reply on 20 Dec 2011 by

Cut &past data from sheet to shhet depending


Dears, I'm a novice in M* Excel. Still, for day to day followup purpose, I need a macro and/or appropriate solution that does the following: For...

13 replies Last reply on 20 Dec 2011 by

Convert multiple rows and columns to one colu


Hello, I have some data in excel sheet. Here is the example. 480,000 600,000 720,000 520,000 650,000 780,000 300,000 375,...

5 replies Last reply on 14 Dec 2011 by

Color code excel cells according to scores


Hello, How do I color code cells in excel ti turn colors according to scores--such as red (0-69%), yellow 70-89%), green 90-100%)? Thank you, E....

1 reply Last reply on 13 Dec 2011 by

Can i delete text up to a character in excel


Hello, Is there a way of deleting all the text up to a certain character in excel. i im trying to import a CSV file in to exchange and need it tyding...

4 replies Last reply on 13 Dec 2011 by

Compare columns


Hello, I have a situation like below. Column A Column B Column C A1 1 A2 ...

5 replies Last reply on 12 Dec 2011 by

Excel-macro to group by column & sum value


I was searching your web site for an example of how to group two columns and sum two different columns. I found an example under the question "Excel ...

2 replies Last reply on 10 Dec 2011 by

Calculate each number is 1st time happen


Hello, Pls do help me.. By using what method ( Auto calclulate ) that can help us to find out each number is first time happen ? Eg: Cut Apple ...

8 replies Last reply on 9 Dec 2011 by

Data replication using macro


Hello Experts, I have a requirement as follows: User data Entry: Column1 Column2 Column3 Colulmn4 TIME JAN FEB MAR INDIA Bangal...

3 replies Last reply on 8 Dec 2011 by

Saturday as workday


Hello, How do I get excel 2003 to include saturday as a weekday? I can't get workday or networkdays to include it.

2 replies Last reply on 8 Dec 2011 by

How to select signature for outlook mail


Hello, I am trying to select signature (by browsing for a signature file) to new mail in outlook-2003 using with XP but unable to selct it. Please i...

4 replies Last reply on 7 Dec 2011 by

Copy cell with more than 921 charcters


Hello, I wrote a vb code to copy all rows where column B contains "RW". The code first deletes any data that the sheet might already have. Followi...

4 replies Last reply on 5 Dec 2011 by

Notifications on excel


Hello, I would need your help to create a notification on excel. I've got a row of date's and when the date is 90 days prior to the expiry dat...

5 replies Last reply on 1 Dec 2011 by

Unhide tab in excel


Hello, I have a cell in excel that is either true or false. Based on that then it is linked to a check box. When ever I type the word "True" it ...

1 reply Last reply on 1 Dec 2011 by

Macro for counting duplicates in raw


Hello, I apologize in advance if even my search efforts have not found an answer to my question, believe me I've tried. Ok, I need ...

4 replies Last reply on 30 Nov 2011 by

Match data from excell


Hello, I have information in different spreadshits which I would like to match by the name and year of a company. How can I do that? Example: ...

1 reply Last reply on 30 Nov 2011 by

Excel/vba2010-select cells between 2 keywords


Hi guys, Here's a tricky one. I'm trying to write a macro that starts from the active cell - goes up the column selecting say 20 cells and searches...

27 replies Last reply on 30 Nov 2011 by

Help with excel


Hello, does anyone kno of a formula that will automatically input the next month. for example if I am starting with 10/28/2011 what is the formu...

2 replies Last reply on 29 Nov 2011 by

If statements


Hello, I'm trying to create an "if statement" that will allow for the following scenario: B5

1 reply Last reply on 28 Nov 2011 by

Help for the


Hello, I got a message when i was open the Microsoft Excel i got SKU011.CAB error i want to know how i get this error solutions Thanks Sh...

1 reply Last reply on 26 Nov 2011 by
Anonymous User

Key 25


Hello, i have a laptop hp pavilion g6, i am a student so i want to work on microsoft office, we ask me to enter a product key, so i don't how do i d...

1 reply Last reply on 25 Nov 2011 by
Anonymous User

Excel auto populate


Hello, I've created a drop down list as B, I and A. on one sheet I need it to calculate the count automatically. The next sheet has coulmns sa...

2 replies Last reply on 22 Nov 2011 by

Excel charts / graphs


Hello, I need your help with regards to creating a chart on a different sheet in the same workbook. I've got employee names on top as a row , ...

3 replies Last reply on 21 Nov 2011 by

Copy/paste formula to variable # of data


Hello, I'm recording a macro where I have data in Col A (it's variable, it can be 5K rows one month, 6K rows another month). I want to copy a for...

2 replies Last reply on 20 Nov 2011 by

Phonelock forgot the password


Hello, how am I going to open again my phonelock ?? I have forgotten my password . please help . cherry mobile c2 Configuration: Windows 7 / ...

2 replies Last reply on 18 Nov 2011 by

Sorting and extracting data...


Hello, I need to extract the data from from the cells of Column "B" and placed it into cells of Columns "E" by comparing Column"A" and Column"D"....

10 replies Last reply on 16 Nov 2011 by

If function


Hello, I am just starting out with formulas and I need some help. What I need is: If the value in Sheet 1 B2 is found anywhere in Sheet 2 colum...

2 replies Last reply on 14 Nov 2011 by

Cells display a total or text


Hello, I have an excel workbook that has cells that display a currency amount U43, U45, U47, U49, U51 and Q53. For example U43 would have $200 in...

2 replies Last reply on 11 Nov 2011 by

Outlook 2007 email randomly not sent


Hello, the problem started a few days ago. Randomly Outlook 2007 does not send a message. Looks like it is mostly when I reply to another email. I...

3 replies Last reply on 10 Nov 2011 by

Conditional format more then 3


Hello, I have seen a solution on your web from aquarelle, but how do i put that in my excel, sorry maybe its a basic question. But i have tried i...

2 replies Last reply on 10 Nov 2011 by

Excel transfer selected rows


Hello, I have in place a data validation,''list''. I want to be able to transfer selected rows with the different list names into separate worksh...

12 replies Last reply on 8 Nov 2011 by
Results 1501 - 1550 out of a total of 2,599