The discussions
Vba code in excel for 200 sheets
SolvedDear all who can help me. I have salary excel file. This file includes 200 sheets which are for each employee. I have the following VBA code. P...
Copy row if a range of column matches a value
SolvedCould you please help me with the following macro. The following macro basically copies the entire row if the column B contains the value "1". But ...
Excel help
SolvedHello, If possible, can you help me in coding this: Collumn J will have the drop down menu of Open, In Progress, Complete [Open as default] ...
How to create a row list according with dates
SolvedHello, I'm trying to create a list of dates according with the time periods shown bellow on each row, i.e. for entry 1991001, I need to replicate ...
Excel
SolvedHello, 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...
Sunil dhyani
SolvedHello, 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...
Vba code in excel
SolvedDears 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...
Find data by entering data in another cell
SolvedHello, 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"...
Macro or vb in excel 2007
SolvedHi. 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...
To get cell contents into excel file property
SolvedHello, 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 ...
Excel macro to insert row based on data
SolvedHello, 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...
Copy info from several cells into one cell
SolvedHello, 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...
Office 2010 isn't opening any files
SolvedHello, 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...
Excel data reading from another excel shheet
SolvedDear People, I have a small Requirement in Excel. Can you please help me out? Problem Description: Content of Raw Material Prices are maintai...
How to compare several columns...?
SolvedHello, 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...
How to extract info from csv files to excel
SolvedHello, 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...
Search inside an array and return a row?
SolvedHello, 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...
Search for any value within a range and copy
SolvedHello, 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...
Paste to all sheets except some with criteria
SolvedHi, 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 ...
Formating a column using macro
SolvedSir 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...
Forgot password
SolvedHello, sir i have nokia2690 mobile the security code was changed onetime but the new password is forgot so please help me. Configuration: / Ope...
Office 2010 excel
SolvedHello, 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 ...
Copying data from worksheet 1 to worksheet 2
SolvedHello, 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...
Excel - delete info from a cell found in anot
SolvedHello, Hello, I need a solution for the following situation: See attached screenshot from my Excel spreadsheet. I would like to know if the...
Cut &past data from sheet to shhet depending
SolvedDears, 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...
Convert multiple rows and columns to one colu
SolvedHello, 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,...
Color code excel cells according to scores
SolvedHello, 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....
Can i delete text up to a character in excel
SolvedHello, 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...
Excel-macro to group by column & sum value
SolvedI 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 ...
Calculate each number is 1st time happen
SolvedHello, 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 ...
Data replication using macro
SolvedHello Experts, I have a requirement as follows: User data Entry: Column1 Column2 Column3 Colulmn4 TIME JAN FEB MAR INDIA Bangal...
Saturday as workday
SolvedHello, How do I get excel 2003 to include saturday as a weekday? I can't get workday or networkdays to include it.
How to select signature for outlook mail
SolvedHello, 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...
Copy cell with more than 921 charcters
SolvedHello, 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...
Notifications on excel
SolvedHello, 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...
Unhide tab in excel
SolvedHello, 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 ...
Macro for counting duplicates in raw
SolvedHello, 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 ...
Match data from excell
SolvedHello, 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: ...
Excel/vba2010-select cells between 2 keywords
SolvedHi 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...
Help with excel
SolvedHello, 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...
If statements
SolvedHello, I'm trying to create an "if statement" that will allow for the following scenario: B5
Help for the sku001.cab
SolvedHello, 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...
Key 25
SolvedHello, 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...
Excel auto populate
SolvedHello, 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...
Excel charts / graphs
SolvedHello, 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 , ...
Copy/paste formula to variable # of data
SolvedHello, 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...
Phonelock forgot the password
Solved/ClosedHello, how am I going to open again my phonelock ?? I have forgotten my password . please help . cherry mobile c2 Configuration: Windows 7 / ...
Sorting and extracting data...
SolvedHello, 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"....
If function
SolvedHello, 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...
