The discussions

Excel comparision

 Solved

hello, can any one help me solve the following comparison problem.. a(reference data) b(raw data) c(status) ab ...

10 replies Last reply on 31 Jan 2012 by
Nitesh

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

Macro for deleting row with condition

 Closed

Hello, suppose I have one column in which there are 24 rows i.e. A1:A24 and these rows contain some value I need to make one macro in which I ...

8 replies Last reply on 29 Jan 2012 by
Maoharan Meghala

Delete rows that don't match another data set

Hello, Excel 2010. I have essentially two data sets. One is a dump from an analytics tool that contains about 8,500 rows of data with about 3 c...

1 reply Last reply on 28 Jan 2012 by
venkat1926

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 to copy row based on dates

 Closed

Hello, I have a spreadsheet that I am compiling for completed work orders. The sheet I want to copy the information from is called "Completed". In...

1 reply Last reply on 24 Jan 2012 by
pcsces

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

Compare 7 colums of data in 17 worksheets

Hello, I am a complete beginner with Excel, so please excuse me if this makes no sense !! I have made a spreadsheet for driving hours which add...

2 replies Last reply on 23 Jan 2012 by
noggsy

Excel 2003 color drop down menu limit of 3?

Hello, I am working of Excel 2003. I already created a drop down menu which has 6 items in it. When I get to the part about "Conditional Formatting"...

2 replies Last reply on 23 Jan 2012 by
Lone_Star_38

Macros

Hello, I want to create a VBA code which if can fiend in column "B" the value ICA to copy the row in another worksheet. EX A B C D 1 ICA 2...

1 reply Last reply on 22 Jan 2012 by
Jackie

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

Copying certain cells from one column

Hello, I want to copy certain cells depending on their value contents from a column into another column but follow their order. If some cells ar...

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

Excel 2010 using absoloute reference

Hello, Hello, I would really appreciate if you could help me out, I'm trying to copy a forumula using the $ absolute referencing. My column is...

1 reply Last reply on 19 Jan 2012 by
TrowaD

Excel 2003 color drop down menu limit of 3?

 Closed

Hello, I am working of Excel 2003. I already created a drop down menu which has 6 items in it. When I get to the part about "Conditional Formatt...

1 reply Last reply on 18 Jan 2012 by
pcsces

Using excel

Hello, I'm trying to find the necessary formula or formulas that will let me enter a single or double digit number into one cell, example C3, tha...

1 reply Last reply on 17 Jan 2012 by
TrowaD

Match different columns and return a value

 Closed

Hello, Hi Guys, I have a list which looks like this A B C 2 0 3 3 4 4 67 67 89 14 8 8 What i want to do here is match the tw...

1 reply Last reply on 16 Jan 2012 by
pcsces

Copy cell contents from worksheet function

Hello, I have a question re: Microsoft Excel 2007 :- I have a worksheet of raw data named 'raw'. I also have another worksheet named 'graphs...

1 reply Last reply on 16 Jan 2012 by
venkat1926

Sharing info between worksheets based on term

 Closed

Hello, Configuration: Windows Vista / Firefox 8.0.1 I have a master pipeline and in the Status column there will be terms such as "closed",...

1 reply Last reply on 15 Jan 2012 by
pcsces

Excel - how do i compare 2 columns 4 differnc

 Closed

Hello, I'm trying to figure out how to compare two columns (i.e. reports) in Excel 2007/2010, where one is a comprehensive report listing every em...

1 reply Last reply on 15 Jan 2012 by
pcsces

Querey-ms excel2010

 Closed

Hello, HI I have a work book which has few spreadsheets 1 spreadsheet name FC SECOND sheet name SV81 , third sheet name SV83 ,fourth sheet n...

1 reply Last reply on 15 Jan 2012 by
pcsces

Combining three different macros

Sir, I am a beginner in writing codes(macro's). With great difficulty i have written three different macro's to copy data from main sheet to thre...

14 replies Last reply on 15 Jan 2012 by
venkat1926

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 - matching and sorting

Hello, I have 2 spreadsheets, Spreadsheet 1 with names and contact information, and SS 2 with contact information and an ID number. Names are in C...

1 reply Last reply on 13 Jan 2012 by
venkat1926

Comparing columns and returning value

Hello, I have an spreadsheet where I want to compare values between two columns and return the value from the relating row in a third column. If A...

1 reply Last reply on 12 Jan 2012 by
venkat1926

Macro to find and copy cells

Hello, I have never wrote a macro using VB I normally just do simple ones step by step, could you please tell me how to do one that finds the cells ...

1 reply Last reply on 11 Jan 2012 by
venkat1926

Copy a row to another sheet with conditions

Hello, I am very new with coding in excel. I have a sheet called AFF with rows containing different information. If a cell in column Q is not e...

1 reply Last reply on 11 Jan 2012 by
Danielnowizard

Excel macro selecting column

 Closed

Hello, I need to select a specific column relative to the active cell in a macro. Specifically, regardless of the Active cell on a given row, I want...

2 replies Last reply on 10 Jan 2012 by
Carla

One column multiple rows (data in sets)

Hello, I'd be grateful for any suggestions... So what I have is gene A 1 2 3 4 gene B 1 2 3 4 and what I would like is gene...

4 replies Last reply on 9 Jan 2012 by
lkc

Macro help in excel copy pasting

Hello, I am trying to copy data from a excell spread sheet that is actually a set template i.e. Name:John Doe Age...

5 replies Last reply on 9 Jan 2012 by
Erwin VDB

Vba - compare two sheets

Hello everybody, I have two sheets: - sheet1 holding 3000 entries of all the guys - sheet2 holding the transferred guys i need a macro that...

4 replies Last reply on 8 Jan 2012 by
supereliseo

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

Using functions in excel, match, vlockup

Hello, I have two columns with numbers and i need to find the numbers in 1st column that apear in 2nd and vice versa. But my problem is next: when...

7 replies Last reply on 6 Jan 2012 by
viki

"">[no.]=true & ""<[no.]=false in excel ????

Hello, as the title says why excel treats same kind of formula in 2 different ways??? thanx

2 replies Last reply on 5 Jan 2012 by
mizan

Percentage formula for microsoft excel

 Closed

Hello, Im looking for help regarding a pricing sheet im trying to create on excel.I have my list of costs ok where im adding the totals in the cells ...

6 replies Last reply on 5 Jan 2012 by
KEGS

Identifiying data that does not match inexcel

 Closed

HI There, I have two columns in excel, I would like to verify that the information in Column A, is the same as in Column B, and if not I would lik to...

1 reply Last reply on 5 Jan 2012 by
pcsces

Lookup problem from excel 2007

 Closed

Hello, Just want to seek for assistance about my problem for lookup data.Actually i have data as per below. PO Items Qty 0001 a 2 0001 b 10 ...

1 reply Last reply on 3 Jan 2012 by
pcsces

Excel data extraction issue

Hello, I have the following issue with data extraction with Excel. I have a list of data (barcodes) dynamically populated - which means that ever...

3 replies Last reply on 2 Jan 2012 by
rizvisa1

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

Using macro for conditional formatting

Hello, Im in desperate need of help!!! I have an excel sheet with a list of employee number,rank,primary schedule, and secondary sched, years of e...

1 reply Last reply on 2 Jan 2012 by
venkat1926

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

Excel vba macro

The situation is: I have a about 15000 lines of data that needs to be cleansed. I need to change the Item description from e.g Uncleansed = OFFSET...

3 replies Last reply on 30 Dec 2011 by
Sam

Reg: excel query

Respected Sir/Madam, This is regarding a query that i have in MsEXCEL. I would like to know is there any formula or script so that i can get the...

1 reply Last reply on 30 Dec 2011 by
RayH

Transfer data to match on excel

I have two reports. One is from 2010, the other is from 2011. Within each report is the same information...account numbers, member names, credit sco...

2 replies Last reply on 29 Dec 2011 by
Dan

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

Excel vba user form

Hello, I am quite new to Excel VBA and I , desperately, need an expert help. am trying to create a user form that generates customer IDs made of 9 ...

1 reply Last reply on 27 Dec 2011 by
rizvisa1

Call an excel document to another sheet

Hello, Can any one suggest how to call a separate document(or) a Cell from one excel sheet to another excel sheet. For Example Book 1 got he...

1 reply Last reply on 27 Dec 2011 by
rizvisa1
Results 4401 - 4450 out of a total of 7,061