The discussions

Office 2010 isn't opening any files

 Solved

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
Jazz

Letter received and dispatch system

 Closed

i have to convert the manual system of letters received and dispatch records to computer system.The table structures are given below Receiving regi...

1 reply Last reply on 12 Jan 2012 by
pcsces

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

View 1st item in a drop down list.

Hi. I have a dropdown list with several items. When I click on the list the focus is always at the bottom rather than the top. Can you please tel...

1 reply Last reply on 8 Jan 2012 by
venkat1926

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

Sorting and creating a new file

 Closed

Hello, i wanted a macro which will sort my data based on a product name in a given column say for example column a and they sort all the rows wit...

1 reply Last reply on 8 Jan 2012 by
pcsces

Outlook email

 Closed

Hello, Outlook will only allow me to send an email to myself. When sending just a test email to anyone else i get this email from system administrator...

1 reply Last reply on 8 Jan 2012 by
pcsces

Compaq presario f700 startup password problem

 Closed

Hello, I got this,compaq presario f700 from my friend! I'm not sure where did he get it but that's not the problem now! When I turn it on, It appe...

1 reply Last reply on 7 Jan 2012 by
Ambucias

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 select only

Hello, this might be an easy one. If i have a long list of numbers and that list contains the same items, numbers whatever several times, how do i...

2 replies Last reply on 6 Jan 2012 by
DG83

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

How to remove a memory card pasword

Hello, how to remove a memory card pasword....please tell me how? Configuration: Windows XP / Opera 9.64

1 reply Last reply on 5 Jan 2012 by
pcsces

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

Copy entries in list based on a cell content

 Closed

Hello, in sheet1 i have a list of names in column b and cities in column c..now in sheet2, after entering the city in cell B1, i would like to cop...

1 reply Last reply on 4 Jan 2012 by
pcsces

How to split data in phone directories

Hello, Kindly advise how should i have the raw data below being seperated to format required? The raw datas are as below:- Zexcom Sdn Bhd ...

1 reply Last reply on 3 Jan 2012 by
venkat1926

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

I forgot the password of my memory card

Hello, i forgot the password of my memory card and i cant access my memory card anymore.. please help me.. my phone is nokia 5130c Configuratio...

1 reply Last reply on 2 Jan 2012 by
carliejean

Copy row if value in column l = unpaid

Hello, I am completely lost with using macros. I can't seem to find a beginners guide for using macros on a mac. I've read several threads that ...

1 reply Last reply on 2 Jan 2012 by
venkat1926

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

Unable to send from ms outlook 2010

Hello, I have any problem with my MS Outlook 2010. I could not send email but I could receive email. Everytimes, I click Send/Receive email always a...

1 reply Last reply on 2 Jan 2012 by
Ambucias

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

Search inside an array and return a row?

 Solved

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
venkat1926

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

Search for any value within a range and copy

 Solved

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
venkat1926

Micro sd card password

i forget my micro sd card password set by nokia 5250. So,memory card doesn't support in other mobiles.please help me

1 reply Last reply on 29 Dec 2011 by
bionik

Splitting similar values of column to 3 colum

Hello, I have a spreadsheet that lists employees, then it list one of three quarters, and then it list their ranking for that quarter. I need the...

2 replies Last reply on 28 Dec 2011 by
TS

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

Seach for value, select entire row, copy

Hello, I have one macro that will search for a specific range in a series of workbooks and copy that range to a new workbook, and another that will ...

1 reply Last reply on 27 Dec 2011 by
rizvisa1

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

Forgot password

 Solved

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
bionik

Compare and count

 Closed

Hello, I want compare the two text coloum and count them for example mumbai ok mumbai ok mumbai not ok delhi ok pune not ok bhopal ok I wa...

1 reply Last reply on 27 Dec 2011 by
pcsces

Plz help me reviving some deleted fb messages

Hi , i have deleted some important facebook messages accidentally... can i revive them? please help me. thanks and regards, rosie Configuration...

1 reply Last reply on 27 Dec 2011 by
ashu44

Automatically copy from one page to excel

Hello, I want to copy information from one sheet to another regarding the categories. For example if I have airline company name, aircraft type, ...

1 reply Last reply on 26 Dec 2011 by
venkat1926

I forgot my password

 Closed

Hello, I am babu from pondicherry...........i forgot my password its not opening nearly for 1 year please help me to know my security code?????? ...

1 reply Last reply on 26 Dec 2011 by
pcsces

Excell conditional formatting

Hello, I have been using conditional formatting to make a cell change colors if a)greater than or b)less than, today's date; however, I don't know...

1 reply Last reply on 25 Dec 2011 by
venkat1926

Problem in receiving same mail on 2 systems

Hello, i have created a outlook account on ms 2007 in two systems where both the systems ll receive same mails sent from outside. but the problem is o...

1 reply Last reply on 23 Dec 2011 by
Ambucias

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

Change cell color every 7 days

Hello, Is there any way to change a cell's color once a week on a certain day on a regular basis. Example, only on Wednesdays cell color changes to p...

6 replies Last reply on 22 Dec 2011 by
vertix
Results 5601 - 5650 out of a total of 12,249