The discussions

Vba code in excel for 200 sheets

 Solved

Dear 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...

2 replies Last reply on 31 Jan 2012 by
Issa

Excel help

 Solved

Hello, 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] ...

10 replies Last reply on 30 Jan 2012 by
CQB

Excel

 Solved

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
RayH

Vba code in excel

 Solved

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
issa

Macro or vb in excel 2007

 Solved

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
pcsces

To get cell contents into excel file property

 Solved

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
venkat1926

Excel macro to insert row based on data

 Solved

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
Asa

Copy info from several cells into one cell

 Solved

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
ShkeT

Excel data reading from another excel shheet

 Solved

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
ger

How to compare several columns...?

 Solved

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
DG83

How to extract info from csv files to excel

 Solved

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
weenie

Paste to all sheets except some with criteria

 Solved

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
nzstorm

Formating a column using macro

 Solved

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
Kishore

Office 2010 excel

 Solved

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
john

Copying data from worksheet 1 to worksheet 2

 Solved

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
RWomanizer

Excel - delete info from a cell found in anot

 Solved

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
TrowaD

Cut &past data from sheet to shhet depending

 Solved

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
Sibsanne

Convert multiple rows and columns to one colu

 Solved

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
venkat1926

Color code excel cells according to scores

 Solved

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
venkat1926

Can i delete text up to a character in excel

 Solved

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
Mahek

Compare columns

 Solved

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
thomaswinter85

Excel-macro to group by column & sum value

 Solved

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
Joe

Data replication using macro

 Solved

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
rizvisa1

Notifications on excel

 Solved

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
jd

Unhide tab in excel

 Solved

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
rizvisa1

Macro for counting duplicates in raw

 Solved

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
rizvisa1

Match data from excell

 Solved

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
rizvisa1

Excel/vba2010-select cells between 2 keywords

 Solved

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
rizvisa1

Help with excel

 Solved

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
kittycat

Excel auto populate

 Solved

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
Jebin

Excel charts / graphs

 Solved

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
TrowaD

Cells display a total or text

 Solved

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
Michael

Excel transfer selected rows

 Solved

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
Julz

Excel data validation

 Solved

Hello, I have a master spreadsheet to collate data from spreadsheets filled in by my colleagues. Column b is 'Transaction Type' and I want to pro...

2 replies Last reply on 3 Nov 2011 by
Excel List

Vb excel 2010 - loop until can't find

 Solved

Hello, We are trying to manipulate data from a very old DOS program. We have a lengthy macro that works well until the end where it seaches for s...

25 replies Last reply on 26 Oct 2011 by
whitepanther

Excel: locate value in one list & copy

 Solved

Hello, I need some help with Exel. I have two lists: List one contains two coulmns: ID numbers and age. List two contains also two coulms: ID ...

3 replies Last reply on 26 Oct 2011 by
Brad

Data reshuffling of cells

 Solved

Hello, Dear Friends, I need your help to solve the following problem. I have few files containing data of more than 50,000 records. Some rec...

3 replies Last reply on 25 Oct 2011 by
Aslam

Excel macro copy to cell based on criteria

 Solved

hey everyone, I'm stuck. I hope someone can help me out today. I have an excel spreadsheet with 1400 rows. The first 3 rows are irrelevant (headi...

6 replies Last reply on 15 Oct 2011 by
rizvisa1

Excel vb script to notify/popup

 Solved

Hello, I want to have different cells in the worksheet have pop up messages/notifications when the date or deadline is reached. so when the 1 june 2...

12 replies Last reply on 15 Oct 2011 by
rizvisa1

Excel macro for deleting rows if cells not...

 Solved

Hello, I need help to create a Excel macro. Basicly what I have is a sheet full with information about different departments and what I want to do...

11 replies Last reply on 12 Oct 2011 by
Jo

Excel - select last 25 records

 Solved

Hi I have a spreadsheet that is entered into daily a list of actions taken in a department. This needs to be printed weekly and displayed. Obviously t...

1 reply Last reply on 10 Oct 2011 by
TrowaD

Excel - removing different rows in 2 sheets

 Solved

Hello, I have two worksheets containing a different number of rows. I want to delete all rows in sheet 1 that have a value in column A that c...

4 replies Last reply on 10 Oct 2011 by
venkat1926

Compare columns and copy

 Solved

Hello, I need a Macro to do next : i have 2 sheets Sheet1 and Sheet2. In Sheet1 column A has a variable range of values i.e. A2 : A... Column B is e...

2 replies Last reply on 9 Oct 2011 by
danparaianu

Creation of dropdown from dynamic list in vba

 Solved

Hello, I have been trying to make a Macro that can create a dropdown list from a dynamic list in column A. So far I've come up with the followin...

3 replies Last reply on 7 Oct 2011 by
Kasper

Avg multiple cells in multiple sheets - excel

 Solved

Hello, I need to average multiple cells across multiple sheets, but not all are in the same column/number. I need to average B35,D35,F35 in Sheet 1...

2 replies Last reply on 6 Oct 2011 by
FarmersDaughter1680

Macro to insert data to changing cells

 Solved

Hello, I'm trying to write a macro in excel for inserting input text to a specified cell. I have already an InputBox specifying the text to be put...

2 replies Last reply on 5 Oct 2011 by
Kasper

Excel merge text files

 Solved

Dear Forum Members, As I am not a VB expert I have copied some codes and edited to suit for my purpose. My idea is to combine many .pyc files in a f...

8 replies Last reply on 4 Oct 2011 by
madambath

Compare two excel columns of differant size

 Solved

Hello, i am having two excel columns of differant size..Both the columns contain mobile numbers..i have columns A containing all the mobile numbe...

6 replies Last reply on 30 Sep 2011 by
rizvisa1

Copy paste rows in excel across worksheets

 Solved

Hello, I'm trying to create an excel macro that will copy a sequence of rows from 2 different worksheets and paste them in a third worksheet using t...

3 replies Last reply on 28 Sep 2011 by
rizvisa1

Excel if formula text vs numbers

 Solved

Hello, I am trying to run an If formula that if the cell range contain text then use Counta but if cells contain number use Sum. At present I'm us...

2 replies Last reply on 25 Sep 2011 by
NW
Results 1201 - 1250 out of a total of 1,690