The discussions

Find value between characters in one cell

 Solved

Hello, I get this report-list of personal information, in text format (TXT) Each area is separated by | Name|Experience|Age|Sex|Location|Contac...

2 replies Last reply on 5 May 2011 by
CyberPath

Macros help

 Solved

Dear Friend i want to convert number to text in excel programme Example : ( 055555 : Zero five Five Five Five Five ) As This Format ...

4 replies Last reply on 5 May 2011 by
suryam

Transfering data to a new sheet

 Solved

I'm running excel 2007 on windows 7, if that's important. I'm trying to find a way to transfer data from a master sheet (or basically sheet 1) to...

3 replies Last reply on 4 May 2011 by
Stickihasit

Format data in excel for db transaction

 Solved

Hello, I have a simple question, I have a range of cells with numbers in each cell. I want to add a single quote or apostrophe in the start and end...

3 replies Last reply on 4 May 2011 by
holly

Formula for every 200hrs cycle

 Solved

Hello, now i'm trying to do a schedule maintenance for one part.the hours for the parts will increase everyday.e.g today 240 hrs,tomorrow 256 hrs....

1 reply Last reply on 3 May 2011 by
RWomanizer

Getting prompt-name list while entering data

 Solved

Hello, I have a new question now. I will have traveller /passenger names who travel frequently (or having travelled atleast once by buying tickets...

2 replies Last reply on 2 May 2011 by
suryam

My tally is not opened

 Solved

Hello, click the tally icon it shows problem with shortcut, the item tally9.exe that this shortcut refers to has been changed or moved, so this sh...

1 reply Last reply on 2 May 2011 by
TrowaD

Find a word in excel

 Solved

Hello, I have set up a spreadsheet to keep track of my daily workouts. The spread sheet is set up as follows: Column A: Date Column B: Descrip...

7 replies Last reply on 2 May 2011 by
TrowaD

Excel macro to copy text and append

 Solved

Hello, I recorded a macro in Excel where I copied the text from one cell and appended that text to the values in several other cells. The problem...

4 replies Last reply on 2 May 2011 by
RWomanizer

Cell reference to locate /store data in excel

 Solved

Hello, Hello , I am working for a newly started airline agency. I am enclosing my working file (for privacy sake , I have changed names and oth...

8 replies Last reply on 2 May 2011 by
suryam

Emailing selected cell range using outlook

 Solved

Hello, Hi, I have one task. I need to email some of my invoices that I prepare on a daily basis. I have a .xls file with some work sheets. I have ...

7 replies Last reply on 2 May 2011 by
RWomanizer

Comparing two ranges of numbers

 Solved

Hello Everyone, Let me first say I'm very much an amateur with VBA code, but I have been using examples I have seen online to cobble together ...

5 replies Last reply on 2 May 2011 by
RWomanizer

Excel macro help

 Solved

Hi there, I am getting an error when I try and run the following macro. I am trying to find the value in one worksheet (final) in another worksheet ...

1 reply Last reply on 29 Apr 2011 by
venkat1926

Auto incrementing alphanumeric cell by 1

 Solved

Hello, I have an alpha numeric cell in excel sheet. for example IND/APR/6734/INV I am using it to give number to the invoce that I generate everyda...

4 replies Last reply on 29 Apr 2011 by
suryam

Lost windows password fix gone bad.

 Solved

Hello, My buddy changed his password on his computer. He forgot said password and tried all day to log in. He asked me for help and I found a progra...

6 replies Last reply on 28 Apr 2011 by
Ambucias

Old toshiba 3480ct admin password

 Solved

Hey guys, I have an old Toshiba Portégé 3480CT and need to get past the admin password. I have no idea who would know it, it's been in our office ...

1 reply Last reply on 28 Apr 2011 by
bionik

Add/remove month button for chart.

 Solved

Hello, My chart receives data from columns. Each column is a month. Now I want to create two buttons: First button to add a month and another...

18 replies Last reply on 26 Apr 2011 by
RayH

Delete allowediteranges by vba

 Solved

Dear All, Can some-body help me to correct the following code: Private Sub CommandButton1_Click() Dim WS As Worksheet Dim aer As AllowEditRang...

3 replies Last reply on 26 Apr 2011 by
Issa

Delete allowediterange by vba command

 Solved

Dear All, Can anyone help me to correct the following code: Private Sub CommandButton1_Click() Dim WS As Worksheet Dim aer As AllowEditRange...

2 replies Last reply on 26 Apr 2011 by
Celina

Excel conditional formatting rows to columns

 Solved

Hello, I have a data set that looks like: A B 1 20 2 21 3 21 4 03 1 19 2 34 3 23 4 25 1 23 2...

2 replies Last reply on 25 Apr 2011 by
em

Help about macro copy and paste

 Solved

Hello, Just want to seek help to anyone about my problem about copying and paste multple raw and column thru new sheet also with designated raw an...

3 replies Last reply on 20 Apr 2011 by
venkat1926

Copy to first open cell in rowb/sheet 2

 Solved

Hello, Thanks for trying to help! I have a sheet as shown below. We do sales every day and would like the values/ estimates and sales that have...

6 replies Last reply on 20 Apr 2011 by
Stormdronk

Vba - how to replicate the value n times

 Solved

Hello, I have to write in VBA a macro that allows to replicate value n times (input). Let's say, I have a list one two three and I have to re...

5 replies Last reply on 18 Apr 2011 by
gradelle

Help required in ms excel

 Solved

Hello, I have a list of text strings in rows separated by blank rows. For example: Row 1: Name of the publication Row 2: Authors Row 3: Organiz...

7 replies Last reply on 16 Apr 2011 by
eskagsms

Check value in a cell vs mid value in another

 Solved

Hello, I have months in column A in number format. Single digit for the first nine months and double digit for the last 3 months. In column B, I...

1 reply Last reply on 15 Apr 2011 by
TrowaD

How to compare columns of 2 different excel

 Solved

I want to compare column named employeeid in two different EXcel sheets and have to retrive the rows with same employeeid ex: sheet1 emp name ...

3 replies Last reply on 15 Apr 2011 by
RWomanizer

Excel if then, create a new column

 Solved

Hello, I'm trying to write a VBA code, because I have too many factors to create a nested function. I can do it fine if there were less than 7 variab...

7 replies Last reply on 14 Apr 2011 by
RWomanizer

Vba to protect sheets & keep some options on

 Solved

Dears, I will be very grateful if some one can help me. I have excel file include 50 sheets, so I made one sheet that include all the basis info fo...

2 replies Last reply on 13 Apr 2011 by
Issa

Indirect function on excel

 Solved

Hello, I need to know how I can add the following to an exsiting cell reference in a whole column. ='Sheet1'!A2 to show =INDIRECT("'Sheet1'!...

10 replies Last reply on 13 Apr 2011 by
tipsindeed

Reset gt-s3653 phone security password

 Solved/Closed

Hello, sir I am jass pls help me forgot my gt-s3653 phone security password. My IMEI No:- 35804003285049/1. Reply as soon as possible codes ! Thanks

Last reply on 12 Apr 2011 by
Ambucias

Checkbox selection

 Solved

Hello, I've got two checkboxes,CheckBox1 and CheckBox2.I would like to make only one of the checkboxes to be selected at any one time.If one become ...

1 reply Last reply on 11 Apr 2011 by
TrowaD

Searching names in drop down list in excel 07

 Solved

Hello, I have placed a drop down listbox in my excel 2007 work sheet and selected the range of names which are in the same sheet. In the list I hav...

5 replies Last reply on 11 Apr 2011 by
RWomanizer

How do i change or reset the password to my w

 Solved

Hello, I recently bought a laptop from a second hand store. However the previous owner had a password set on the only administrator account and i ...

1 reply Last reply on 11 Apr 2011 by
pcsces

Mail.com server settings

 Solved

Hello, My Indiamail.com which was in Mail.com is not working from 08.04.11. what is happening? I need that ID very essentially. What to do? Sam...

1 reply Last reply on 11 Apr 2011 by
pcsces

Formula for text

 Solved

Hello, I am trying to make a formula for text. This is what i want; In one coloumn i have a category and i want the next coloumn to be the in...

3 replies Last reply on 6 Apr 2011 by
aquarelle

Fill a series stop with value of another cell

 Solved

Hello, I wish to fill to the right, rows whose number of entries depends on a cell to the left, and whose length is therefore variable. e.g. ...

3 replies Last reply on 4 Apr 2011 by
RWomanizer

Excel formula problem

 Solved

Hello, Please Help =IF(V12=1,2*(R12*50%)) I have a problem with this formula: What I need, is if v12 = 1, 2, 3, or 4 count R12 times 50%...

3 replies Last reply on 4 Apr 2011 by
Stormdronk

Forgot password

 Solved

Hello, i forgot my admin password of my windows xp. how do i log on now? Plz help Configuration: Windows XP / Internet Explorer 6.0

1 reply Last reply on 3 Apr 2011 by
bionik

Looking for duplicate numbers from one column

 Solved

Hello, i have 4300 old applicant numbers which i need to check against 3300 new applicant numbers and highlight duplicates. these are in two colu...

6 replies Last reply on 3 Apr 2011 by
rizvisa1

Excel: if a1 = a 4 the comy content of b1,2,3

 Solved

Hello, Please help! If A1 = a 4 the comy content of b1,2,3,4,5 to c1,2,3,4,5 The 4 in a1 are generated by a formula. Thanks Confi...

3 replies Last reply on 3 Apr 2011 by
rizvisa1

Formulas to search for certain words in cells

 Solved

Hello, I have monthly bank statements that are downloaded into excel, over 2500 line items. In Column A, I have the description of the transac...

4 replies Last reply on 2 Apr 2011 by
venkat1926

System password remove

 Solved

Hello, how i can remove system password Configuration: Windows XP / Internet Explorer 7.0

1 reply Last reply on 2 Apr 2011 by
bionik

Excel - help!

 Solved

Hello, I require a formula which will recognise months in a column and select taht value from a different cell on the same row. The data is the...

1 reply Last reply on 1 Apr 2011 by
TrowaD

Format using macro

 Solved

Hi I have some data in sheet1. Eg: Column A Column B Column C Column D 1 2 3 4 ...

16 replies Last reply on 29 Mar 2011 by
harry

Filter rows in one sheet

 Solved

Hello, I have large amounts of data in one work sheet(say it as Sheet1) and another worksheet(sheet2) has few records(100) which are also present ...

5 replies Last reply on 29 Mar 2011 by
RWomanizer

Converting rows data into columns on conditon

 Solved

Hello, I have data which looks like below ColA-----------ColB-------ColC--------ColD------------ColE---------ColF-------ColG----ColH-------- AA-...

3 replies Last reply on 29 Mar 2011 by
RWomanizer

Delete cells/rows but keep row info intact

 Solved

hello, I am trying to import data from an excel spread sheet to access. I want to clean up my excel report before I import the date. In my report...

2 replies Last reply on 25 Mar 2011 by
TrowaD

Looking for value in a column a

 Solved

Hello, I have to prepare an invoice and calculate the amount of shipping. This is the lay out: I have to compare the subtotal value, E16, in ...

3 replies Last reply on 24 Mar 2011 by
rizvisa1

Dates in excel

 Solved

Hello, I have a list of people's birthdays in a list in Excel. I want to retain only the day and month of the birthday and get rid of the year. For ...

1 reply Last reply on 24 Mar 2011 by
RWomanizer

Excel comparing 2 columns removing duplicates

 Solved

Hi, I would like to cmpare 2 columns in an Excel spreadsheet & remove duplicates from Column B if any matching fields are found e.g. A B 1 ...

3 replies Last reply on 23 Mar 2011 by
rizvisa1
Results 1701 - 1750 out of a total of 2,608