## The discussions

### Selection of rows based on conditions

Hello, I need some Excel 2003 macro experts' help: I have modified a code posted in this site to automate a process I have been doing for a while. It ...

1 reply Last reply on 17 Dec 2010 by
Helper

### Partial row match

Hello, I want to match the first 8 or so letters from the rest of the column and have a formula return a value (itself). Any idea on the formula...

3 replies Last reply on 17 Dec 2010 by
venkat1926

### Ms excel - matching and extracting data

Hello - I have an excel workbook (workbook 1) consisting of 4 sheets, each with approximately 400,000 rows of data. I have another workbook (workbook ...

1 reply Last reply on 16 Dec 2010 by
venkat1926

### If column d is after year 2010 quick question

If column D= year 2010 then column K = column E divided by 6 if column D is after year 2010 then column K =column E divided by 3. How would I ...

3 replies Last reply on 16 Dec 2010 by
venkat1926

### Excel - search column for condition

Hey Guys I would be very grateful for some assistance. I have a list of names (ie. John, Josh, Paul, Peter, Rick) i expect to be in a column ho...

1 reply Last reply on 15 Dec 2010 by
venkat1926

### Excel copy and paste

Solved

Hello, I have been given a list of 200 codes but they are in the wrong order. for example it goes 12378945610. so i want to swap the 456 and the 789...

5 replies Last reply on 15 Dec 2010 by
RayH

### Excel - check rows for data, copy to new

Solved

Heya folks! I've been reading the answers to similar questions and I plan to try and patch something together, but I thought I'd put a (more) specifi...

4 replies Last reply on 15 Dec 2010 by
Wayne

### Urgent help please in macro, vb

Hello, I'm a newbie in Excel Macro & VB, am an accountant I made new programe but I have a problem I need to copy row from sheet 1 to sheet 2 base...

1 reply Last reply on 15 Dec 2010 by
venkat1926

### Unlock password of kingston msd card 1 gb...

Solved

Hello, my 1 GB MSD CARD is locked due to password error, means I have forgot password. plz help me how to unlock it? Is it possible to unlock with...

3 replies Last reply on 15 Dec 2010 by
brianwhitt77

### How to get password

Hello, hello i am vaidyesh i have nokia 5310 express music mobile in my hand set i am using 2gb micro memory card now i forgot my password ple...

1 reply Last reply on 14 Dec 2010 by
pcsces

### Lookup or find in excel help

Solved

Hello, I have 2 data sheets sheet one contains my Master list of items by number Row 1 Column 1: 453658 Row 2 Column 1: 839565 Etc my secon...

2 replies Last reply on 14 Dec 2010 by
Paul

### Data frm one excel sheet to other excel sheet

Hello, I am trying to retrieve the data from one excel sheet to another excel sheet in separate work book. how can i do this one. Please help. C...

5 replies Last reply on 14 Dec 2010 by
manoj

### Ms excel, stripping out char(10) data

Solved

Hello, I working in Excel with VBA and have 5 or 6 rows of data located within 1 cell. The user has decided to use Alt-Enter whilst entering the da...

8 replies Last reply on 13 Dec 2010 by
Gene

hi i have forget my router password i want to recover it whith out .doing reset so how can i do that.thank u

1 reply Last reply on 13 Dec 2010 by
mijack

Solved

Hello, i have forgotten my previous security code,nd when iam trying to change it ,it neede my previous security code....plzz help me Configura...

1 reply Last reply on 13 Dec 2010 by
jack4rall

### If advance function

Solved

Hello, Ok here is the situation Data is 9:00 am 4:30 pm Now i want the If Formula to function , that if the range between 9:00 am to 4:3...

14 replies Last reply on 12 Dec 2010 by
sns

### Read a number in a cell and copy row n times

Hello experts, I will try to explain as good as i can my problem. I'm working in sheet 2, and my heading is 5 rows. I would like to find a code t...

1 reply Last reply on 12 Dec 2010 by
DidYouEvenSearch

### Hdi get my ppt/pps to open as a show

I saved my PowerPoiint files as a show and get a PPS file but it still opens in edit view. - How can get it to open in Slideshow view? Thanks in ad...

1 reply Last reply on 11 Dec 2010 by
GrnSpdr

### Apprpriate pdf reader for micromax x550

Hello, 1- I have Micromax Qube X550, and I m looking for Pdf software to read pdf files in my mobile. I tried several jar files regarding to it...

2 replies Last reply on 11 Dec 2010 by
vijay

### Conver to word e. rs.10/

Hello, Please give me the formula for Excel figer Conver to word E. Rs.10/- Convert to Ten Rupee. Regards P PATEL Configuration: Windows ...

1 reply Last reply on 11 Dec 2010 by
venkat1926

### Compare macro in excel

Hello, I am trying to create a macro in Excel 2003 that will compare data in Column A to Column B. The cells that are in column A and B will vary...

1 reply Last reply on 11 Dec 2010 by
venkat1926

### Your message did not reach some or all of the

Hello, I get the following message when trying to send emals using microsoft outlook 2007 please help Your message did not reach some or all of t...

1 reply Last reply on 10 Dec 2010 by
brianwhitt77

### Can ping but can't use browser in normal mode

Solved

Hello, I also have the problem where I was unable to connect to the internet via any browser, but I can ping my router. I noticed that turning off...

1 reply Last reply on 9 Dec 2010 by
Brain Drained ;-)

### Excel work sheet how to i open

Solved

Hello, When i am trying to open an exel sheet saved from windows 7 platforms, i am unable to open in windows xp plantform. the file that i was co...

2 replies Last reply on 9 Dec 2010 by
RayH

### Copy rows n times and then fill a series

Solved

Hello, This is variation of a question that has been answered previously. Does anybody know how I can repeat rows in a spreadsheet by n number of...

2 replies Last reply on 8 Dec 2010 by
Gaoyou60

### If then help

Hello, I am trying to create a function to do the following. If cell C2 contains an "S", then display "437" in E2 If cell C2 contains an "E", ...

4 replies Last reply on 8 Dec 2010 by
jwafa123

### Forgot my micro sd card password

hi. i had forgot my micro sd password. already read ur reply but also am not able to find the system folder in my handset. is there any other way...

4 replies Last reply on 8 Dec 2010 by
brianwhitt77

### Confused about if excel formula

HHello PLease can someone help me? I have a number in column D4 and a number in coulmn F4 If that number is equal or 10 more or ten less ...

3 replies Last reply on 8 Dec 2010 by
RayH

### Copying data between diff excel sheets

Hello, am working with multiple excel sheets for a daily sales entry, my first sheet would be on day sales entry, and my second sheet will be sales...

1 reply Last reply on 8 Dec 2010 by
Anne

### Memory detection and password problem

Hello, i have a memory card which i'm using it for a i pod i loaded some songs in it when i connect it to i pod songs cannot be played and after tha...

1 reply Last reply on 8 Dec 2010 by
Anne

### Copy xlcelltypevisible if blank

Hi, I have a workbook where I am FILTERing data then coping the visable range, after the headers D1 & D2) to another sheet with this macro Sheets...

2 replies Last reply on 7 Dec 2010 by
Tjones4852

### Dell inspiron mini password removal

Solved

Hello, i need help trying to unlock my dell inspiron mini. I get passed the hdd password by inserting all 0's. then it brings me to my account th...

1 reply Last reply on 7 Dec 2010 by
Ambucias

### Data should automatically get changed

Hello, My question is i want to paste sum added data on other excel sheet so that data automatically make changes when i make value change it aut...

1 reply Last reply on 7 Dec 2010 by

### How to do a search in excel? complicated

Hello, I've got a question, I just want to ask if anyone here know how to do a search in Excel but is a more complicated version. What I have is t...

1 reply Last reply on 6 Dec 2010 by

### Copy datas

Hello, I have an xl name A. There is around 10 sheets 1,2,3 respectively. I have to copy datas from these sheets to a single sheet "Main". How it ...

1 reply Last reply on 6 Dec 2010 by

### Vba for excel question

Hello, I have a worksheets in which I have a set of data in range A3:A50 and B3:B50 and C3:C50 and D3:D50 until J3:J50 that come from another worksh...

1 reply Last reply on 6 Dec 2010 by

### Formula for finding part of a word in a cell

Hello, I was wondering if there is a formula for finding part of a word in a excel cell. For example I have several manufacturers name in one cel...

1 reply Last reply on 6 Dec 2010 by

### Automate an email address from a name

Solved

Hello, I have a list of names, (first and sirname) in Cell A1. In cell A2 i would like excel to populate the email address by getting the name in ...

2 replies Last reply on 6 Dec 2010 by
Lil-Mogwai

### Urgently require code for attendance report

Hello, I get attendance sheet daily which contains shift timings, time and time out for each employee. I need to report absents, lates and early l...

1 reply Last reply on 6 Dec 2010 by
venkat1926

Solved

Hello, my handset is samsung sGH-M200, for the security i give the password but now i forgot it so please help me, what can i do to remove the pas...

1 reply Last reply on 4 Dec 2010 by
jack4rall

### Using > and < in excel

Hey, I am trying to apply a couple of options in Excel and i am having some trouble using IF & AND etc... Basically I have Cell C12, in which I ...

1 reply Last reply on 3 Dec 2010 by
RayH

### Emails not in deleted folder

Hello, The emails I delete are being permanently deleted instead of staying in my deleted folder. Please let me know any ideas you may have to fi...

1 reply Last reply on 3 Dec 2010 by
RayH

### Adding names from two cells

Hello, Column 1 Column2 Apple Seed Apple Tree Peach Seed Peach Seed Peach Tree Apple ...

1 reply Last reply on 3 Dec 2010 by
aquarelle

### Word opens when ever i download a file...

Hello, Whenever I download or click to open a PDF file on my computer, a blank word document opens instead. When clicking on the file, a box pops...

1 reply Last reply on 2 Dec 2010 by
Ambucias

Solved

Hello, i forget my 3110c security password how can i restore my mobile..rply please and thanks for any help. Configuration: Windows 7 / Firefo...

1 reply Last reply on 2 Dec 2010 by
pcsces

Solved

Hello, please ,we still need the password for DELL XPS M 1330. service tag: # 4qkl94j-595B Configuration: Windows XP / Internet Explorer...

1 reply Last reply on 1 Dec 2010 by
Ambucias

### Pie chart in excel

Solved

hi there im trying to make a pie chart in excel but i don't really know where to start...can someone help me thanx!

4 replies Last reply on 1 Dec 2010 by
yoman

### How to interchange the columns in notepad

Solved

Hello, I have data in three columns. I want to inter change the values of first two columns without changing the third one in notepad or in word p...

2 replies Last reply on 1 Dec 2010 by

### I forget my mobile password

Solved

Hello, i'm using micromaxx q5(fb). i forget my mobile pls tel me how to recitfy that Configuration: / Opera 9.80

1 reply Last reply on 30 Nov 2010 by
jack4rall

### Code to open external workbook

Hello, I have searched all over for this one and can't seem to find it... I am wanting to open a workbook if an age entry is below 12. I am trying...

1 reply Last reply on 30 Nov 2010 by